Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 5546 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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.

Posted

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

Posted

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 . . .

Posted

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.

This topic is 5546 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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