Select if NOT Record filename Exists

[Pickering, John (NORBORD)]

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
>