>>I am trying to pass date fields via ODBC into VFP table. I am getting ODBC error 22005 which seems to indicate a date format error. I have tried various date formats but can not find one that works. Does anyone know what the correct format should be in the table that I am sending the date field from.
>>Barry
>
>Use parameters.
>
>ldDate = DATE()
>SQLEXEC(handler, "SELECT * FROM VFPTable WHERE DateField = ?ldDate","SomeCursor")
>
>
>BTW The last ODBC driver for VFP was for VFP6. If your tables use new field types this ODBC won't work.
Hi Borislav,
I am not doing a query, I am trying to insert data into a free VFP table from a simple text file on a hand-held data device that has 3 "fields" - Type,Date,User. eg "typeb","31/08/2011","myuser" - I have set up the ODBC connection but when I try to send the data set from the text file into the VFP table I get the ODBC error 22005. It appears to be something to do with the format of the date in the text file that is causing the problem.
Barry