Re: PK not updated automatically

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 Sun Nov 25 2001 - 19:30:07 CET