WC Howard Posted May 14, 2007 Share Posted May 14, 2007 This has got to be one of those "it's so simple but the answer eludes me" questions... I'm trying to write a script step where a part number is copy/pasted for a Find in another file, but I want to add the "==" parameter to it for exact searching... Any suggestions?? Link to comment Share on other sites More sharing options...
Inky Phil Posted May 14, 2007 Share Posted May 14, 2007 Setfield[thefieldinthefindfile;"=="&thefieldnamethatcontainsthepartNo.] I seem to recall that the divider in 6 might not have been a semicolon. You will have to look that up. Sorry also for the elongated names but with nothing else to go on... HTH Phil Link to comment Share on other sites More sharing options...
Lee Smith Posted May 14, 2007 Share Posted May 14, 2007 Hi Phil, It's a comma, but it really doesn't matter, as ScripMaker enters it automatically. Hi WC, Stay away from Copy and Paste, use a global field instead. In order to perform a find in a second file, you will need two scripts. I'll use File A and File B to explain it. Create the following. In File A, a global (I'll use [color:red]g_find). In File B, create a relationship to File A. (I'll call it [color:green]B|A_Relationship) In File B, create your script to perform the find [color:blue]TheFindScript Enter find mode Set Field [ YourFindField, "==" & [color:green]B|A_Relationship::[color:red]g_find ] Perform Find. In File A, create a script with at least these two steps. SetField (g_find, YourFindData) and Perform External Script [color:blue]TheFindScript. HTH Lee Link to comment Share on other sites More sharing options...
David McQueen Posted May 14, 2007 Share Posted May 14, 2007 Also, if fr some reason set field odes not work, use the insert calculated result step instead. Dave McQueen Link to comment Share on other sites More sharing options...
WC Howard Posted May 15, 2007 Author Share Posted May 15, 2007 : Not working... The calculation box keeps telling me it needs an operator where the comma (and I tried the semi-colon too) is... Also, I don't understand how the global field will identify the record in file A that is currently being browsed... Could you explain? Link to comment Share on other sites More sharing options...
Lee Smith Posted May 15, 2007 Share Posted May 15, 2007 I noticed that you have added that you are NOW using 8.5. Things have changed since the v6 days, so which way do you want the example to be written. v6 or v8.5? Link to comment Share on other sites More sharing options...
WC Howard Posted May 15, 2007 Author Share Posted May 15, 2007 (assumes the position of great shame) I am sorry... it is 8.5... I have been a member for a long time, and we just recently upgraded (after much prostrating and begging); I haven't changed my user preferences and they default to 6... Sorry... Link to comment Share on other sites More sharing options...
WC Howard Posted May 15, 2007 Author Share Posted May 15, 2007 (Side note) Now see... There I tried to change all that in myh last post and it didn't take... Link to comment Share on other sites More sharing options...
Lee Smith Posted May 15, 2007 Share Posted May 15, 2007 Location: Main Index » Forum Index » Your Control Panel » Public Profile >> [color:blue]FileMaker Questions (last item on the list.) Link to comment Share on other sites More sharing options...
AudioFreak Posted May 15, 2007 Share Posted May 15, 2007 It is a little bit hidden. I recently updated mine and it took me awhile to find the place to change it......lol Link to comment Share on other sites More sharing options...
Lee Smith Posted May 15, 2007 Share Posted May 15, 2007 v8 has made things a lot simpler. Here is an example of using both methods. Lee WC_Howard_.fp7.zip Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6191 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