That's great - I'm a bit of a Sybase newby and this tip makes life a lot easier.
Given that this is so easy and reasonable I don't understand why so many Sybase developers employ other unreliable methods to emulate triggers. On 4/5/06, Bas Scheffers <[EMAIL PROTECTED]> wrote: > "select @@identity" for the last identity value assigned in the > current session. This is acros all tables with id columns, so if you > are inserting multiple in one transaction and need all of them, be > sure to assign them to another variable after each insert. > > Cheers, > Bas. > -- AOLserver - http://www.aolserver.com/ To Remove yourself from this list, simply send an email to <[EMAIL PROTECTED]> with the body of "SIGNOFF AOLSERVER" in the email message. You can leave the Subject: field of your email blank.