Hi there,
I have a few scripts in which I'd like to search for the presence of certain records in certain tables. If no records are found, I'd like one thing to happen, if records are found, I'd like something else to happen, all behind the scenes and invisible to the end user. There are a few different scenarios on our DB where this would be helpful.
The issue I run into is that when no records are found, the script is stopped and a message is displayed saying no records were found that match the search criteria, with the button choices of what to do next. Is there any way to suppress this dialogue, or any other way to deal with empty search results? I've tried using logic like when Get(FoundCount) = 0, but to get the found count it still needs to perform the search first, which displays the dialogue.
An example of this: on a certain layout users can click checkboxes for multiple records that, when checked and a "process" button is clicked, will initiate a certain action on those records. However, before I present the users with the list of records, I'd like to do a quick search to make sure no records are checked already (and if they are to un-check them), something I could see happening if a previous user closed the application or somehow left the layout during the above workflow.
Any thoughts / ideas much appreciated!