Trouble With SQL Code

[William McFarland]

Trying to add a record to a database. FP will not accept the follow as the
query.

INSERT INTO Disbursements ( GranteeNum )
VALUES ( '::GranteeNum::' )

It will accept the query with percent signs (see below), but the page will
not work. FP re-write the query with :: replacing %% and reports errors in
the query the next time I try and edit in the DRW. Any suggestions would be
appreciated. Thanks.

INSERT INTO Disbursements ( GranteeNum )
VALUES ( '%%GranteeNum%%' )