>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()You cannot mix strings with date types. Convert the date to a string in the desired format using DTOS() or DTOC() or some other function.
Also the whole "INSERT INTO" string has to go inside the SQLEXEC() function pointing to the proper open connection handle as first parameter. See SQLEXEC() in help for more details.