V4RB Query size

Ruslan Zasukhin sunshine at public.kherson.ua
Tue May 27 00:26:03 CDT 2003


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?

No.

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

Hmm, as far as I see, no limit.

You sure that OR item you add is correct?
Have you try put it in forward?

May be limit in some stack variable...
No, I still do not see problem.

IF you can send me project that reproduce this.

> If this is by design, is there some way I can determine in advance whether a
> particular query will cause the error?   Perhaps I should just test the string
> length?
> 
> I'm using V4RB 1.9.7, RB 4.5.2, (OS 10.2.6).

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



More information about the Valentina mailing list