No records found message

[stewm@canada.com]

Terry,

If you are just doing a GET in a designer procedure you can try:
GET FILENAME OPTIONAL
IF NOT ACCESSOK
   THEN INFO MESSAGE = "No more records to change." NOW

I'm guessing here but when you do PUSH NEXT you could be advancing the whole record structure that spins off the primary to the next record.  If PowerHouse is creating your FIND procedure for you based on your ACCESS statements and if you put BUILD LIST at the end of your source you'll see that the FIND procedure contains the GET statements are that kicked off by a PUSH NEXT.  Primary records can not be optional so you can't do a check for ACCESSOK.  If this is the case "No records were found matching index/selection values" is probably from your primary record structure.  If this is the case maybe you could rig up a INFO statement in the POSTFIND to say "No more records to change."  In your DESIGNER procedure you set a TEMPORARY to a particular value for one message and let it equal blank for the normal message to toggle your messages.I'm not sure if an INFO statement in your POSTFIND would override the normal message (I havn't tried it lately) but you could try.


Mark Stewart
Consultants Club Corp.
Windsor, Ontario

-----Original Message-----
From: Terry Pickering <pickering@myself.com>
To: powerh-l@lists.swau.edu <powerh-l@lists.swau.edu>
Date: August 26, 1999 5:58 PM
Subject: No records found message


>Is there away to suppress or trap the "No records were found matching
>index/selection values" from displaying?
>
>I have a primary record with detail records in a cluster that the user
>finds, then executes a designer procedure. At the end of the designer
>procedure, I PUSH NEXT to get the next record.
>
>I've tried putting an optional on the GET statement and testing for
>accessok, but still can't trap it. I'd like to change it to say something
>like "No more records to change" since normally they are retrieving the
>records sequentially and they hit this on the last one.
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Terry Pickering        Consultant Extraordinare
>Monday and Friday        Tuesday - Thursday
>Portland                 Eugene
>(503) 245-7178           (541) 687-3416
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
>Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
>powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
>This list is closed, thus to post to the list, you must be a subscriber.
>

----------------------------------------------------------
Get your FREE personalized e-mail at http://www.canada.com
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.