SQL request in vCursor : "or"

Olivier vidal_olivier at yahoo.fr
Thu Jan 6 10:48:15 CST 2005


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



More information about the Valentina-beta mailing list