[DUG] Why InterBase

[Richard Vowles]

Can't identity cols be rolled back? Generators and sequences can't be.
Pros and cons of this...? 


---
Richard Vowles, Solutions Architect, Borland New Zealand
email: richard.vowles at borland.com
phone: +64-9-9184573
cell: +64-21-467747
other: MSN richard.vowles at borland.com, skype: rvowles
blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
On Behalf Of Neven MacEwan
Sent: Thursday, 1 June 2006 2:17 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Why InterBase

  Edward

 > - BEFORE triggers

In all triggers the state before and after is available hence the
concept of before and after triggers are irrelevant

 > - GENERATOR(IB)/SEQUENCE(Oracle)

Has identity cols, which I realise are not the same but Generators are
simply a stored proc, so you may have to code them but they can be
created

 > Locking mechanism is bad (some improvement on 2005)

Define bad

Neven