Firebird SQL Development
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsDatabasesFirebird SQL Development

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old September 7th, 2003, 11:35 AM
goreXP's Avatar
goreXP goreXP is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Location: Bucharest
Posts: 72 goreXP User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 10 m 10 sec
Reputation Power: 6
Send a message via MSN to goreXP Send a message via Yahoo to goreXP
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...

Reply With Quote
  #2  
Old September 7th, 2003, 04:06 PM
mariuz's Avatar
mariuz mariuz is offline
Bug Hunter
Dev Shed Newbie (0 - 499 posts)
 
Join Date: May 2003
Location: Transylvania (Romania)
Posts: 274 mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level)mariuz User rank is Corporal (100 - 500 Reputation Level) 
Time spent in forums: 19 h 57 m 57 sec
Reputation Power: 9
Question Re: what about record versions

Quote:
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

Reply With Quote
  #3  
Old September 8th, 2003, 12:22 AM
goreXP's Avatar
goreXP goreXP is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jun 2003
Location: Bucharest
Posts: 72 goreXP User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 2 h 10 m 10 sec
Reputation Power: 6
Send a message via MSN to goreXP Send a message via Yahoo to goreXP
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.

Reply With Quote
Reply

Viewing: Dev Shed ForumsDatabasesFirebird SQL Development > what about record versions


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway