I need to know when a new version of an record is created and when the old record version will be deleted. I know that concurent transactions create a new record version but I'm so confused about this...
Originally posted by goreXP
I need to know when a new version of an record is created and when the old record version will be deleted. I know that concurent transactions create a new record version but I'm so confused about this...
If i understand you want a trigger ?
In a trigger you can work with the OLD version and with the NEW version of the record when you
modify it .
Show me the database structure and what you want to achieve . If it is easier you can contact me on PM in romanian :)
... it's about versioning type of concurent acces of a database.
Other database server use the locking model to resolve conflict between concurent read/write acces, IB/FB use versioning model.