Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody,
I gat a question, i want to do a 3 conditions with where like that :
test:
LOAD [Code],
FROM
assur.qvd
(qvd) where [Code]='X'
and [Code]='Y
and [Code]='Z'
;
That's not works!
I tried ( where [Code]='X' and 'Y' and 'Z) too'..
But if i just do where
='X' , that is to say 1 condition, that works!!!
How can i do?
Thanks a lot!
you are missing a ' on the and [Code] = 'Y line.
But you will never get values here, as Code cannot both be X and Y at the same time.. Are you sure you do not mean OR?
Where [Code]='X' or [Code]='Y' or
='Z'
you are missing a ' on the and [Code] = 'Y line.
But you will never get values here, as Code cannot both be X and Y at the same time.. Are you sure you do not mean OR?
Where [Code]='X' or [Code]='Y' or
='Z'
where wildmatch(,'X','Y','Z')>0
Andrei
Shame on me, that was "OR" , not 'AND' , thank you so much Simen!
(Yes i made a mistake , i missed the ' because i did a bad copy/paste!!
Thanks!!