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