Re: How to link sequences to fields in Designer6.0

From: Paul Druker <pdruker_at_metaway.com>
Date: 2000/07/28
Message-ID: <7Ueg5.8357$R43.2137879_at_typhoon-news1.southeast.rr.com>#1/1


Álvaro

Sybrand is right, you can't bound sequence to a particular table in the Oracle database. However, there is a way to do it in Designer.

Open RON (Repository Object Navigator). Open a table and a column. In the "Column Properties" Palette you will see "Sequence" (under "Definition" group). This is your place to establish a link between sequence and a particular column.

HTH,
Paul Druker

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:964762083.6162.0.pluto.d4ee154e_at_news.demon.nl...
> You can't. sequences are not bound to any particular table, so you could
 use
> one sequence across multiple tables. You need to populate your column in a
> pre-insert trigger using
> select <sequencename>.nextval into
> <key_column>
> from dual;
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> "Alvaro Palma Aste" <apalmanospam_at_cec.uchile.cl> wrote in message
> news:8lqseq$knt$2_at_localhost.localdomain...
> > How can I link a sequence to one field of a table in Designer 6.0. I
 can't
 find any
> > option where input ORACLE sequence associated to the field
> >
> > Thanks for your answer
> >
> > Regards from Chile
> >
> > --
> > Atte
> >
> > Álvaro Palma Aste
> > Grupo de Ing Biomédica
> > U. de Chile
> > apalma_at_cipres.cec.uchile.cl
> >
>
>
Received on Fri Jul 28 2000 - 00:00:00 CEST

Original text of this message