SQL request in vCursor : "or"

[Olivier]

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




> So as far as I see you get
>
>     ctrlAdres.base,"SELECT nom FROM personne WHERE
>     corbeille=false and (rep1 = string or rep2 = string ....
>
> I see mistake. You have forget single quotes around 'string'
>
Rep1.. are vByte

>
>> If I remove "OR", it works :
>> cur=new vcursor(ctrlAdres.base,"SELECT nom FROM personne WHERE
>> corbeille=false and (rep1="+t+")",2,2,2)
>
> -- 
> 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
> -------------------------------------------------------------
>
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>