>Hi All:
> I am using an ODBC driver created by a company in Cincinnati Ohio call ComputerEase. I am trying to save the data in the table, however, I am getting the following error message: "[ComputerEase][ODBC Driver] Expected lexical element not found:="
>I am unsure of what to do at this point. Any help will be greatly appreciated.
>The following is my code at the point where I am getting error.
>
>***Code***
> *--Save
> lcsql = "UPDATE jcjob SET jcjob.name = " + CHR(34) + ;
> ALLTRIM(cCoName) + CHR(34) + ;
> " where jcjob.jobnum = " + Alltrim(nCoIId)
> IF sqlprepare(ThisForm.handle,lcsql)>0 ***(Error message occurs here)***
> IF sqlexe(Thisform.handle) > 0

I have not worked with ComputerEase, but SQL Server does not like ", CHR(34) as a delimiter. What happens if you use a ' instead?

And what about ALLTRIM( nCoIID )? Does that need to be wrapped by ' or "?