Re: generate unique sequence number

Hi,

row-level trigger code should be:

Begin

        Select your_sequence.nextval into :new.pk from dual; end;

jtrxt_at_my-dejanews.com schrieb:
>
> I'm trying to automatically generate a unique sequence number using forms 4.5.
>
> Under the text items property I've set the default value to
> :sequence.column_name.nextval.
>
> Next, I believe I create a trigger with the built-in generate_sequence_number.
>
> I'm doing something wrong. Can anyone provide detailed step-by-step
> directions?
>
> TIA
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

--

Regards

Matthias Gresz :-)

--
GreMa_at_t-online.de

          /|
         / |        
        /| |\
       /||  |\
      / O    |\         
     |        |\ Galopping Horse beats Running Man.
    /          |\
   /      /     |\
  /    __/|      |\
  \°   /  |       |\
   \/_/   |        |\