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

I answer to my self :-) (in spanish :)) ... Is the answer that I got from metalink:  

"
El valor inicial se an~ade desde el Designer Editor. Una vez que usted esta en el
designer editor seleccione el archivo de "Databases(Oracle)" --> despues selecione "User" ---> entre al usuario duen~o del schema, seleccionar "Sequence Implementations", buscar la secuencia que necesita cambiar y abrir el "property" de esta. En el property va a encontrar todos los valores que usted desee cambiar
"   

Greetings from Chile,    

Cristian Palma

Acuna Munoz Cristian Alfredo <cracuna_at_anakena.dcc.uchile.cl> wrote:
>Paul Druker <pdruker_at_metaway.com> wrote:
 

>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
>>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
>>> >
>>>
>>>

>--
>
 

--