Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL - Is LEFT an invalid field name?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL - Is LEFT an invalid field name?
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01428149
Message ID:
01428149
Vues:
112
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform