Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Topics - bilon

Pages: [1] 2
Automation Interface, Add-Ins and Tools / Searching in scripts
« on: November 27, 2018, 02:28:09 am »
Is there any possibility how to globally search in all/selected scripts

Selecting the "Code engineering" menu on the table in a diagram contains several items including "Generate DDL". The same menu on the table in the project browser is almost identical, except for the "Generate DDL" item. Why? It would be natural to have both menus exactly same. I generate DDL for single table very often a why can't I do it directly in the project browser?

Automation Interface, Add-Ins and Tools / Repository.InvokeConstructPicker
« on: September 26, 2018, 12:20:23 am »
Is there a way how to distinguish between pressing Cancel and selecting <None> in this dialogue? It's obvious, EA is able to do it, but we aren't.

Automation Interface, Add-Ins and Tools / How to compare objects
« on: September 14, 2018, 10:03:16 pm »
I have two variables refencing packages and I want to check if they point to the same package. I'm sure they do. The test "p1.PackageID = p2.PackageID" is true, but the test "p1 Is p2" is false. Why?

We plan to relocate some tags. It looks, according to my tests, that it's enough to sync stereotypes and everything will be ok. Is there any other impact I should know bout?

Automation Interface, Add-Ins and Tools / Setting add-in description?
« on: August 08, 2018, 11:17:12 pm »
There's a "description" field in the Manage Add-Ins window. What is the source for this field? Am I able to set it?

We need to create parametrized script and enable users to set parameters interactively. My idea is to open add-in window from the script, which would enable to change the parameters, and then continue with the script or to call another script which would do the rest of work. Is it possible to do something like this or is it absolute nonsense?

I have simple script changing single property of elements attribute and subsequently iterating through elements attributes to display the new value. But the old value is displayed. Here is the script:

Sub Main
   Dim tab AS EA.Element
   Dim col AS EA.Attribute
   For Each tab In Repository.GetTreeSelectedElements
      For Each col In tab.Attributes
         If col.Name = "TABLE_NAME" Then
            Select Case col.Type 
               Case "varchar"
               col.Type = "char"
               Session.Output "1: " & col.Name & " " &  col.Type
               '1: TABLE_NAME char
            Case Else   
            End Select
         End If      
      For Each col In tab.Attributes
         If col.Name = "TABLE_NAME" Then
            Session.Output "2: " & col.Name & " " &  col.Type
            '2: TABLE_NAME varchar
         End If
End Sub

The new value is correctly saved to model, so why it is not displayed in the script?

General Board / Columnstore indexes for Sql Server tables
« on: January 02, 2018, 09:52:28 pm »

when modelling index for Sql Server table, I can't see any option for columnstore indexes. Is there any way how to accomplish this?



we currently face the same error as described in this topic,5480.msg125188/topicseen.html#msg125188
It is marked as solved, but I can't see there any solution. Is anybody able to help me? After adding new element to the collection and setting it's properties, subsequent update of this element ends up with mentioned error. Interesting is, that when not setting StereotypeEx property, it works fine. It works fine too (even when setting StereotypeEx property) when used against eap file. But in MySQL repository it ends up with the error.


Any idea how duplicate element from script? I need to do in script the same as do the browser functions "Copy element to clipboard" and "Paste element from clipboard".

General Board / Sql Server Datetime2 datatype length poorly generated in DDL
« on: September 15, 2017, 10:34:50 pm »
When setting DATETIME2 length to non-zero value, it's ok. For zero length EA generates DATETIME without length, which defaults to 7 in Sql Server. Does anybody know some workaround?

For index, TABLESPACE property works well, for primary{unique key it doesn't. Any idea how to do it?

General Board / How to remove foreign keys from duplicated tables
« on: September 09, 2017, 01:19:11 am »
I've duplicated table (through Copy / Paste element) with foreign key. I want to remove that key from the duplicate. When trying this through constraint, it tells me that correct way is through association. But I can't see any association for the duplicate in the diagram? Any idea how to do it?

We have recently migrated from EA10 to EA12 and some of our report templates give different rtf output then in EA10. It looks, EA12 inserts additional newline at the end of the "Notes" field. Any idea how to remove it?

Pages: [1] 2