SQL request in vCursor : "or"

Ruslan Zasukhin sunshine at public.kherson.ua
Thu Jan 6 12:14:09 CST 2005


On 1/6/05 12:06 PM, "Olivier" <vidal_olivier at yahoo.fr> wrote:

>> It will be more useful to see the SQL String which you get
>>     BTW, you can EASY see SQL string you build in the V4RB_Log file.
>> 
> LOG :
> 
> Cursor_Ctor...
> PARAM: instance = 27059408
> PARAM: inDB = 26180540
> PARAM: inSQLstr = "SELECT nom FROM personne WHERE corbeille=false and
> (rep1=1 or rep2=1 or rep3=1 or rep4=1)"
> PARAM: inCursorLocation = 2
> PARAM: inCursorType = 2
> PARAM: inDirection = 2
> 
> Rep1, Rep2, Rep3, Rep4 are VBYTE.

Aha.

So what happens? Crash ?

How it notworks?

Does log show any error info ?

What viSQL show if do this query again this db ?
If viSQL also show problem send me db and we test here



-- 
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-beta mailing list