Right, that's what I can't get the editor in this IDE to let me do.

I think though, that verifying the statement in the editor was a red herring. Watching the transaction logs for the network service that connects the device to the database made me think that the ODBC error that I am getting from the device is because it is sending a pipe delimited string to the database that is larger than the first field targeted, and that the stream of data is not being sorted into the fields that I am trying to update. I may have to break this up into a separate SQL statement for each field that needs updating.

Thanks Sergy.

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