Frustrated newbie needs verbatim script for no records found for online database.

On my home computer, if no records match the search terms, I get a generic alert from FileMaker that no records were found.

On the online database, nothing happens. I know you cannot use a custom message; I just need something to tell users the search turned up nothing.

I have asked this before, elsewhere, but did not get answers that worked for me.

This is used through IWP?

Create a layout to display the "no records found" message.

Try this script:

Set Error capture [ On ]

Perform Find []

Set Variable [ $error ; Get( LastError) ]

Set Error capture [ Off ]

If [ $error = 0 ]

#records were found

Else

#no records found

Go to Layout [ No records found ]

End If

Thanks for trying to help Vaughn!

This is a hosted database (by one of your advertisers)

I created the error layout (called NoRecords)

I don't know what " " means in your verbatim script suggestion. I can do the first two steps but when I try to set the variable using your exact language, FileMaker tells me it expects an operator so I get no further . . .

Are script variables available in FMP 8.0? I thought they were introduced in FMP 8.5. If so, my apologies for offering a solution that won't work in your version.

By "" I meant "other script steps" - this is not a complete solution, it only offers a suggestion to solve the displaying of the error problem.

To work around the lack of script variables, create a global field to store the error code produced by the Perform Find step.