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

[Quoted] Paul Druker <pdruker_at_metaway.com> wrote:

[Quoted] Thank you, Paul ... It really works (I'm Alvaro's brother (I use an account of a friend :))) ... But I have a new question: it is possible to set the start value of a sequence?

Thanks in advance,

Cristian Palma

>Alvaro
 

>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 [Quoted]
>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
>> >
>> > Alvaro Palma Aste
>> > Grupo de Ing Biomedica
>> > U. de Chile
>> > apalma_at_cipres.cec.uchile.cl
>> >
>>
>>

--