qwippo Posted September 16, 2009 Posted September 16, 2009 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.
Vaughan Posted September 17, 2009 Posted September 17, 2009 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
qwippo Posted September 17, 2009 Author Posted September 17, 2009 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 . . .
Vaughan Posted September 18, 2009 Posted September 18, 2009 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.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now