Autonum in Column Properties inaccessible

[Max32]

Hi!

Autonum in Column Properties inaccessible (grayed and don't expand):


but in help is said that this feature must work:


This feature work in the version 7.0.x, but inaccessible in 7.5.xxx  

[«Midnight»]

There are a few places in EA where you need to first save an attribute - a column is a stereotyped attribute - before you can access the extended properties dialog(s). Try saving your column first, with minimal information. Then see if the button and dialog become enabled.

[Max32]

Of course attribute is saved! Button with caption "Column Properties..." is enabled. But! When i push this button "Database Columns Properties" window it is opened and TreeView node with caption "Column Properties" (see number 3 in the picture) is not expand. Node collapsed, grayed and don't expand. Try to do themselves and make sure.

[«Midnight»]

Make sure that the table has a DBMS set in the drop-down. Sometimes EA does not set a database, and some settings are disabled. This also shows up when you generate DDL, as many statements are missing or have strange syntax.

[Max32]

I understood!!!  8-)

This feature DON'T WORK on next type of database:
- Informix
- Ingres
- InterBase
- MSAccess
- Sybase
- Sybase ASE
:-/

and very well work on:
- MySQL
- Oracle
- PostgreSQL
- SQL Server 2000
- SQL Server 2005
- SQLServer7


So, tell me please is this a bug? and i can fix it self or not?

[«Midnight»]

And it should work in SQL Server 2008 if you can update your reference data in EA 7.5.

As for the DBMS engines it will not work with, I suggest you send the question to Sparx Support, perhaps just using their email address here.

Please post back to let us know what the answer is.

[Max32]

Yes! I have received the answer:

"...we will adjust the AutoNum options for a future release..."

and the most important part of the message:

"...In the meantime, there is a workaround. Highlight the column in question, and add the following tag in the tagged values window...
Tag: property
Value: AutoNum=1;StartNum=1;Increment=1;"

I have checked up is works!  

[«Midnight»]

Thanks for posting back with the reply. That's a valuable workaround.