Plagued by "This record cannot be modified..." err

July 17, 200421 yr

After converting 20 files to FM7V2 from FM5.5V2 without any errors (no problems in the log), I am pulling my hair out trying to close/hide windows that I don't think are open trying to get a simple script to work in V7. Following is the script from 5.5 which is run from my "Visits" file. The purpose is to pass values in a "Global" file for reference in a yet to be opened file. (I have read that V7 can do some passing of values somehow, but I haven't played with that yet.)

Set Field ["Global Link", "1"]

Set Field ["Global::Client ID", "Client ID"]

Set Field ["Global::STR1",""""]

Set Field ["Global::STR2",""""]

etc.

The V7 converted script (that doesn't work) follows:

Set Field [Visits::Global Link; 1]

Set Field [Global::Client ID; Visits::CLient ID] *

Set Field [Global::STR1; ""]

Set Field [Global::STR2; ""]

etc.

The * notes the script line that causes the problem. I have tried adjusting, closing or hiding the Visits window with no effect. Every time I try to set a field in Global file from a field in Visits, I get the following error:

"This record cannot be modified in this window because it is already being modified in a different window".

How on earth (or at least in V7) do I get this stupid thing to work?

July 17, 200421 yr

Set Field no longer automatically commits the record, removing the record lock. The reason being it will be more efficient when you have a series of Set Field script steps to just commit the record once.

You probably have an uncommitted Visits record from a previous script.

You should add the Commit Records/Requests script step after every series of Set Fields (and any other record modification, like cut and paste), to all scripts.

July 18, 200421 yr

Thanks for this reply you have confirmed my thoughts / question in another post (FMD6 to FMD7 migration help). This commit record issue is a bit of a catch on initial conversions. Not a problem once understood but is hard to find desciptions of this obvious trap in the migration docs (or may be I just cant read)

Thanks

Tony

July 18, 200421 yr

It's in the FM7 Migration Foundations and Methodologies white paper somewhere, but it's understandable if your attention drifted off and you missed it That's a heavy read.