>
>lcInstruction = "Update clients set date_payment = '" + ttoc(ldDatePay) + "' where codCli = ....."
>
>When i do a SELECT instruction from my table, i see that the date value is 2000-08-09, but the value of my update is wrong. And, to help wprst a little bit, TTOC() function doesn't give a dam with the SET DATE ...
>

Ricardo,
I use the SQL Server T-SQL function CONVERT() for my datetimes.

lcsqlexec = [update clients set date_payment = convert(datetime,']+;
   transform(ldDatePay)+[' where codCli = .....]
lnretval = sqlexec(lnsqlconn,lcsqlexec)

HTH.