Subject | Master/details with IBO, Opinion? |
---|---|
Author | Paulo Henrique Albanez |
Post date | 2002-03-27T14:20:07Z |
It would like to know about you which the best way of working with Master /
Details with IBO
1) Initiate a transaction when he change or To insert the Master record, and
finaliar the transaction when the master record and everybody register them
details are recorded.
How they stay the locks?, for example, if the change of a record changes
other tables linked, like a balances table, this would get locked until the
user confirms or cancel the alterations.
2) Use Cache Updates to isolate the Server.
3) Other method.
It would like their opinion, because each method has her advantages and
disadvantages.
PHA
Nova Odessa / SP - Brazil
Details with IBO
1) Initiate a transaction when he change or To insert the Master record, and
finaliar the transaction when the master record and everybody register them
details are recorded.
How they stay the locks?, for example, if the change of a record changes
other tables linked, like a balances table, this would get locked until the
user confirms or cancel the alterations.
2) Use Cache Updates to isolate the Server.
3) Other method.
It would like their opinion, because each method has her advantages and
disadvantages.
PHA
Nova Odessa / SP - Brazil