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
Received on Tue Nov 07 2006 - 07:29:24 CST
