Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with Update - SQL
Message
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00497606
Message ID:
00497609
Views:
11
Hmmm... I guess VFP is getting confused and thinking THISFORM is a table alias.

What if you put parentheses around thisform.firstname_txt.value:
update employeemain set firstname = <b>(</b>thisform.firstname_txt.value<b>)</b>;
where employeeId = thisform.employeeId_txt.value
Does that help?

--Brad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform