Page History
...
Basic Modeling Demonstrations: Add/Remove, Item, String and Attribute Editing
| Topic | Description |
|---|---|
| Add Base Attributes |
...
...
| Adds base attributes to selected entities, which represent people. It will also introduce a primary key based upon the entity's name. | |
| Add Definition |
...
...
| Add a definition to selected entities. The definition applied to the selected entity will also include the object's name automatically, as in "My definition text + entity name +(s)" | |
| Add Parent Name Prefix to Propagating Key |
...
| Add the entity name as a prefix to all attribute role names. It demonstrates how to use the FKColumnPair object | |
| Add Table Name Prefix Globally |
...
| Add a prefix string to the names of all entities in the model. The macro opens a dialog box prompting the user for the prefix. If the current active model is logical, it will assign the prefix to all entity names. If the current model is physical, it will assign the prefix to all table names. | |
| Add Table Name Prefix Selectively |
...
| Add a prefix string to the names of selected entities in the model. The macro opens a dialog to prompting the user for the prefix. If the current model is logical, it assigns the prefix to selected entity names. If the current model is physical, it will assign the prefix to selected table names. | |
| Add Table Owner Globally |
...
| For physical models, this will update the owner field in the table editor for all tables in the active model. The active model must be a physical model. | |
| Add View Owner Selectively |
...
| For physical models, this will update the owner field in the view editor for all selected entities. The active model must be a physical model. | |
| Attachment Example |
...
| Exports attachment data for each bound attachment for every selected table in the active model. The file name and path is "C:\Attachment Data.txt. | |
| Attribute Binding Macro |
...
| Lists all the unbound attributes/columns of all the models (logical and all physicals) and domains. The attributes can then be bounded to any of listed domains by pressing the "Bind" button. | |
| Auto-Align Selected Entities Left |
...
| Performs the align left' operation (similar to the align buttons on the Alignment Toolbar) for all selected entities. This macro demonstrates more on how to use entity display objects. | |
| Auto-Color All Entities with FKs |
...
| Make all entities with foreign keys purple. It will first select (highlight) all entities in the current, submodel. Then it will make all selected entities with foreign keys (which, in this case, are all the entities in the submodel) purple. Finally, it will deselect (unhighlight) all entities in the current, active submodel. This macro illustrates how to use entity objects, entity display objects, and selected objects - and how to distinguish among 'them. | |
| Auto-Combine Selected Entities |
...
| Takes all the attributes from all the selected entities and add them into one newly created entity. Includes a separate function GetAveragePoint(), this function will get the average x or y coordinate point among all selected entities. The second parameter determines whether to calculate the average x coordinate or the average y coordinate. | |
| Auto-Convert Datatype |
...
| Iterate through all the selected entities and change the datatypes for all attributes which use VARCHAR to TEXT. | |
| Auto-Create Data Dictionary and Bound Domain |
...
| Creates a new diagram, then create a rule, default and domain in the data dictionary. Then it will bind the rule and default to the domain. Next, it will then create an entity and an attribute. Finally, it will bind the domain to the attribute. | |
Auto-Create Data Dictionary - Creates a user-defined data dictionary quickly. The macro can be used as a template to create user-defined or business-specific data dictionaries. This macro can be inserted into ER/Studio's ERSBasicHandlers system (specifically in the '"CreateDiagramHandler(CurDiagram As Object)" section of ERSBasicHandlers) and if the Create Handlers option is checked on in ER/Studio's Automation Interface Options, this Data Dictionary will be created and populated any time a user creates a new diagram.
...