Changing field names - Break Script?

[GregInChrist]

I am working on a database that has fields named with bullet points in the names. I see that FMP will update "each layout and any field references used in calculation or summary fields" per this link Filemaker Help.

 

I want to make sure I am not going to break any scripts if I update the field names. Can anyone assure me that FMP will update the field names in any scripts that may access or write to said fields?

 

I could ask rather is there anything that is not updated when a field name is changed in the define database dialog?

 

Thanks in advance!

[Lee Smith]

Do you think that FileMaker Help is misleading you on this?

[GregInChrist]

Not sure if your trying to be sarcastic. No, I don't think they are trying to mislead me. How ever their documentation does not state that it updates script references. It only emphatically states "When you change a field name, FileMaker Pro changes the name on each layout and any field references used in calculation or summary fields."

 

 

I was not aware if the term "calculation" was referring to all scripts or calculations in calculated field.

Anyway, To anyone who might be as stupid as me. I found they answer elsewhere...

 

 

It is safe to update field names, FMP is smart enough to update all necessary references within your database. 

 

Thanks for the help.

[Wim Decorte]

Except for script steps that use hard-coded field names like:

- Set Field by Name

- anything that uses the ExecuteSQL function

 

There are a few more probably that I'm forgetting

[GregInChrist]

Except for script steps that use hard-coded field names like:

- Set Field by Name

- anything that uses the ExecuteSQL function

 

There are a few more probably that I'm forgetting

Thanks, Hope I did not have any of those in my database. 

[Rick Whitelaw]

If a field named in a ScriptParameter it will not be updated as far as I can tell.

[Tom R.]

There's a blog post at Six Fried Rice that discusses the cases where changing field names will break a script; it also provides a workaround solution using the indirection technique. It might be worth taking a look at.

 

http://sixfriedrice.com/wp/set-field-by-name-exposed/