Re: Creating a Sequence in Developer 2000 version 2 - Form Builder

You can use :sequence.your_seq_name.nextval as field's Initial Value also, but I prefer PRE-INSERT trigger.

Hope this helps.

Breno de Avellar Gomes wrote:
>
> Hello Evelyn,
>
> I had same problem. One possible solution is to define a WHEN-CREATE-RECORD
> trigger at block level and use something like this:
> DECLARE
> SEQ_ID NUMBER;
> BEGIN
> SELECT SEQEIME.NEXTVAL INTO SEQ_ID FROM DUAL;
> :BLOCK_NAME.ID := SEQ_ID;
> .............. other code .......................
> END;
>
> It is not the best approach, but it works fine.

<snip>

-- 
Valeri Sorokine
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoft.ru
http://www.dd.ru