Can't you write a function to do the insert and return the value of the oid?
If you are contemplating adding a new query, seems like it would be just as easy to replace the insert statement with a function call. Another possibility is to grab a number of oids and cache them in your application. I think OpenACS does this for certain applications. tom jackson On Tuesday 04 April 2006 23:25, Bas Scheffers 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. -- 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.
