Re: Breaking Long Query into multiple statements ?

On Tue, 24 May 2005 09:30:09 -0700, "Ook" <no usenet spam at zoot al
dot com> wrote:

>
>"Andrew Howell" <ajh@work> wrote in message
>news:uqjNedDYFHA.2484@xxxxxxxxxxxxxxxxxxxxxxx

>> I may be wrong but hopefully you can extend this first limit with macro
>> substitution, eg:
>>
>> m.cmd="WHERE blah blah blah blah......."
>> SELECT blah blah blah blah....... &cmd
>>
>
>Unfortunately you can't do this. It will compile but will throw an error at
>runtime. The total length of the sql string is limited, and AFAIK can't be
>exceeded in any single query.
>
Are you sure ?

I do this in VFP5 (so the query can be generated dynamically) and I am
pretty sure I get big advantage in terms of length of statement.

Mike.
.