General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Thanks
MA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only