>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.