Hi,
How to deal with deleting a record while someone else is using it undirectly.
Example:
I want to delete suppliers that has no more link to any tables but someone is making a invoice (private datasession, pessimistic buffering) with some of them.
I have two choice for now.
1. When I save my transaction, I will check again if the supplier is there and before deleting the supplier I will check if there is a new transaction when I save.
Pro: Not blocking anyone
Con: More Validation at saving, annoying for the user if it happen's
2. Open in exclusive the suppliers table and blocking everyone to work with the system for that time.
Pro: Best for keeping the integrity
Con: Blocking anyone, annoying for the user
I use the suppliers tables but there may be tables that block more/less the system.
Is there any other ways?
Those the RI check for buffering? I don't think so.
Can I check tables involve in buffering even if it's not official yet?
Thank you in advance for your answers
Steve