Re: Sequence in Dev6.0

Hi

Do it like this ...

Create your Sequence in SQL-Plus:

CREATE
  SEQUENCE <name>
    START WITH 1
    MINVALUE 1
    MAXVALUE 99999999
    CYCLE; Now move to Forms.

If you whant to Insert the SequenceNumber automatically when Creating a Record:

Create a TRIGGER in your BLOCK --> KEY-CREREC Trigger text like this:

Declare
  new_primary_key number;
Begin
  SELECT <sequence_name>.nextval INTO new_primary_key FROM dual;   SELECT <sequence_name>.currval INTO new_primary_key FROM dual;

  create_record;

  :<BLOCK_NAME>.<PRIMARY_KEY_COLUMN> := new_primary_key;

Exception WHEN others THEN
  message(sqlerrm);
End;

greetings Christoph

Ludwig Mallia <lumar_at_fastnet.net.mt> schrieb in im Newsbeitrag: 38e479a9$1_at_news.waldonet.ent.mt...
>
> Hi,
>
> I am trying to implement a sequence within dev 6.0. Any idea how it is
> done? I want to use this sequence as a primary Key and it should be auto
> generated....
>
> cheers,
> Ludwig
>
>
Received on Fri Mar 31 2000 - 14:13:42 CEST