Hi Robert?
Why don't you use bind parameters?
LOCAL ldDate,lyCurrency, luRate
ldDate=DATE()
lyCurrency=$25641
luRate=.NULL.
=SQLEXEC(handle, "insert into table test (tr_date,tr_currency,tr_rate) values (?ldDate,?lyCurrency,?luRate)")
MartinJ
>i want to do a insert in a table with sqlexec
>
>table test
>
>field : tr_date,tr_currency
>
>
>i got an error when i do that
>
>"insert into table test (tr_date,tr_currency,tr_rate) values (" + date()+",'"+l_cur+"')"
>
>
>and i know is about the date()
>
>
>how can i do
>
>
>
>thanks