Hi to all,
I've to update my data on a Vfp table using ODBC driver.
I don't know which format use for date field
I've tried to update using these commands
cmdStr = "UPDATE myTable SET myDateField = CTOD('" + DTOC( mydate ) + "') WHERE cClientCode == myClientcode"
SQLEXEC(myConnection, cmdStr)
There is a problem, these commands exchange month with day (I'm using the date format DD/MM/YYYY and on my table I've see the date updated with the format MM/DD/YYYY)
So if a date like 20/07/1998 is valid for VFP ( if I do ? CTOD(myDate) I've the date ) the same date isn't write by ODBC driver on my table.
Which setting have I missed to set ?
Any other suggestion ?
TIA
Renato