Select if NOT Record filename Exists

[Jeff Hoffman]

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
>> 
>
>= = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Mailing list: powerh-l@lists.swau.edu
>Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
>Unsubscribe: "unsubscribe" in message body to powerh-l-request@lists.swau.edu
>http://lists.swau.edu/mailman/listinfo/powerh-l
>This list is closed, thus to post to the list you must be a subscriber.
>
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+
+ 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    +
+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-
+