Re: Creating Sequence for Auto Number

> >
>
> 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. Received on Mon Nov 20 2000 - 11:49:04 CST