Hi!
Following should work:
ldDate = DATE()
x = SQLEXEC(gnHandle,'INSERT INTO laypay ("date") VALUES (?ldDate)')
>Hi,
>
>I have a remote view 'rvLaypaty' linked to a Paradox table 'laypay'. Unfortunately the Paradox table has a field name called 'date' which is a reserved SQL name, so I am unable to use the View designer for this particular job.
>
>I have tried using SQLEXEC in the following code...
>
>x = SQLEXEC(gnHandle,'INSERT INTO laypay ("date") VALUES (DATE()),fvLaypay)
>
>...all works OK, however the following I can't get to work...
>
>ldDate = DATE()
>x = SQLEXEC(gnHandle,'INSERT INTO laypay ("date") VALUES (ldDate),fvLaypay)
>
>...I have tried macro substitution and everything I can imagine to get it to work with anything but DATE(), to no avail.
>
>Any help would be most appreciated.
>
>Regards
>Doug Johnston
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.