Select statement on an Item in the Dictionary

[Peter Bateman]

Hi Chuck:
 
  Actually, I like seeing 
   
   SELECT RECORD  if  " " <> ITEM of RECORD 
 
  It tells me what is going on immediately with respect to
  what records are being selected. 
 
  How complicated of a logical expression would we want to
  bury in the dictionary?
 
  If you are willing to add another item to you record and modify
  the programs that populate the file you could
  create  a blank / no blank switch. 
; PDL
  Record NO_BLANKS                        ; ...{based on RECORD}
  i.e. Item SWITCH     SELECT "N"                             
                                
  The programs that populate the base record will have to set SWITCH.
; QDESIGN or QTP
  e.g. Item SWITCH final "B" IF " " = ITEM of RECORD &
                              else  "N"  
 
  Probably, not worth the effort!
 
Regards,
Peter Bateman
> Subject: Select statement on an Item in the Dictionary> Date: Tue, 16 Oct 2007 10:42:08 -0400> From: Chuck.J.Lowe at questdiagnostics.com> To: powerh-l at lists.sowder.com> > 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.> > -- > = = = = = = = = = = = = = = = = = = = = = = = = = = = => Mailing list: powerh-l at lists.sowder.com> Subscribe: &quot;subscribe&quot; in message body to powerh-l-request at lists.sowder.com> Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to powerh-l-request at lists.sowder.com> http://lists.sowder.com/mailman/listinfo/powerh-l> This list is closed, thus to post to the list you must be a subscriber.> Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
_________________________________________________________________
Send a smile, make someone laugh, have some fun! Start now!
http://www.freemessengeremoticons.ca/?icid=EMENCA122
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20071016/027ebc9b/attachment.html