Xref: alice comp.databases.oracle.misc:26596
Path: alice!news-feed.fnsi.net!oleane!ayres.ftech.net!news.ftech.net!dispose.news.demon.net!demon!rill.news.pipex.net!pipex!bore.news.pipex.net!pipex!not-for-mail
From: technotic@dial.pipex.com (Paul)
Newsgroups: comp.databases.oracle.misc
Subject: Getting sequence number using ADO
Date: Tue, 23 Feb 1999 08:47:38 GMT
Organization: UUNET WorldCom server (post doesn't reflect views of UUNET WorldCom)
Message-ID: <36d26a78.97038@news.dial.pipex.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Newsreader: Forte Agent 1.5/32.451
X-No-Archive: yes
Lines: 6

I am writing a VB program using ADO to access an Oracle database.
Primary keys are generated using sequences. When a row is inserted I
want to find the sequence number just generated. Is the best approach
to this to lock the table before doing the insert, get the sequence
number and then release the lock? If so how do I do this with ADO?
Thanks in advance.