Help with tagged values please

[jump-jet]

Hi,

I want to create an SQL 2005 index on a table in a database model that will contain an INCLUDE clause when DDL is generated from it:

CREATE CLUSTERED INDEX [IX_MyIndex]
ON [MyTable] ([ID] ASC) INCLUDE([Name], [Description])

Its very easy to get EA to generate a plain index (without the INCLUDE clause), but I'm struggling to generate the additional output.

Sparx support have said that what I want is possible using tagged values, but I can't follow their rather sparse instructions.

So far, as instructed I've navigated to Settings | UML | Tagged Values and created a tagged value called INCLUDE.  I've tried using the String and Memo types in the Detail field (not at the same time!).

I've then opened the Properties dialog on the required table in my model, moved to the Table Detail tab and clicked on the Operations... button to open the Operations dialog.  Then I select the index that I want to modify from the list of operations.  The title of the dialog changes to <TableName> Operation: <IndexName>.

If I then open the Tagged Values tab, I'm presented with an empty property grid with just a '+' symbol in the top left corner.  The New Tagged Value button is disabled.



So how do I add a tagged value to the index?  Am I anywhere close?  Has anyone else done this?

Regards
David Razzetti

[jkorman]

How did you create your index?

I ask because when I created an index to check your steps, my "Tagged Values" tab displayed the index IX_Cover (Operation) in the display.

Jim

[jump-jet]

Hi Jim,

Thanks for taking the time to reply.  I created my index like this:

Double-click on the required table entry in the Project Browser.  This opens the Properties dialog for the table in question.
Choose the Table Detail tab (second from left on the row of tabs along the top of the dialog).
Click on the Operations... button.  This opens the Operations dialog for the table.
Enter a name for the index in the Name field.
Choose Index from the Stereotype combo box.
Press the Save button.  A matching new entry appears in the Operations list at the bottom of the dialog.
Select the Column tab.
Choose the first column for the index from the Column Name combo box.  Repeat as required until the columns for the index have been fully specified.
Select the Tagged Values tab.  The tab appears as described in my original post.

The root model type is "Data Model".
The EA version is 7.5.847.

Regards
David Razzetti