Hi all,

The question i have is:
When i'm creating a string to use at a SQLEXEC(), i'm having a problem with dates, because SQL Server receives it from another format. Imagine this code:

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 ...

I know i could solve it with a remote view, but i don't want! I just want to make an update operation.

Is there a way to get the date format from the SQL S.(and i could prepare the right instruction)?

Any ideas?

Thanks,

Ricardo