Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grrr - 256char limit on SQL Statments???
Message
 
 
À
26/04/2000 18:35:33
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00363839
Message ID:
00363962
Vues:
17
Arne,

Are you typing the SQL into the property sheet? If so that is limited because of the way VFP handles the memo field where the properties are stored.

If you are setting it in code, VFP has a limit of 256 characters for a single string constant so you have to use code like:
... = "select blah, blah, blah" + ;
   "from MyTable"
>On a form is a page with a ListBox. The list box data source is an SQL statement. But, when I'm entering the actual statement, VFP 5.0 truncates at 256 chars! Argh! Is this 'unchangeable' behaviour or am I missing something (the docs are of no help)? Surely 256 characters for an SQL statement is way too few?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform