That should read: date data type

>I do not see how either one would work because you should get a data type mismatch when you include a date data type in a string. I usually build my SQL:
>
>lcSQL = 'insert into laypay ("date") values (' + "'" + dtoc(ldDate) + "', fvLaypay)"
>
>x=SQLExec(gnHandle, lcSQL)
>
>>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