Re: PK not updated automatically

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>

> >

> >

> >

>

>