Re: PK not updated automatically

In your Database you may have more than one sequence... each for a different table... How would Oracle know which sequence corresponds to which table???? AFAK the value has to be filled programmatically one way or the other....

Regards,
Bliss

"Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message news:9trrll$e6ig$1_at_as201.hinet.hr...
> Thank you, that will help me but I have tought that Oracle Forms
> automatically manage ID column filling the corresponding sequence
> nextvalue into PK field. Is it realy needed to manually fill this
> column?
>
> --
>
> Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
>
>
> "Bliss" <bliss_is_ignorance_at_hotmail.com> wrote in message
> news:3c013898_1_at_news.tm.net.my...
> > If you want to do it from the front end, one method would be to create
 a
> > pre-insert trigger on the block in the form...
> >
> > Block - Block1
> > Pre-Insert
> > select sequence.nextval
> > into :block1.column
> > from dual;
> >
> > Hope this helps....
> >
> > Regards
> > Bliss
> >
> > "Stjepan Brbot" <Stjepan.Brbot_at_ZG.HiNet.HR> wrote in message
> > news:9tpmsb$b351$2_at_as201.hinet.hr...
> > > I have one table with i.e. two columns. First column is PK column
 (NOT
> > > NULL) and is filled with sequence number and second column contains
> > > data. When I create form (Developer 6i) I can delete and update rows
 but
> > > not insert rows even I have "Insert allowed" property set to true. I
 get
> > > the error message that it is not possible to insert new row because
> > > there is NOT NULL column not filled with value. When I set value for
 PK
> > > column manually it works - I can insert row. How to create form
 where PK
> > > column can be hidden (or not on canvas) and automatically updated
 with
> > > sequence value?
> > >
> > > --
> > >
> > > Stjepan Brbot <Stjepan.Brbot_at_ZG.HiNet.HR>
> > >
> > >
> > >
> >
> >
>
Received on Mon Nov 26 2001 - 10:44:54 CET