September 7th, 2003, 11:35 AM
what about record versions
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...
September 7th, 2003, 04:06 PM
Re: what about record versions
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
September 8th, 2003, 12:22 AM
it's not about trigger ...
... 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.