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:
00363889
Views:
13
You could set the RowSourceType to Alias or Fields and put the SQL statement in the Requery method of the listbox.

Rick

>This has got to be something most people already know - sorry if it's a dumb ?. (UT KB and FAQs have nothing on this...)
>
>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?
>
>-Arne
Rick Hodder
MCP Visual Foxpro
C#, VB.NET Developer
Independent Consultant
www.RickHodder.com
MyBlog
Previous
Reply
Map
View

Click here to load this message in the networking platform