Recalculate all fields in record only

1

I have an import procedure which adds a new record to quite a large database. There’s a handful of calculated fields in the database.

I could call “recalculatefield” on each of those fields in turn every time I add a new record; but that seems inefficient in a large database.

Is there a more efficient way of simply recalculating all fields on the current record / row?

Thanks

Tom

2

Try this to exeute all the formulas in the fields of the current record:

for fn,1,info("fieldcount")
    field fn+0
    recalculatefield
    if error nop endif
endloop
1 Like