Re: D2k - How to create a sequence?

Creating the sequence using SQLPLUS will not put it in the Designer repository. (unless you reverse engineer it). In Design Editor, under the Server Modal tab there is a Sequence section. It is there that you will be able to create sequences within Designer.

Chad Paquette
Junior Systems Analyst
Industry Canada
paquette_at_spectrum.ic.gc.ca

On Fri, 12 Nov 1999 22:33:28 GMT, "Claire M." <cmarcoux_at_webnet.qc.ca> wrote:

>Hi.
>
>The way to do it is:
>In your SQLPLUS Editor
>
>Create sequence s_dept_id
>Increment by 1
>start with 1
>maxvalue 999999
>nocache
>nocycle;
>
>And then it is done.
>Good Luck
>Claire M.
>
>
>Ken Halsted a écrit dans le message ...
>>I did this once and forgot how I did it, doh!
>>
>>How do you create a sequence definition in designer 2000. I have my column
>>defined in the ERD as a Number 10,0 and now I need to define a sequence to
>>associate with the column. At what point is this supposed to be created
>and
>>how?
>>
>>Thanks for your help,
>>
>>Ken.
>>
>>
>
Received on Sat Nov 13 1999 - 00:45:33 CET