Creating DB sequences with EA?

[rabra]

Hallo,

with EA I can create Database tables (Oracle) and generate the DDL.

I tried to create / generate a sequence by creating a class (table) in EA and marking the option 'Generate Sequences' in the 'Generate DDL' window. The effect was the sql script which created a table not a sequence.

Do I really have the possibiliby to generate a seaquence with EA? If yes how is the way?

Thanx,
rabra

[«Midnight»]

Hi Rabra,

This came up recently - I think during the past two builds (832, 833) - and one of the Sparxians posted something that clarified the situation.

Of course I simply don't remember what that answer was. It might have been that things were going to be corrected soon, or that sequences would be (better) supported in an upcoming release. Or perhaps there is something you can do now.

Search the forum for sequence and oracle, going back a month or three. You should find the answer.

David

[rabra]

Hi,

what I found out in other (older) discourses was:

Already in EA 7.0.818 I can create Oracle Sequences:

1. Create a table (class) in EA
2. Create at least one column
3. For this column in 'column Properties' check 'AutoValue' and set 'start value' and 'increment'
4. To generate DDL check 'Generate Triggers' and 'Generate Sequences'

This lead to the wished result.

Rabra