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

Actually, a better approach would be to insert the SEQ.NEXTVAL in a pre-insert trigger!
Frans

Breno de Avellar Gomes heeft geschreven in bericht <37436607.4D6A589B_at_ieee.org>...
>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.
>
>Feel free to contact me.
>
>Breno Gomes
>
>
>OneZerO wrote:
>
>> Hi all,
>>
>> Firstly, let me thank you for taking time to read my posting. I'm a
beginner
>> in develop application using Oracle Developer 2000. For my application, i
>> need to create a sequence for a few items (e.g Order_no) and I have
create
>> these in my database.
>>
>> In the Form builder, under the Properties of Order_No, i have set the
>> "Initial Value" to ":sequence.order_no.nextval" where order_no is my
>> sequence that i have declared in the database. Yes, this does generates
the
>> sequence, however when the Form is executed, even if i didn't create a
new
>> record, and mainly trying to do a query, the sequence will still skip to
the
>> next value when i re-run the form again the next time.
>>
>> How do i overcome this problem? Your help is greatly appreaciated, Thanks
in
>> advance
>>
>> Cheers
>> Evelyn
>
Received on Thu May 20 1999 - 09:37:09 CEST