General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only