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

Create the Query as a cursor or P-View prior to setting up the listbox, and then use the Alias or Fields RowSourceType for the ListBox. Add a Requery() for the source in the ListBox's Requery method.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform