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
1
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?

2
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?

3
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?

4
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?

5
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"
               col.Update
               Session.Output "1: " & col.Name & " " &  col.Type
               '1: TABLE_NAME char
            Case Else   
            End Select
         End If      
      Next
      'tab.Attributes.Refresh
      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
      Next
   Next
End Sub

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

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

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

Libor

7
Hi,

we currently face the same error as described in this topic
http://www.sparxsystems.com/forums/smf/index.php/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.

Libor

8
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".

9
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?

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

11
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?

12
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?

13
This is a follow up to my post http://sparxsystems.com/forums/smf/index.php/topic,37596.0.html, where you recommended me to program our own interface (actually the same has recommended me one guy from your support).
Ok, we are trying to program our own UI. Because our classes are in fact normal tables, we need to duplicate most of standard functionality of EA. But we are not able to find resources for some features. Could you tell me where to find list of extended properties for individual databases?

14
Hi,

is it possible to find automation scripta somewhere in the object model?

Libor

15
There has been made substantial changes in the data modelling in version 12. We have created some application which depends on some data modelling features from version 10. Now, we would like to migrate, but we see couple of serious issues, because following elements are no more accessible in EA version 12:
   Columns - no more tagged values and additional stereotypes
   Table operation - impossible to create operations of new stereotypes (and to use its columns, pre-conditions and tagged values)
Has anybody an idea how to handle this?

Pages: [1] 2