Re: Designer 6i Sequence generation problem

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 09 Nov 2006 08:56:21 +0100
Message-ID: <4552DF25.2060108@arcor.de>

mwmann schrieb:
> Maxim Demenko wrote:

>> mwmann schrieb:
>>> On Nov 7, 12:59 pm, Maxim Demenko <mdeme..._at_arcor.de> wrote:
>>>> mwmann schrieb:
>>>>
>>>>
>>>>
>>>>> Hi
>>>>> Please if anyone can help, it would be greatly appreciated, I have been
>>>>> tearing my hair out for days.
>>>>> I have created the sequence in designer, however I can not find where
>>>>> to set sequence attributes, such as min_value,max_value etc.
>>>>> This is the default DDL generated:
>>>>> CREATE SEQUENCE TASK_HISTORY_SEQ
>>>>>  NOMAXVALUE
>>>>>  NOMINVALUE
>>>>>  NOCYCLE
>>>>>  NOCACHE
>>>>> /
>>>>> This is the generated sequence on the database, resulted from running
>>>>> the above DDL:
>>>>> select * from user_sequences where sequence_name='TASK_HISTORY_SEQ';
>>>>> SEQUENCE_NAME     MIN_VALUE                      MAX_VALUE
>>>>> INCREMENT_BY C O CACHE_SIZE  LAST_NUMBER
>>>>> --------------------------- ------------------------------
>>>>> --------------- - - ---------- ------------
>>>>> TASK_HISTORY_SEQ          1    999999999999999999999999999
>>>>>  1 N N          0            5
>>>>> My problem is that my field which will be populated by this sequence
>>>>> has a MAX length of 6. Eventually this will be a problem and is bad
>>>>> design.
>>>>> I do not want to modify the DDL, as the whole point is the repository
>>>>> definitions are correct, and ddl generated, not later modified.
>>>>> WHERE DO I SET THE SEQUENCE PROPERTIES IN DESIGNER ?You can customize sequence implementations if you go to Optons ->
>>>> Customize... -> Sequence Implementations
>>>>
>>>> Best regards
>>>>
>>>> Maxim
>>>
>>> Thanks maxim, one step closer. I see where you are talking about,
>>> however when I 'tick' the relevent properties to be displayed, I dont
>>> know where to set those properties, I cant see those attribute in the
>>> property pallette, RON, or anywhere else........
>>> Where should I be able to set these, once I have set to display the
>>> relevant attributes in options..... ?
>>>
>>> Thanks again
>>>
>> When you have set the properties to be displayed, you can adjust them on
>> individual seqences in DB Admin (not in the Server Model) pane by
>> clicking on respective sequence.
>>
>> Best regards
>>
>> Maxim

>
>
>
> Hi Maxim
>
> This seems so trivial, but I can't (I wish I could post a screen shot)-
> I have specified the following:
>
> DESIGN EDITOR
> --->Options
> -------->Customize
> ------------->Sequence Implementations
> ------------------->Show Properties Tab
>
> The following attributes 'Display Column' is ticked:
> Sequence
> Maximum
> Minimum
> Order
> Cycle
> Cache Value
> Increment
> Start
>
> Save/Apply changes.
>
>
> In DB ADMIN tab,
> --->Expand Application Node
> ------->Expand Server Model Definitions
> ------------->Expand Sequence Definitions
>
> My 10 sequences are shown:
> However there are none of the above specified attributes to change in
> the property pallete, nor anything to change/set when I 'double click'
> on the respective sequence to edit the sequence in the 'wizard type
> style dialog' ?
>
> Am I doing something wrong here ?
>
> I could email you screenshots if that will help?
>
> Thanks again for your time and help with this.
>
> ----
> Mike
>

Hi, Mike, maybe, my screenshots can help you.

http://www.flickr.com/photos/83197247@N00/292888409/
http://www.flickr.com/photos/83197247@N00/292888411/
http://www.flickr.com/photos/83197247@N00/292888412/

My Designer version is 9i, but that should not make any difference (hopefully)

Best regards

Maxim Received on Thu Nov 09 2006 - 01:56:21 CST