SQL request in vCursor : "or"

[Olivier]

Ruslan,

Apparently, there is a crash because there is no records.
(If I add records before the query, there are no crashes)

But it is strange because this query (without "OR" nor "AND") does not 
provoke crash :
> cur=new vcursor(ctrlAdres.base,"SELECT nom FROM personne WHERE 
> corbeille=false and (rep1="+t+")",2,2,2)

Olivier


Le 6 janv. 05, à 10:48, Olivier a écrit :

> Hi,
>
> Why this query it works more in Valentina 2 ?
>
> t="string"
> cur=new vcursor(ctrlAdres.base,"SELECT nom FROM personne WHERE 
> corbeille=false and (rep1="+t+" or rep2="+t+" or rep3="+t+" or 
> rep4="+t+")",2,2,2)
>
> If I remove "OR", it works :
> cur=new vcursor(ctrlAdres.base,"SELECT nom FROM personne WHERE 
> corbeille=false and (rep1="+t+")",2,2,2)
>
> thank you
>
> olivier
>
> _______________________________________________
> Valentina-beta mailing list
> Valentina-beta at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina-beta
>