Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL command too complex - what should I do?
Message
From
10/12/1999 15:50:14
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00301958
Message ID:
00301987
Views:
28
>Just now I got this error message. I know why it happened, it's because I choose lot's of items in multilist, which affect on Init method one of my other controls. I think, it's VFP limitation 255 char on the macro string. So, my questions are:
2) How can I resolve this situation? Do I need to calculate length of my macro string, finding space, etc. Would be a real PITA :(

Could you limit the selections in the multilist? (if normal use says 3-4 choices is adequate, 15 kills your code, limit the picklist to 10 at a time)

Assuming your macro is something like: Select ... Where ¯ostring,
Maybe you could do: Select ... Where value1 In Select value2 where value3=.T.
(value1=keyvalue, value2=picked value, value3=value2 was picked or not)

Or maybe I/we don't have enough info on what you're trying to do?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform