V4RB Query size

[Christian Schmitz]

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

... and ((my_code >='001') and (my_code <='845'))...

should do the same with much less lines.

So it may be bad in Valentina that the query limit is not smaller ;-)

mfg
Christian

-- 
Four thousand functions in one REALbasic plug-in. The MBS Plugin.

<http://www.monkeybreadsoftware.de/realbasic/plugins.html>