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 [2] 3 4 ... 751
16
Bugs and Issues / Re: V16 I am not able to connect to an MSSQL Repository
« on: October 21, 2021, 10:25:14 pm »
I've just tried to set up a custom data source to the MS SQL Server based repository.
When I try to open it the next error is displayed:
"An error has occured loading the requested project.
Microsoft OLE DB Provider for SQL Server [0x80040e14]
Argument data type ntext is invalid for argument 1 of the left function."
The same error is displayed when I try to open connection copied from EA 15.0.1513.
I think you are still using an old version of the database schema. The newer versions don't use any ntext columns anymore.
You can update your schema using one of the update SQL scripts you can download from the Sparx website.

Geert

17
PCS General Board / Re: Unable to add a repository to Prolaborate
« on: October 21, 2021, 07:44:04 pm »
Mo, you have to create a DSN (Data Source Name) before you can connect to it.

You don't have one any, so the dropdown can't shown you any.

Geert

18
General Board / Re: Co-existence of EA16 -64 and -32 bit ?
« on: October 21, 2021, 04:50:03 am »
I've only tried EA v15.2 + EA v16 (64bit) That seems to work just fine next to each other.

Geert

19
General Board / Re: Slow project transfer speed eapx to SQL Server
« on: October 19, 2021, 09:40:24 pm »
Well, for a SQL-SQL-Server you can simply use a SQL-Server backup.

q.
Unless you want to reload it in a fresh (updated schema) database, or you don't have access to the server, or...

But indeed, if you have the chance you should use SQL-Server backup restore. This usually only takes a few seconds.

Geert

20
General Board / Re: Slow project transfer speed eapx to SQL Server
« on: October 19, 2021, 08:47:31 pm »
The weird thing is that SQL-Server to SQL Server is not faster.

I think it's even faster to do SQL-Server -> eap file -> SQL-Server then it is to do a direct SQL-Server->SQL-Server project transfer.

Geert

21
You can use the existing shapescript only for very basic modifications such a changing the background color, or adding a decoration.

e.g.
Code: [Select]
shape main
{
//set the fill color based on tagged value "heat map"
if(hastag("heat map","good"))
{
//light green
SetFillColor(112,255,145);
}
else if(hastag("heat map","problematic"))
{
//light yellow
SetFillColor(255,253,170);
}
else if(hastag("heat map","poor"))
{
//light red
SetFillColor(255,142,142);
}
else if(hastag("heat map","not evaluated"))
{
//white
SetFillColor(255,255,255);
}
else if(hastag("heat map","missing"))
{
//light purple
SetFillColor(227,168,255);
}
//draw the parent shape
DrawParentShape();
}
For anything more complicated you probably want to completely rewrite the shapescript.

Geert

22
General Board / Re: Slow project transfer speed eapx to SQL Server
« on: October 19, 2021, 03:22:09 pm »
You can update the schema on a live database containing data.

No need to pass through a .eap file.

Geert

23
I'm pretty sure I've seen this working in an profile once.
Not one of mine though.

I think technically it should extend Property, but I'm not sure if EA thinks like that as well.

Geert

24
You want to leave this alone (leave everything checked) and play with the perspectives in Start | Desktop | Perpectives

The Set Active setting is to allow overrides of an existing technology (or default UML) by another technology. That is only useful for your own MDG's where you actually define an override.

Geert

25
PCS General Board / Re: Link from WebEA to external URL
« on: October 15, 2021, 02:28:58 am »
You can add hyperlinks in the notes of an element. Have you tried that?

Geert

26
General Board / Re: EA 16
« on: October 15, 2021, 02:26:42 am »
While on the subject of v16, its also worth considering the Javascript environment, now that it is the only (?) supported scripting language.

I haven't read that only Javascript is supported in v16. Where did you find that info?

Geert

27
Bugs and Issues / Re: V16 I am not able to connect to an MSSQL Repository
« on: October 15, 2021, 02:24:39 am »
I just started thinking. You mean mssql V15 right?
yes :)

Geert

28
Bugs and Issues / Re: V16 I am not able to connect to an MSSQL Repository
« on: October 14, 2021, 09:56:58 pm »
v15

Geert

29
Well I have changed the Execute:
Repository.Execute("UPDATE t_object SET Classifier_guid='" + theConnector.ConnectorGUID + "' WHERE Object_ID=" + proxyElement.ElementID + ";");

By:
   proxyElement.ClassifierID = theConnector.ConnectorID;
   proxyElement.Update();

However no relationship is created so ClassifierID and ClassifierGUID do not seem to be synonyms in this case.
No, you can't do that. EA expects an ElementID there, and if you are unlucky the ConnectorID is also an ElementID of a totally different element.

Geert

30
A feature that I didn't notice in the readme.txt is the fact that classically invisible elements such are notes and boundaries are now visible in the project browser, in a separate, blue package.

I find that a great improvement.

Geert

Pages: 1 [2] 3 4 ... 751