Let me ask you this (or any one else who is lurking), if a date field in a VFP free table is 8 places wide, is that 6 digits and 2 slashes? Or is it 8 digits and no slashes?


>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.