Select if NOT Record filename Exists

[Jeff Hoffman]

Bummer Dude!

Good Luck

Jeff

At 04:59 PM 15-12-01 +1300, Richard wrote:
>Sorry Geoff, George is on AS/400 and we '400 people don't have the luxury of
>settable system values.
>
>cheers
>Richard
>
>-----Original Message-----
>From: Jeff Hoffman [mailto:wonicon@bigpond.net.au]
>Sent: Saturday, 15 December 2001 12:09 p.m.
>To: powerh-l@lists.swau.edu
>Subject: RE: Select if NOT Record filename Exists
>
>
>George
>
>To Johns suggestion try adding setsystemval using values from I55first,
>then getsystemval, they would then be available for printing.
>
>Jeff
>
>At 02:25 PM 14-12-01 -0500, John Pickering wrote:
>>George
>>
>>How about:
>>>Access I4311  &
>>>  link PDITM  to QAITM of I5531410 optional &
>>>  link to record(0) of I5531410 alias I55first
>>
>>Note that some platforms may want "record(1)" instead of "(0)".
>>
>>Every record complex will have a buffer for I55first assuming the file
>isn't
>>empty. Use the contents of this buffer for headings etc.
>>
>>Regards,
>>JWP
>>
>>
>>> -----Original Message-----
>>> From:	george.j.wen@us.abb.com [SMTP:george.j.wen@us.abb.com]
>>> Sent:	Friday, December 14, 2001 1:47 PM
>>> To:	powerh-l@lists.swau.edu
>>> Subject:	Select if NOT Record filename Exists
>>> 
>>> 
>>> 
>>> Hello List, here's one for you.
>>> 
>>> I'm using the construct for the following access line:
>>> 
>>>      Access I4311 link PDITM  to QAITM of I5531410 optional
>>>          Select if Not Record I5531410 exists
>>> 
>>> But what if I want a value from the from I5531410 for printing in the
>>> headings
>>> even
>>> when zero records meet the selection criteria.  This value is not
>>> presented in a
>>> parm anywhere but rather this I55.. file is a work file that is created
>by
>>> the
>>> user so
>>> it would be useful to see what the first record in the file (one that
>does
>>> not
>>> meet the
>>> selection criteria) looks like to validate that the correct data (most
>>> recent)
>>> is there.
>>> I could do a cover page report ahead of the main report or something like
>>> that
>>> but
>>> does anyone knows of a "slick and dirty" way or work around?
>>> 
>>> Thank you in advance.
>>> George
>>> 
>>

+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ Jeff Hoffman                          + e-mail: wonicon@bigpond.net.au    +
+ Director                              +                                   +
+ WoniCon Pty Ltd   (ABN 93 083 502 630)+                          ,-_|\    +
+ 21 Prices Circuit                     + voice: +61 2 9542 1527  /     \   +
+ Woronora    NSW     2232              +                         \_,-._*   +
+ AUSTRALIA                             + mobile: 040 790 3929         v    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+