<html>
<head>
<style>
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
FONT-SIZE: 10pt;
FONT-FAMILY:Tahoma
}
</style>
</head>
<body class='hmmessage'>
<BR>Hi Chuck:<BR>
<BR>
Actually, I like seeing <BR>
<BR>
SELECT RECORD if " " <> ITEM of RECORD <BR>
<BR>
It tells me what is going on immediately with respect to<BR>
what records are being selected. <BR>
<BR>
How complicated of a logical expression would we want to<BR>
bury in the dictionary?<BR>
<BR>
If you are willing to add another item to you record and modify<BR>
the programs that populate the file you could<BR>
create a blank / no blank switch. <BR>
; PDL<BR>
Record NO_BLANKS ; ...{based on RECORD}<BR>
i.e. Item SWITCH SELECT "N" <BR>
<BR>
The programs that populate the base record will have to set SWITCH.<BR>
; QDESIGN or QTP<BR>
e.g. Item SWITCH final "B" IF " " = ITEM of RECORD &<BR>
else "N" <BR>
<BR>
Probably, not worth the effort!<BR>
<BR>
Regards,<BR>
Peter Bateman<BR>
<BR>> Subject: Select statement on an Item in the Dictionary<BR>> Date: Tue, 16 Oct 2007 10:42:08 -0400<BR>> From: Chuck.J.Lowe@questdiagnostics.com<BR>> To: powerh-l@lists.sowder.com<BR>> <BR>> I know you can use a SELECT statement in the dictionary on an ITEM. I<BR>> can use an actual value and even a blank (in quotes). <BR>> But there has to be a value in it. Is there anyway to say SELECT if the<BR>> field is Not Blank? We have a file that has blanks and not blank in<BR>> them. The not blanks are many and can be any value, hence my question.<BR>> I.E., I would constantly be changing the dictionary to have<BR>> redefinitions for all the values.<BR>> <BR>> Please don't reply with you can say SELECT if ITEM <> " " in Quiz, QTP<BR>> etc. I already know that. <BR>> <BR>> Chuck Lowe<BR>> Senior Programmer/Analyst<BR>> Office: (610)650-6679<BR>> Fax: (610)650-2114<BR>> <BR>> ------------------------------------------<BR>> The contents of this message, together with any attachments, are<BR>> intended only for the use of the person(s) to which they are<BR>> addressed and may contain confidential and/or privileged<BR>> information. Further, any medical information herein is<BR>> confidential and protected by law. It is unlawful for unauthorized<BR>> persons to use, review, copy, disclose, or disseminate confidential<BR>> medical information. If you are not the intended recipient,<BR>> immediately advise the sender and delete this message and any<BR>> attachments. Any distribution, or copying of this message, or any<BR>> attachment, is prohibited.<BR>> <BR>> -- <BR>> = = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>> Mailing list: powerh-l@lists.sowder.com<BR>> Subscribe: &quot;subscribe&quot; in message body to powerh-l-request@lists.sowder.com<BR>> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to powerh-l-request@lists.sowder.com<BR>> http://lists.sowder.com/mailman/listinfo/powerh-l<BR>> This list is closed, thus to post to the list you must be a subscriber.<BR>> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.<BR><BR><br /><hr />Send a smile, make someone laugh, have some fun! <a href='http://www.freemessengeremoticons.ca/?icid=EMENCA122' target='_new'>Start now!</a></body>
</html>