Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #2158

Re: No Matching Records in a Script Find

Show key headers only | View raw

In article <2b8f9$552b98cc$52d9780b$30967@news.ziggo.nl>, Ursus
<ursus.kirk@ziggo.nl> wrote:
> Charles H. Sampson schreef op 13-4-2015 om 09:33:
> > Is there a way, in a script, to suppress the Find message "No records
> > match this set of find requests"? I'd much rather the script discover
> > this and handle the situation than have the user respond to a process
> > that he might not even know is going on.
> >
> > I know that I can add a dummy record to the database that satisfies the
> > find and delete it later. I don't like that because it's not direct. I'd
> > much rather for the script to ask, "Are there any records in this Found
> > set?" and react appropriately.
> >
> > As always, FMP 8.
> >
> > Charlie
> >
> 
> Switch on error capture (is a script step you can add, might be labeled 
> differently in English, but something to that extend. you'll find it 
> within the first script-header)
> 
> Keep well, Erik

Yep, the Set Error Capture [On] command is half the answer. That causes
FileMaker catch any errors itself rather than displaying a message to
the user. Set Error Capture [Off] of course returns FileMaker to the
normal option of displaying error messages to the user. Error capturing
automatically turns off when the script ends.

The other half of the solution is the Get(LastError) function which
allows you to see what error, if any, occurred with the previous script
commmand. The function returns a rather meaningless error code number
(with 0 meaning no error), but there's a list of what the error codes
mean at http://www.filemaker.com/help/html/error_codes.html

Because the Get(LastError) catches the error code for the IMMEDIATELY
PREVIOUS SCRIPT COMMAND, it's usually best to then use the function in
the very next command to grab any error code into a separate field /
Global field / variable which you can then check with following If
tests.

For example, a Find script might be something like:

    Enter Find Mode []
    Set Field [MyField; "Find Me"]
    Set Error Capture [On]
    Perform Find []
    Set [gErrorCode; Get(LastError)]
    If [gErrorCode] = 0]
       {perform whatever script commands are to be done 
        with the found records}
    End If
    If [gErrorCode = 401]
       Show Custom Dialog ["There are no records with the
                            text 'Find Me'"; "OK"]
    End If


If you instead had a Script that said:

    Enter Find Mode []
    Set Field [MyField; "Find Me"]
    Set Error Capture [On]
    Perform Find []
    Sort [MyField]
    Set [gErrorCode; Get(LastError)]

then the Get(LastError) function would retrieve the error code for the
Sort command, and the command error from the Find command would be
lost.

Helpful Harry  :o)

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

No Matching Records in a Script Find csampson@inetworld.net (Charles H. Sampson) - 2015-04-13 00:33 -0700
  Re: No Matching Records in a Script Find Ursus <ursus.kirk@ziggo.nl> - 2015-04-13 12:21 +0200
    Re: No Matching Records in a Script Find Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-14 13:51 +1200
      Re: No Matching Records in a Script Find clkaufmann@gmx.ch (Christoph Kaufmann) - 2015-04-14 09:13 +0200
        Re: No Matching Records in a Script Find Helpful Harry <HelpfulHarry@BusyWorking.com> - 2015-04-14 19:28 +1200
    Re: No Matching Records in a Script Find csampson@inetworld.net (Charles H. Sampson) - 2015-04-13 22:59 -0700

csiph-web