Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL-statement too long???
Message
De
21/09/1998 05:09:41
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, Royaume Uni
 
 
À
21/09/1998 03:13:53
Marco Beuk
Innovero Software Solutions
The Hague, Pays-Bas
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00138926
Message ID:
00138948
Vues:
14
>When i paste a SQL-statement generated by a view i get an 'unrecognized phrase/keyword in command' error.
>Only when i reduce my SQL-statement in my SQLEXEC() to 255 characters or less it works.
>
>Why can't i use strings larger then 255 characters?
>
>Marco Beuk.

A single line of code cannot be > 255 characters, however a single command can be up to 8192 characters long.

You need to use the ; syntax to break up the command into a number of lines.
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform