Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Grrr - 256char limit on SQL Statments???
Message
De
26/04/2000 23:36:06
 
 
À
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:
00363981
Vues:
13
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform