RECORD OF * EXISTS

[Knox, Dave (Dallas, CSC)]

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.