Jump to content
Sign in to follow this  
GibCo

Changing the No records match after a Find

Recommended Posts

If a Find is performed and no records match, you get that Cancel, Continue or Modify Find message. If you chose Cancel or Continue, ALL RECORDS are shown and the find cancelled.

Is there a way to get around the choices of Cancel or Continue, or to just to show a message saying "No Records Match, sorry!" and then go back to the records in the order they were in BEFORE the find was initiated? I know it has to do with turning the Set Error Capture on, and when the Status(CurrentCountFound)=0, setting up a message to show but I can't seem to get it to work properly. Is there some secret I need to know? Like setting the storage to Do not storeto get a field to hold the nmber in Status(CurrentCount Found). Took me forever to figure that one out! I feel like I can almost touch it! Help Please!

Share this post


Link to post
Share on other sites

You're on the right track. Turn the error capture off. Before you perform the find, mark the found records and unmark the records not in the found set. After the find is performed, check the found count by using Status( CurrentFoundCount ) and if it is zero, use a separate script to find the marked records. You could also store the sort order (with another field that you fill in with an incremental number, which you then sort by to restore the sort order), store the current record (by recording the record ID, setting this to a global field and using a relationship to go to it after the find) and the current layout (by using Status( CurrentLayoutNumber ) and use these to duplicate the entire state of the database before the find was implemented.

Chuck

Share this post


Link to post
Share on other sites

Chuck,

Thank you very much. I knew I was close but i just could think of what I was doing wrong! I understand your solution! It will make what I need to do easy! Thanks again.

Bev

(GibCo)

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.