What am I doing wrong with this query

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

What am I doing wrong with this query

Message

27/02/2007 18:56:06

Simplicio Jison Jr
Davao, Philippines

27/02/2007 17:14:57

Rajani Puvvula
Hamilton, Nouvelle Zélande

Information générale

Forum:

Visual FoxPro

Catégorie:

Base de données, Tables, Vues, Index et syntaxe SQL

Titre:

Re: What am I doing wrong with this query

Versions des environnements

Visual FoxPro:

VFP 9 SP1

Divers

Thread ID:

01199358

Message ID:

01199383

Vues:

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

Répondre

Fil

Voir

Click here to load this message in the networking platform