Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql -select too long
Message
From
07/03/2006 05:44:54
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Sql -select too long
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP
Network:
Windows XP
Database:
MySQL
Miscellaneous
Thread ID:
01101989
Message ID:
01101989
Views:
64
HI ALL ,

here the error message 'Command contains unrecognized phrase/keyword' . I thing my select is too long . what can I do ?
SQLEXEC(gnConnHandle,'SELECT rub_code,rub_libelle,rub_alias,;
 rub_touche,trub_libelle,rub_etat,;
 ser_code,trub_code FROM Rubrique Rubrique INNER JOIN Typerubrique Typerubrique;
 ON Rubrique.trub_code=Typerubrique.trub_code;
 WHERE ser_code=?Cser and SUBSTR(rub_libelle,1,3) NOT IN("acc","ind")','Cursdetail')
Best regards
Next
Reply
Map
View

Click here to load this message in the networking platform