I'm trying to create a script that does something fairly simple. At least I think it is simple.

I want to find all records with the field "Buddy" set to "Yes"

And omit all records that have the field "Status" set to "Inactive"

Any help would be appreciated.

-Kirk

Enter Find Mode ()

Set Field (Buddy, "Yes")

New Record/Request

Toggle Status Area (show) <-- not required in newer versions of FM

Set Field (Status, "Inactive")

Omit

Perform Find ()

-bd

I'm using FM6 on a Mac.

What do I put in the parathesis next to the the Perform Find?

Replace Found Set?

Constrain Found Set?

Extend Found Set?

Nothing. Script steps cannot be typed in, only selected from the menu in ScriptMaker. The empty parenthesis indicates that you should uncheck the "restore" option in both the Enter Find Mode and Perform Find steps. If you don't they will override the find you wish to perform with a saved find. Might want to read the manual a litte and play around with ScriptMaker. Doing so will make all of this more obvious.

-bd

I have both unchecked, yet it still wants something in those paranthesis. Any thoughts? It's working with the Constrain in there.

Thanks for all your help, by the way.

What exactly do you mean by "wants something in those paranthesis"?

If you are referring to the Perform Find [] script step, you must choose "Replace", "Constrain" or "Extend". If you choose "Constrain" (or any other option) your only other possible choice is to check the "Restore find requests" checkbox or not. No other parameter can be entered.

Replace: replaces the current found set with the results of the find

Constrain: performs the find on the current found set, further constraining the results

Extend: performs the find on the records not in the current found set and adds the results of the find to the found set

-bd

Okay, this is what I'm trying to say.

Your original script had it like this:

Perform Find ()

What I was saying was that I couldn't figure out how to have nothing inbetween those paranthesis.

A little too much pre FM 6 shorthand on my part. Since FM 6 you must select one of the found set options, but still need to uncheck "restore".

-bd

Is it possible to write something that would pull out the first part of the word? Like for Buddy maybe just Bud?

Yes it is.

Left("Buddy", 3) will give you the result "Bud".

Left(YourField, 3) will give you the first three characters of whatever is in the YourField field.

Cheers