Those declared outside the function are global and can be referenced by all functions. Variables declared within a function exist only within the scope of the function. You can declare any variable at any time before it is referenced by the code. Users can declare variables with the syntax of, Dim As Initiating a new Session of the ERwin API The code will be entered between these two statements. Then press OK:īack in the VBA editor, we see that the function has been defined for us: Sub RelationshipSync() End SubĮach function must follow this declaration and End syntax. Now locate the AllFusion ERwin API in the list and select it. The listed components are included, by default. The next thing that must be done is to include the API library so our code can reference it. NOTE: if you do not see the Immediate or Project windows, you can turn them on using the View menu items Type "RelationshipSync" in the Macro name field and press the Create Launch the Macro Editor using the Tools | Macros | Macros. menu option (the shortcut key is Alt + F8). Next, launch the Macro Editor from the Tools | Macros | Macros. Invoking the Visual Basic Editor in Microsoft Excelįirst, create a new spreadsheet in Excel. In our example, we will be using the Visual Basic editor that is built into the Microsoft Excel software, since most users have this software and will not require any new software installation. This document will use a sample that can also be used to sync Foreign Key (FK) indexes and constraint names.
#Object explorer on erwin data modeler how to#
The purpose of this document is to explain how to use the CA ERwin Data Modeler API to do that as well as to serve as an introduction to using the API.
![object explorer on erwin data modeler object explorer on erwin data modeler](https://reader008.dokumen.tips/reader008/html5/091507/61414324c6efc/6141432af1090.jpg)
![object explorer on erwin data modeler object explorer on erwin data modeler](https://dbmstools.com/storage/screenshots/erwin-data-modeler-lgjypdsho1jmnop2.png)
![object explorer on erwin data modeler object explorer on erwin data modeler](https://s1.manualzz.com/store/data/048947559_1-7658e8965d01e4c81e3d172f3d0953e0.png)