At 12:12 AM 02/05/2004, you wrote:
[snipped]
The same applies (here) with a BASIC program that :
0011 SENTENCE = \SELECT MD WITH F! RUBBISH\
0012 EXECUTE SENTENCE CAPTURING JUNK RETURNING ERR
In this case ERR = 0 if there's no items, not 401 under vanilla (R83, AP) Pick
Unless.. Is there a
. :-) )
Take care,
Bruce M Neylon
Health Care Management Group
Mark Johnson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/04/2004 11:52 PM
Please respond to U2 Users Discussion List
To:U2 Users Discussion List [EMAIL PROTECTED]
cc:
Subject:Re: Re: [UD] Determining
At 06:34 PM 02/03/2004, you wrote:
Goo'day,
Are you sure the IF E = 401 bit works in UV?
This would not work within UV unless proc had been rewritten
(doubtful). The error handling within uv is different and this is one of
those areas affected by that difference. You can only test IF E or IF
I realize the context of the original reply was a PROC, but for the sake of completeness, you can also handle it within a paragraph. Check @SYSTEM.RETURN.CODE.
SELECT SOMEFILE WITH F1 EQ XYZ
IF @SYSTEM.RETURN.CODE LT 1 THEN GO NONE.SEL
Tim Snyder
IBM Data Management Solutions
Consulting
I think that the reason so many mv'ers don't like procs is they don't understand them.
/snip
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
snip\
I don't want to hurt anyone's feelings, but, this is almost funny.
Why
How about this one to end this thread?
M
S1
IH%1:U50BB:
T %2,,+
IBP %1
H%1
P
GO B
--
u2-users mailing list
[EMAIL PROTECTED]
http://www.oliver.com/mailman/listinfo/u2-users
: [UD] Determining if list exists
How about this one to end this thread?
M
S1
IH%1:U50BB:
T %2,,+
IBP %1
H%1
P
GO B
--
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
Title: [UD] Determining if list exists
I'm not sure if this is what your looking for, but
here goes.
Insert the statement IF # S GO 99 after the initial SELECT statement. If no
items are selected, then the proc proceeds to label 99 which displays a message
and exists the proc. This prevents
Title: Message
Hi
Chris,
Why
not just use the 'REQUIRE.SELECT' or 'SELECT.ONLY' keywords in your query? This
will then only run if there is a select list present. The Uniquery manual
documents this quite well.
HSSELECT AR WITH
PAYMENT.DATE GE "2-9-04" STON
P
HSAVE-LIST ARLIST P
databasic Statement. Does anyone
know of any other way to evoke ERRMSG text. I've often wondered.
thanks.
- Original Message -
From: Glenn Herbert [EMAIL PROTECTED]
To: U2 Users Discussion List [EMAIL PROTECTED]
Sent: Wednesday, February 04, 2004 9:17 AM
Subject: RE: Memo: Re: [UD] Determining
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
: 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 aproc to test the existence or
otherwise of a select list.So if you modify your proc:HSSELECT
AR WITH PAYMENT.DATE
In a proc you would have:
PQ
HSELECT SOMEFILE SAMPLE 3
P
IF E = 401 G 99
HLIST SOMEFILE
P
99 O No Items Selected
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free web site building tool. Try it!
http://webhosting.yahoo.com/ps/sb/
--
u2-users mailing list
[EMAIL
Goo'day,
Are you sure the IF E = 401 bit works in UV?
AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick flavo*u*r.
The 401 bit is vanilla Pick, which I remember we had to change on
conversion to UV back in 9.3???.
Dunno about UD, though
At 10:06 04/02/04, you wrote:
Nichol [EMAIL PROTECTED]
To: U2 Users Discussion List [EMAIL PROTECTED]
Sent: Tuesday, February 03, 2004 6:34 PM
Subject: RE: Memo: Re: [UD] Determining if list exists
Goo'day,
Are you sure the IF E = 401 bit works in UV?
AFAIK, in UV, E = 0 if there are no items SELECTed, at least in Pick
15 matches
Mail list logo