Re: Using sequence in WebDB?

Create a trigger 'before insert' on the table. The tigger statement could be something like :

select mysequence.nextval into :new.id from dual;

This way the trigger is 'triggered' every time you insert a new row.

The sequence can be generated from within WebDB, the trigger also.

Cheers,

Wim.Teuwens_at_planetinternet.be

Johannes Nurmi <DeeRam_at_gnwmail.com> wrote in message news:WJFl3.146$AR2.621_at_read2.inet.fi...
> I am using Oracle WebDB and come up with following problem (and I did not
> find any help from help files).
> I need automatically increasing number for my ID field.
> I heard that it should be done with sequence.
> I can create one, but how to link it to work with that table?
>
> TIA, Johannes Nurmi
>
>
Received on Thu Jul 22 1999 - 17:33:00 CEST