Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Limitation of Where String in local SQL?
Message
 
 
To
02/10/2005 15:40:22
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01055360
Message ID:
01055378
Views:
11
>jes, but how exactly do you mean?
>
>a simplyfied example of my situation looks like this:
>cWhereStr = "Inlist('12345', 'test', 'hallo', ...)
>
>select ;
>   fld1, ;
>   fld2, ;
>   ... ;
>   from table1 q_a, table q_b ;
>   where &cWhereStr ;
>   group ... ;
>   into...
>there are some fields which are variable though macros, as well as the goup clause and the from clause.

If you use a cursor or array instead of INLIST there wouldn't be a limit on the # of items.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform