RECORD OF * EXISTS

[Deskin, Bob]

Good one.

Just keep in mind that ACCESSOK specifically tests retrieval. NEWRECORD
tests whether the buffer has been initialized as well as whether anything's
been read into it. Immediately after a PUT RESET, NEWRECORD will be true but
that doesn't mean that a retrieval failed.

However, based on Mark's other post, he could do a series of GET OPTIONAL
and then within the same procedure test IF NOT NEWRECORD. Probably easier
than setting temp flags to remember the status.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178
3755 Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA

-----Original Message-----
From: Knox, Dave (Dallas, CSC) [mailto:KnoxDa01@unisourcelink.com]
Sent: Friday, January 24, 2003 11:36 AM
To: powerh-l@lists.swau.edu
Subject: RE: RECORD OF * EXISTS


And of course don't forget...

If NOT NEWRECORD of file !!

:-)


-----Original Message-----
From: Deskin, Bob [mailto:Bob.Deskin@cognos.com] 
Sent: Friday, January 24, 2003 10:19 AM
To: powerh-l@lists.swau.edu
Subject: RE: RECORD OF * EXISTS


Two syntax issues in one day! This one's really cute. Although the words are
the same, the meaning is totally different. In QDESIGN, RECORD is short for
RECORDLOCATION which takes "OF file" as an argument. Note that in QUIZ/QTP,
there is no OF so the syntax is not quite the same. Now the EXISTS is the
equivalent of saying NOT NULL, as in a relational NULL. So the full syntax
would be 

IF RECORDLOCATION OF FILE_ABC EXISTS

or

IF RECORDLOCATION  OF FILE_ABC NOT NULL

In QDESIGN, the equivalent of IF RECORD file EXISTS is IF ACCESSOK.

Bob Deskin              
PowerHouse Web Product Manager, Application Development Tools, Cognos Inc.
bob.deskin@cognos.com (613) 738-1338 ext 7268 FAX: (613) 727-1178 3755
Riverside Drive P.O. Box 9707 Stn. T, Ottawa ON K1G 4K9 CANADA


-----Original Message-----
From: stewm@canada.com [mailto:stewm@canada.com]
Sent: Friday, January 24, 2003 10:53 AM
To: powerh-l@lists.swau.edu
Subject: RECORD OF * EXISTS


Can some tell him what it takes for this condition to
false?  In the following piece of source the message
'Found the file.' always comes up no matter what you
enter for T_ITEM_ABC.  

What is RECORD OF <> EXISTS for in QUICK?  It does not
appear to have the same functionality as similiar code
in QTP.

FIELD T_ITEM_ABC

  PROCEDURE DESIGNER RECOFWHAT
  BEGIN
    ACCEPT T_ITEM_ABC
    GET FILE_ABC VIA ITEM_ABC USING T_ITEM_ABC OPT
    IF RECORD OF FILE_ABC EXISTS
      THEN INFO "Found the file." NOW RESP
  END

Thanks

Mark Stewart

Consultants Club Corp.
__________________________________________________________
Get your FREE personalized e-mail at http://www.canada.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you. = = = = = = = = = = =
= = = = = = = = = = = = = = = = = 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.
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
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.

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.