Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL string in listbox rowsource greater than 255
Message
From
25/09/1998 12:46:33
 
 
To
25/09/1998 12:26:14
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00140856
Message ID:
00140866
Views:
28
>Hi David ----
>
>A workaround would be to create a parameterized view and use that as the RowSource....

Thanks for the input John. I originally was using a view but abandoned it after failing to be able to add parameters to both the WHERE and the ORDER BY clauses. I read a tip in FoxPro Advisor that showed how to use ?parameterS in the order by clause but I couldn't get it to work. Anyway, to make a long story short, I've written the code to collect various sorting and filtering information from the user and stuff it into the rowsource of a listbox using ¯osubstitution. It worked great until I sorted and filtered to much.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform