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: [EMAIL PROTECTED] phone: +64-9-9184573 cell: +64-21-467747 other: MSN [EMAIL PROTECTED], skype: rvowles blog: http://www.usergroup.org.nz/blogs/selectBlog.html?id=39769 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 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 _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
