#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12

    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...
  2. #2
  3. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    24

    Question Re: what about record versions


    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
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2003
    Location
    Bucharest
    Posts
    72
    Rep Power
    12

    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.

IMN logo majestic logo threadwatch logo seochat tools logo