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.


Messages - Geert Bellekens

Pages: 1 ... 6 7 [8] 9 10 ... 551
106
Bugs and Issues / Re: Project browser auto-side-scroll
« on: June 14, 2018, 04:51:39 am »
I think that was related with whether or not it would show the horizontal scrollbar, and that depends on the visual theme.

IIRC it doesn't auto-scroll if you use the Office-XP style.

Weirdly enough I just tried it in v13.5.1352 and I could make it auto-scroll anymore, not even with the office 2016 theme.

They might even have fixed it back then.

Geert

107
It's EA.Element.Type you are looking for.

Geert

108
Bugs and Issues / Re: Files on Sharepoint
« on: June 14, 2018, 04:41:14 am »
You should never put .eap files on sharepoint.

An .eap file is basically an Access database with another extension.
When using it tries to create a temporary lock file, which sharepoint doesn't allow.

Geert

109
General Board / Re: unchecked "Show Namespace" as default?
« on: June 13, 2018, 07:42:06 pm »
Have you tried the template package?

Geert

111
Automation Interface, Add-Ins and Tools / Re: Help with collections
« on: June 12, 2018, 04:53:32 pm »
Hi Dana,

EA.Collection is not a "regular" collection type.
It can be used to iterate elements in EA (e.g. Element.Attributes) or to create new objects in EA (e.g. set myNewAttrbute = Element.Attributes.AddNew("attributeName", "string))

You cannot use it as a general purpose collection type.
Instead you can either use an array (which is often annoying since it has a fixed size) or use a .Net ArrayList.
To create a new ArrayList use:

Code: [Select]
dim myList
set myList = CreateObject("System.Collections.ArrayList")

Geert

112
Latest information:
This appears to be a bug when one of the packages is selected to "Exclude From Generated Reports".  The random generation appeared when my 2nd package was excluded.  When I un-checked the exclusion box the issue went away.
-DN
Have you reported the bug to Sparx?

Geert

113
Have been running a mix of 13.5 and firstly 14.1420 and then 14.1421 for the last week or so and haven't encountered issues so far.

Same here, no issues.

Geert

114
General Board / Re: SQL Join problems
« on: June 12, 2018, 04:27:52 pm »
There are a number of macros that you can use in these situations.
#PACKAGEID# in this case.

See https://www.sparxsystems.com/enterprise_architect_user_guide/14.0/model_publishing/custom_sql_fragments.html for more info

Geert

115
General Board / Re: SQL Join problems
« on: June 09, 2018, 02:58:40 am »
this works:
Code: [Select]
SELECT req1.NAME AS From_Name, req1.NOTE AS From_Notes
FROM  ( t_object Req1
LEFT JOIN t_connector trace ON Req1.object_id = trace.start_object_id)

Start from there and then add more joins one by one, making sure your syntax stays correct.

Geert

116
Have you thought of importing the MDG into the model?
Your trial project could then import the trial MDG, and everyone that connect to that model has the correct version of the MDG without having to synchronize paths or anything.

Geert

117
General Board / Re: Import Database Schema and Foreign Keys
« on: June 08, 2018, 03:53:59 pm »
I don't think so.

What you are doing seems a bit strange to me.
By reverse engineering you create a model that is 100% the same as your physical database.
By adding FK relations that aren't there you are making a model that is no longer representing the physical thing.
What is the sense of having a physical model when it doesn't represent the actual physical thing, but rather the physical thing and then some other stuff that isn't really there.


I think you should either:
- forward engineer the foreign keys so they are in the database as well and will be there when you reverse engineer
- create these "foreign key who aren't really foreign keys because they don't exist in the database" relations on a logical model rather then on a technical model.

Geert

118
General Board / Re: SQL Join problems
« on: June 08, 2018, 01:21:50 pm »
Hi Sean
- t_connector1 does not exist. Use aliases like so
  t_connector c1 on c1.Start_Object_ID = t_object.Object_ID (I always use aliases for all my tables, much easier)
- I you are using a .eap file you'll have to use parentheses for your joins
something like
Code: [Select]
from (((( t_object o
inner join t_package package on o.package_id = package.package_id)
left join t_package package_p1 on package_p1.package_id = package.parent_id)
left join t_package package_p2 on package_p2.package_id = package_p1.parent_id)
left join t_package package_p3 on package_p3.package_id = package_p2.parent_id)

- full outer join why would you want to use a full outer join? Do you want to make a list of all elements and all connectors? I have never needed a full outer join, I would have to look up the syntax for that.

In general the best approach to this is to start small and then expand you query bit by bit. That will allow you to identify the syntax errors quite easily.

Geert

119
Suggestions and Requests / Re: New standard element property: ID
« on: June 06, 2018, 01:58:47 pm »
What is your reasoning for this not being a tagged value?

I agree, that is exactly what tagged values are for, to extend the standard properties with your own.

Geert

120
General Board / Re: Re-use existing MDG diagrams within a custom MDG?
« on: June 05, 2018, 10:13:51 pm »
I wouldn't be 100% the same as a regular SysML diagram, but I guess it would probably be close enough as the main purpose for a diagram type is to link it to a toolbox.

Geert

Pages: 1 ... 6 7 [8] 9 10 ... 551