Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Getting sequence number using ADO

Getting sequence number using ADO

From: Paul <technotic_at_dial.pipex.com>
Date: Tue, 23 Feb 1999 08:47:38 GMT
Message-ID: <36d26a78.97038@news.dial.pipex.com> 





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.
Received on Tue Feb 23 1999 - 02:47:38 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US