Select statement on an Item in the Dictionary

Lowe, Chuck J Chuck.J.Lowe at questdiagnostics.com
Tue Oct 16 09:42:08 CDT 2007


I know you can use a SELECT statement in the dictionary on an ITEM.  I
can use an actual value and even a blank (in quotes). 
But there has to be a value in it.  Is there anyway to say SELECT if the
field is Not Blank?  We have a file that has blanks and not blank in
them.  The not blanks are many and can be any value, hence my question.
I.E., I would constantly be changing the dictionary to have
redefinitions for all the values.

Please don't reply with you can say SELECT if ITEM <> " " in Quiz, QTP
etc. I already know that. 

Chuck Lowe
Senior Programmer/Analyst
Office: (610)650-6679
Fax:    (610)650-2114

------------------------------------------
The contents of this message, together with any attachments, are
intended only for the use of the person(s) to which they are
addressed and may contain confidential and/or privileged
information. Further, any medical information herein is
confidential and protected by law. It is unlawful for unauthorized
persons to use, review, copy, disclose, or disseminate confidential
medical information. If you are not the intended recipient,
immediately advise the sender and delete this message and any
attachments. Any distribution, or copying of this message, or any
attachment, is prohibited.



More information about the powerh-l mailing list