Thanks Sergey,

We did some checking and found conditions where the SQL statement did exceed the length.

Thanks for the info.

Ken


>Any Fox 2.x command cannot be longer than 2048 bytes. The same is true for macro substitution.
>
>>We are getting a an error "Coompiled code too long"
>>
>>This is occurring when we issue a
>>
>>&cmd
>>
>>where cmd is a sql select statement. A very nasty sql select statement built on the fly. How long can this statement be before we bomb?
>>
>>Ken Wardwell