Re-evaluate field rules for a single open record.

[Ted Giles]

I need to re-evaluate the field rules for the current record only. Can someone help with the syntax?
I can do it for all records from a button, but I would prefer just the current record.
Any ideas?

[Stan Mathews]

There are no functions to re-evaluate the rules for a single record. If I remember correctly you can use

tbl = table.open("sometablename")
'query for the record in question
tbl.change_begin()
'don't change anything
tbl.change_end()
tbl.close()

to cause the field rules to be re-evaluated for the queried record. That may have just been the way to recalc the calculated fields. Memory fails.

[Ted Giles]

You are probably correct Stan.
When an image is pinned to an ImageReferenceField, there is no factual Record Save.
I tried simply Saving and that didn't work.
TableOpen and resave may well solve the issue. Other than that recalc everything is the only option. Still, small ish table.

[Stan Mathews]

Since you are probably doing it on a form (?) try making the onchange event for the form field

parentform.commit()

[Ted Giles]

Tried the Stan, but then we hit another problem with the interaction between the sql and dbf tables in the set.
Ongoing work I'm afraid.

[Mike Wilson]

Is there one or a couple of field rule in particular that is of interest? If you are having to push a button anyway, could you have the button run a script that perform the same field rule evaluations on the current record?

[Ted Giles]

There are 6 fields Mike, each of which has a field rule attached.
A script to do that would be good.
See post#3. There is a Save when an image is selected and I need to get the file path and save it. A Calc expression does it fine and my work around to force a recalc is to clear a logical field which must be ticked to confirm acceptance. This has the effect of a record change, so the rules are recalculated.