Help finding exact match in a find in a script

[Carri]

Hi,if anyone can help that would be much appreciated.

I have a script that goes to a report of the current record. I do that by copying and pasting the current records group name.

PROBLEM: when the script performs the find on the group name I need it to find the exact match, how do I do that?

[David Jondreau]

Don't use copy and paste. Grab the group name using Set Variable[$GN; GroupName]. Put it into the find by using Set Field [GroupName; "==" & $GN].

The "==" indicates an exact match.

[Carri]

Thank you so much for responding, it's a great thing to know and it worked perfectly.

[LaRetta]

Another way, not necessarily better but it feels easier to me (and can allow more flexibility if more modifications need to be done to it) ...

Enter Find Mode [ pause ] ... to accept user input

Modify Last Find

Set Field [ thatField ; "==" & thatField ]

Perform Find [ ]

One should of course, include the proper error trapping etc.

Edited December 13, 2007 by Guest

[LaRetta]

Ooops, sorry, I didn't see you copied it first. Firstly, I'd try to leave your clipboard intact and use a variable or script parameter (DJ gave you one). But if you needed to modify the theory of my script, it would be:

Copy [ Select ; table::thatField ]

Enter Find Mode [ ]

Paste [ Select ; table::newField ]

Set Field [ thatField ; "==" & newField ]

... and, just because I provide a method for using copy/paste does NOT mean I suggest it. Like DJ and a thousand other Developers, I suggest strongly against it. But as long as the User performs this action and is aware it interfers with their clipboard, it can be okay I suppose. I'm only giving the option because I didn't properly read the first request about going elsewhere before performing the find.

My prior script is great when you want to modify a User-initiated find.

[Deepak Kumar]

Thanks Friend.