Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC Driver
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
ODBC Driver
Miscellaneous
Thread ID:
00456588
Message ID:
00456588
Views:
76
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
Map
View

Click here to load this message in the networking platform