|
Likewise if you're using new proc you may use the
original ERRMSG file indicator as
HSELECT FILE WHATEVER
STON
HSAVE-LIST LISTNAME
P
IF E = 401 GO somewhere as there were no items
selected.
----- Original Message -----
Sent: Tuesday, February 03, 2004 9:02
AM
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.
_______________________________________________
u2-users mailing
list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
|
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
