FIXED: V4RB Query size

[Ruslan Zasukhin]

on 5/27/03 12:16 AM, Fitzbew at aol.com at Fitzbew at aol.com wrote:

> Does Valentina have a limit to SQL query size?   In an app I am developing, I
> build a query that has a large number (hundreds) of 'OR' statements (e.g.,
> ... AND (my_code = '001' OR my_code = '002' OR my_code ='003'...).   In this
> particular scenario, I can build a query that has up to about 845 such
> elements 
> without any problems.   But when I add one more "OR" element, Valentina
> suddenly returns a "Expected Key Word From" (Error code 600) error.   The
> query is 
> NOT missing a FROM key word. I can then remove a single "OR" element and it
> works fine.   The query that generates the error returns 38,357 to Len(query).
> 
> The number of "OR" elements I can "get away with" varies depending on the
> length of the query.    I can drop out other "AND" statements and I find I can
> then add more "OR" elements.    So I assume the limitation is query size.


I think I have found problem.

FIXED. 

I am building new V4RB beta and upload in nearest 20-30 minutes.
So please check it and let me know if it works.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------