Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grrr - 256char limit on SQL Statments???
Message
 
 
To
26/04/2000 18:35:33
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00363839
Message ID:
00363962
Views:
16
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
Previous
Reply
Map
View

Click here to load this message in the networking platform