Operation extended properties

[bsimon]

Hello over there,

How can I access an operation's "extended properties" ( Database operation properties dialog fields ) through automation ?

Hope somebody can help me with this,

Thanks

[«Midnight»]

AFAIK you cannot. There is a way to tweak these via the UI, but the extended properties themselves remain documented as read-only.

Although the documentation is being updated, the read-only status for properties appears to remain the case for the API.

You could always open a second channel directly to your model via OLEDB (or whatever) and insert or manipulate records in the t_objectproperties. Be very careful doing this, back up your model, and remember you are on your own if you go this way.

Perhaps you'd like to submit a feature request regarding making properties writable. Please search my recent posts for a best practice we (the user community here on the forum) are using for making such requests while keeping the rest of the community in the loop.

HTH, David

PS: If you are just trying to create stored procedures via automation, you're in luck. EA still supports the 'old' style of stored procedure container. In this case you use a stereotyped class, entering each stored procedure as an operation. Parameters and return type are entered as appropriate. This seems to work well with automation, although I sometimes find the presentation to be a bit constraining. But I guess that's why the new style was adopted - however, the choice of a read-only property for the code was a surprising blunder.

[bsimon]

Thank you for your reply.

I think I didn´t explain myself well.  What i need is to read the extended properties of an operation such as unique and clustered index properties, cascade delete and cascade update foreign key properties.

I´ve explored all of the "Method" attributes but none seems to provide the information I need.

Thanks again,

[«Midnight»]

I'm sure I knew the answer to this once...

Take a look at tagged values. Perhaps that's where they store the stuff.

I'll try to remember. Meanwhile perhaps someone knows where this stuff is.

David