MS Access and Oracle
From: Doug Eppard <eppardd_at_phibred.com>
Date: 1998/08/17
Message-ID: <6r9cs4$8ei$1_at_supernews.com>#1/1
Date: 1998/08/17
Message-ID: <6r9cs4$8ei$1_at_supernews.com>#1/1
Does anyone know how to get the next seqence number for a column when using a form in MS Access?
We have a table and a sequence defined in our database. We can write an
insert statement using
the sequence (insert into table1 values (seq1.nextval,'test1') which works
fine.
How can we get a form to insert the nextseq value? Is there a system table that must also be refereneced on the form?
Thanks Received on Mon Aug 17 1998 - 00:00:00 CEST