Re: Creating Sequence for Auto Number

In our last gripping episode jkipp_at_my-deja.com wrote:
>
> > >
> >
> > If you are not coding an application to perform such duties then,
 yes,
> > a trigger will be necessary to populate your 'auto-number' column.
 And
> > this can be tricky, as you may well receive 'mutating table' errors.
> > To alleviate this you should visit
> > http://govt.us.oracle.com/~tkyte/Mutate/index.html where Tom Kyte
> > discusses this and provides excellent solutions.
> >
> > If you are coding an application to insert/update/delete/select data
> > from your table then a database trigger will not be necessary. Code
> > your application to utilize the sequence to populate the 'auto-
 number'
> > column:
> >
> > ...
> > select auto_seq.nextval
> > into new_seq
> > from dual;
> > ...
> > insert into ....
> > values
> > (new_seq, :blk1.value, :blk1.value2, ...)
> > ...
> >
> > Of course, this example is for Oracle Forms (thus the :blk1
> > descriptors), but any application would be coded to perform similar
> > operations.
> >
> ------------
>
> All of the data will be entered via an Access form. So with this in
> mind, could I just tell Access to auto-increment in the form or do I
> still need to do something on the ORacle end?
>
> THanks
> Jim
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

I believe you can ask Access to generate values for a column but don't quote me on that -- check your documentation. It may be that Access will need the sequence to generate numbers.

--
David Fitzjarrell
Oracle Certified DBA


Sent via Deja.com http://www.deja.com/
Before you buy.