Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What am I doing wrong with this query
Message
From
27/02/2007 18:56:06
Simplicio Jison Jr
Davao, Philippines
 
 
To
27/02/2007 17:14:57
Rajani Puvvula
Hamilton, New Zealand
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: What am I doing wrong with this query
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01199358
Message ID:
01199383
Views:
25
This message has been marked as the solution to the initial question of the thread.
try this
Perhaps EMPTY(it.status) when there is null value
SELECT it.pkey,it.code,it.usercode ;
FROM it ;
WHERE EMPTY(nvl(it.status,'')) AND ;
(INLIST(ALLTRIM(UPPER(nvl(it.code,''))),'PT01','PT02','PT03','PT04') OR ;
INLIST(ALLTRIM(UPPER(nvl(it.usercode,''))),'PT01','PT02','PT03','PT04')) ;
INTO CURSOR cPts NOFILTER
Roses are #FF0000 Violets are #0000FF all my base are belong to you
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform