Hi everybody,

I have a multi-occurances form with one variable (not a field of the main table) "Location" that I use to update a other table (tisfc009). This is a child session and when i come back to the main --- I have the error code 206 ..... but the update of tisfc009 is correct with the function do.occ(actual.occ, upd.function) in the when.field.changes of the variable "loca"

Does someone have an idea how to lock the record of the main table.

Thanks

Gaith1

Hi

As far as i know there is no need to lock the main table records , baan standards handles by it own. May be i think you had given a commit.transaction() to update tisfc009 some where in script which is creating a problem.

Thanks & Regards

The commit.transaction() applied to tisfc009....removes the lock of the record that you are updating...hence the error.

U need to commit after the complete update/insert.

Programming an update in section when.field.changes is not a good idea.
It is better to do it in the section update.db: after.choice:.
In that section you don't need to program retry.points nor commits.
It's handled by the 4gl engine.

Thanks a lot