Beginner: Howto create a Oracle sequence?

[gwi2008]

Hello,
I'm new to EA so please be patient. I'm creating a data model for Oracle and I have some ID's which should be generated by an insert trigger which uses an Oracle sequence.

Can someone give me a hint how to do this?

Another question: Is it possible to add a constraint to a table from a different data model?

Thanks for any help,
gwi

[«Midnight»]

For an Oracle sequence take a look in the EA help. It is indexed under Sequence | Oracle, DDL Options (and the same with for Packages appended).

I don't think you can do the constraint trick, but I'd love to be corrected on that.

David

[gwi2008]

The help is not that usefull:

If generating Oracle sequences, you must always select the Generate Triggers and Generate Sequences checkboxes; this ensures that a pre-insert trigger is generated to select the next sequence value to populate the column

This is all what's in the help file. If I just click on the checkboxes and then generate the DDL then no trigger and no sequence is generated. I mean this makes sense, because how should EA know what trigger and what sequence to create?

So the question remains: How do I create an Oracle sequence and the according pre-insert trigger in a data model?

Thanks for any help,
gwi

[«Midnight»]

Quite right gwi. I'm sorry I misdirected you.

Looking through the documentation I can't find the right spot. Nor can I remember how I handled this in the past. It's been a long time, and I don't even remember if I had EA create the DDL for the sequences. I keep thinking there are some limitations to what EA can do in this regard, but I simply cannot remember what they are, or if they are severe.

Search the forum for this. Go back quite a while, since this does not come up too often.

David

[hd]

On the column proerties dialog, highlight the column on which you want a sequence, click the [Column Properties...] button and check the Auto Number checkbox. Then generate your DDL with the items checked as mentioned in the help.

[RoyC]

I have updated the Help to fill in this gap.

We used to have a reference to the Column Properties but it went AWOL for some reason.  I can't understand how. Anyway, it's back and doing 500 press-ups as punishment for its deriliction of duty. Apologies.

[«Midnight»]

Thanks Roy. My Oracle work (with EA that is) went back to before your time with Sparx. I was likely referring gwi to the 'phantom' page, which neither of us could find afterward.

At least I might be able to help the next person who asks...

David

[gwi2008]

On the column proerties dialog, highlight the column on which you want a sequence, click the [Column Properties...] button and check the Auto Number checkbox. Then generate your DDL with the items checked as mentioned in the help.

I will try that - next week - I have the day off  8-)

Anyway - thanks for your help to all of you!