There is also a keyword REQUIRE.SELECT ... Cheers, Wol
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 03 February 2004 14:02 To: U2 Users Discussion List Subject: Memo: Re: [UD] Determining if list exists Hi Chris, I believe there is the IF S or the IF #S construct that you can use in a proc to test the existence or otherwise of a select list. So if you modify your proc: HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H< PH IF #S G 10 HLIST AR PAYMENT.DATE LPTR P 10 O No items Selected that should save a few trees..... cheers, asvin "Chris Bugosh" <[EMAIL PROTECTED] on 03 Feb 2004 13:51 Please respond to U2 Users Discussion List <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] To: <[EMAIL PROTECTED]> cc: bcc: Subject: [UD]Determining if list exists Is there a Unidata or Uniquery command that tells you if a select list exists? In UniBasic I can use a SelectInfo function to determine if a list exists, but I can't find a way to do it at the TCL prompt. I have the following PQN PROC. The PROC itself works fine if there is something to return from the selection criteria. However, if nothing is selected in the SELECT statement (like the one below would if we ran it today), the PROC does what it is told and lists the whole file, since it is never given a list, resulting in a huge printout of every AR transaction. HSSELECT AR WITH PAYMENT.DATE GE "2-9-04" STON P HSAVE-LIST ARLIST P HGET-LIST ARLIST STON H< PH HLIST AR PAYMENT.DATE LPTR P Thanks for any suggestions you can give. Chris ****************************************************************** This message originated from the Internet. Its originator may or may not be who they claim to be and the information contained in the message and any attachments may or may not be accurate. ****************************************************************** (See attached file: C.htm) _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users ************************************************************ HSBC Bank plc Registered Office: 8 Canada Square, London E14 5HQ Registered in England - Number 14259 Authorised and Regulated by the Financial Services Authority Member of the HSBC Bank marketing group. We sell life assurance, pensions and collective investment schemes and advise only on our own range of these products. ************************************************************ _____________________________________________________ This transmission has been issued by a member of the HSBC Group "HSBC" for the information of the addressee only and should not be reproduced and / or distributed to any other person. Each page attached hereto must be read in conjunction with any disclaimer which forms part of it. Unless otherwise stated, this transmission is neither an offer nor the solicitation of an offer to sell or purchase any investment. Its contents are based on information obtained from sources believed to be reliable but HSBC makes no representation and accepts no responsibility or liability as to its completeness or accuracy. *********************************************************************************** This transmission is intended for the named recipient only. It may contain private and confidential information. If this has come to you in error you must not act on anything disclosed in it, nor must you copy it, modify it, disseminate it in any way, or show it to anyone. Please e-mail the sender to inform us of the transmission error or telephone ECA International immediately and delete the e-mail from your information system. Telephone numbers for ECA International offices are: Sydney +61 (0)2 9911 7799, Hong Kong + 852 2121 2388, London +44 (0)20 7351 5000 and New York +1 212 582 2333. *********************************************************************************** _______________________________________________ u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users
