I am working with data that is being collected with a wireless portable data terminal. I am updating several text fields, a date field and a time field in a VFP6sp5 free table using an ODBC FoxPro driver. The date data is being sent as a string and the ODBC FoxPro driver generates an ODBC error 'data type mismatch'.
This is the SQL command being sent by the device:
UPDATE cdm20itm SET itm_loctn='TEST3', date_updt='{08/25/2005}', pers_updt='RMS' WHERE (cdm20itm.itm_numb = '000-000-000')
The design tool for the language that the device uses will not allow me to edit the SQL so that the ticks are not there.
Any clues for a work around? I have tried all sorts of format, escapes, looked at configuration of the ODBC driver, to no avail. Or is it just something I haven't learned yet?
Thanks.
Opportunity is missed by most people beacuse it is dressed in overalls, and looks like work --- Thomas Edison