>>>Hello Fabio
>>>
>>>Thanks for your pointers! ja, my sql command was way too long {gr} - it was 15114 cahracters long just for the filter clause.
>>>
>>>thanks again for your help!
>>>
>>>>>Hello everybody.
>>>>>
>>>>>does anyone know what the limitation for the character length of the WHERE string in the local SQL command is (VFP 6, SP 5)?
>>>>>
>>>>>thanks in advance for your help!
>>>>
>>>>2 LIMITS:
>>>>

>>>>1. LEN("SELECT SQL COMMAND")<=8192
>>>>2. SYS(3055) - FOR and WHERE Clause Complexity
>>>>

>>
>>Macro ?
>>Put the literal strings into variables.
>
>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.

does't build cWhereStr, build a cursor

CREATE CURSOR _Inlist_ (item C(...
INSERT INTO _Inlist_
....
SELECT ... WHERE field IN (SELECT item FROM _InList)
USE _Inlist_