It should be
date_updt={08/25/2005}
or you've to change date_updt to the character type and then do conversion to date data type in VFP code.
>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.
--sb--