Re: Breaking Long Query into multiple statements ?

That does not work. I had to revert back to a IF ENDIF in my scan as I
wanted to scan for 20 fields and the Scan For would not let me put
together anything that added up to more than 250 characters even
trying to add two variables would not do it..
TonySper


"Mike McDowall" <m.a.mcdowall@xxxxxx> wrote in message
news:6kua9114f06im3qtnvqn2bsklscog6oue5@xxxxxxxxxx
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.


.

Relevant Pages
Loading