1 of 1 people found this helpful
What platform are you on? For the Mac this is a simple task with the correct tools. First you need either BBedit or TextMate. Then you need either the TextMate FileMaker Bundle or a set of Applescripts (let me know back channel if you need them).You then copy the scripts that you want to change into your editor, do a find/replace there, then copy back into FileMaker. I use this route often to great satisfaction.
If you're on a PC I think there are also some ways to do this, but don't remember (or even care to remember) what they are.
since I#m working on mac, this might be a road to go. Still it involves copying skripts back and forth and doing search and replace AND I'm still looking for a solution that also would involve formulas and functions as well.
With either of these you can do the same routine with custom functions, text in calcs, tables, fields, and even layout objects (change up your CSS!). There's really nothing "native" that's available without using an external editor.
thanks for clarifying this. I'll look into it.
To determine current schema via ExecuteSQL, you should check out:
The only way I know to manipulate FileMaker schema via the calculation engine (e.g., in script steps) is with the MMQuery plugin from CNS.
Between ExecuteSQL schema gathering and MMQuery, you can do what you are asking.
You might want to check out Clip Manager from myFMbutler. It allows you to manipulate the FM clipboard, including search and replace.
Details available on the myFMbutler site: http://myfmbutler.com/index.lasso?p=422
Using the example you provided, you would copy the scripts to the clipboard; use Clip Manager to replace "clients::clutterfield123" with "options::clutterfield123"; then paste the updated scripts back into FM.
220 Gaines Oak Way
Suwanee, GA 30024
Voice: (678) 313-5604
FileMaker Certified Developer