Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL - Is LEFT an invalid field name?
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL - Is LEFT an invalid field name?
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01428149
Message ID:
01428149
Views:
113
Compile or run this and you get a syntax error. It appears the field name left is not allowed. However, I was able to select it with SQL. This statement has 42 fields in my program and it took a while to narrow it down to this one field. Remove it and it runs, leave it in and CRASH! Anyone got any comments?
update pageobj ;
set left = c_pageobj.left ;
from c_pageobj ;
where c_pageobj.k_pageobj = pageobj.k_pageobj ;
and c_pageobj.k_page = pageobj.k_page
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Next
Reply
Map
View

Click here to load this message in the networking platform