>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.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.