Re: Memo: Re: [UD] Determining if list exists

2004-02-05 Thread Glenn Herbert
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

RE: Memo: Re: [UD] Determining if list exists

2004-02-04 Thread Glenn Herbert
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

RE: Memo: Re: [UD] Determining if list exists

2004-02-04 Thread Timothy Snyder
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

Re: Memo: Re: [UD] Determining if list exists

2004-02-04 Thread Mark Johnson
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

RE: Memo: Re: [UD] Determining if list exists

2004-02-03 Thread Chris Bugosh
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

RE: Memo: Re: [UD] Determining if list exists

2004-02-03 Thread Jacques G.
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

RE: Memo: Re: [UD] Determining if list exists

2004-02-03 Thread Bruce Nichol
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:

Re: Memo: Re: [UD] Determining if list exists

2004-02-03 Thread Mark Johnson
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