NavigationFileMaker DealsVideo Browser
|
A Faster OR Search ScriptPosted by: Editor / Monday, June 4, 2007 – 12:42pm
12
minutes
Is it an OR search or an AND search? Do I use more than one field on one request or multiple find requests with multiple fields? These may be common questions if you've not spent a lot of time searching manually through a FileMaker database. If you're not one to teach your users how to search the FileMaker way, then maybe you should script the whole search process. In fact, that's exactly what many developers do. From the complex to the simple, there are many ways to script a search in FileMaker. In this video, you'll find out that using a common browse mode feature will help you accomplish some complex searches and do so in such a simple manner. It's the easiest way to make a complex search an easy one, and this includes both users and developer. Details: Released - 6/4/2007 / Size - 13.14 MB / Length - 12 min
Filed under: videos | Subscribers Only
. Using the global directly is just fine - ADMIN POSTED THIS.
. Editor said this on Wednesday, June 6, 2007 - 8:44am.
. I just use script variables out of habit and practice. . . Trouble when no records are found.
. kmullins said this on Wednesday, June 13, 2007 - 10:37pm.
. I have a problem that the sample doesn't seem to have. When I do a search and no values are returned I get a result that shows no records are found, if I try to perform another search I get the error message "No records are present. To create.." The video implied that if error capture was on then I wouldn't have the issue with no found records, but that isn't working for me. Thoughts? (XP FMA 8.5) Thanks . . The error relates to a user action I think - ADMIN POSTED THIS.
. Editor said this on Friday, June 15, 2007 - 8:27am.
. When you get "No records are present. To create..." I'm led to believe that some action is attempting to head into a field which is not global in nature and when there is a zero found set. This error is typically not one which is the result of a script action. Most of the time you see this when you accidentally click in the window with a zero found set. It may be that a script step is causing this and error capture is not trapping it. Without having tested or have seen the implementation you've got, I would think about adding additional steps to the script that leave the database in a state where the zero found set won't cause the dialog. . . Discovered my mistake.
. kmullins said this on Wednesday, June 20, 2007 - 1:41am.
. The problem I was having was from the search field not being a global field. Once I changed the field to a global everything work as described. Thanks. These videos are an amazing resource. Thanks . . Technique useable for a lot of records??.
. bruno said this on Friday, October 12, 2007 - 2:26pm.
. I found it a awesome technique,easy to understand and to implement but I wonder if it's useable for a table with lots of records and doing a search on a dozen of records ? . . Discovered my mistake.
. bruno said this on Monday, October 15, 2007 - 2:03am.
. One of the fields was not on the layout and another was not indexed. Keep up the good work!! Bruno . . Can this be used in a portal search?.
. myronstam said this on Wednesday, February 27, 2008 - 5:36pm.
. Great technique! I was wondering if there's a way to use this to bring up a found set of portal records. . |
Be Notified!Let us tell you when a new video is posted. We'll send you an email with a direct link right to your email inbox.
Make sure and whitelist (or add to your address book editor@filemakermagazine.comiPod Video
FileMaker Reference Tool10 Most Recent Videos
|
Use of variable
I'm finding the videos very useful lately - you seem to be going for less advanced topics, which is great (for me). Just wanted to check one thing in this one - in the "Perform Find/Replace" script step, I've used the global itself (rather than putting that value into a local variable first), and it seems to work fine. But am I missing something?
Regards,
Dave.