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 - MrWappy

Pages: [1] 2
General Board / Unable to Obtain Table Information
« on: June 02, 2015, 04:50:27 am »
Started to check out the database builder.
Managed to set up connection and import schema all OK for access database. But then when I use the SQL Scratch Pad with simple SQL query e.g. SELECT * FROM t_authors

I get the message "Unable to Obtain Table Information" and no visible clues to what the error is.  I have tried various syntax changes as it states no pre-execution validate e.g. SELECT * FROM [t_authors] and making all caps but no clues on what's not working.

Seen in past post issues with ODBC drivers, but using 32-bit and that's all OK since the import worked OK; guess that's proof.

Anybody an idea of solution or where more information is logged that may help resolve.

Is there any more documentation on using the database builder than the single page in the CHM file?


General Board / Prefix for launch button on files pages
« on: December 09, 2007, 09:35:22 am »
Hi all

Does anybody know where the prefix for the launch button within a files tab is set - by default it adds http - problem is I have several files I wish to link to that are on a secure server hence require the https prefix (or alternatively known in which case I can include full path myself).



General Board / EA aware consultants
« on: December 09, 2003, 02:15:26 pm »

I have been looking for consultants who are EA aware and have come up with a blank.  Is anybody aware of consultants - ideally based in UK - who are EA aware, have good VBA etc to work with the Automation Interface and ideally have a strong background in high level architecture modelling and requirements management.


General Board / Importing requirements from Excel
« on: December 18, 2002, 03:28:28 pm »

I'm sure I saw something in a thread sometime ago about importing requirements from excel similar but can't seem to find it today.

I have a basic model into which I wish to add a lot of requirements that have been accumulated in an excel spreadsheet. So rather than cut and paste I would like to import them as requirement objects - both to save time & minimise errors!

Once in the model I can then sort them out into packages, etc.

Can it be done using VBA within Excel or do I need to write access code or ???

Any experience / ideas / examples of code to do this - Thanks

Bugs and Issues / Operation of TaggedValue HasAttributes fails
« on: July 08, 2015, 04:43:35 am »
I've been trying to use the taggedvalue methods such as HasAttributes (, but have been getting EA error messages (code 0xc00ce556)  (also see post on automation forum -( where you see that another experienced forum member has found the same issue with EA.

Tested with EA build 1214, corporate edition.  OS Windows 8.

  • Can you advise if there are any known issues with this method or the other TaggedValue methods?
  • What does the error message "Invalid at the top level of the document" mean?
  • Are there any preconditions/assumptions that could lead to an EA error message?  
  • Can you provide more details of what the error message means?  
If not, is there more information or examples of use available.

Many thanks


Not sure I've seen this before, but when I make a call to Tagged Value HasAttributes method, I get an EA error dialog pop up - with error code 0xc00ce556 and description "Invalid at the top level of the document"

My code is checking a set of tagged values,  and I assume the error is because one of them is not a structured type;  is that a pre-condition for making this call?  may be implied but not clearly stated (and when I call Getlasterror it returns an empty string).  If this is the case, is there an easy way to determine if a tagged value is structured, other than making a search in t_propertytypes for all tagged values?

I assume I am correct that the taggedvalue attributes relate to the structure type properties or perhaps I've misunderstood something.  

BTW: Even with structured types I'm not getting the results I would expect - has anybody got this part of the api working reliably?

Any information would be welcome.



Don't ask the reason but its to do with purely exploring EA, so probably not a real use case, just fun.  I can't seem to find a mechanism for a script running within the native EA scriptcontrol (not one under our program control) to make a call to a running addin, in which we have written known public callable methods.

I guess the question really comes down to - can I find a reference to the current instance of AddIn's class library that is being used by EA, and then it should be possible.  I've tried various windows process inspections but not gone too far.  I guess with perseverance I can look for processes whose parents and EA, and try to find the correct instance, but so far not found the correct object.

I haven't seen anything on the forum but wondered if anybody had done this or had a slick solution, otherwise I'll go back to diving in to the engine room of windows :(



Doing some testing exploring the capabilities of Scripts and the simple example provided in user guide

Session.Output "The square root of 9 is " & Maths.sqrt(9)

fails to work with "Object required: 'Maths'"

so checked case and other potential issues with typos but still same error.

User guide states that it is "inbuilt Maths object" so assume I don't need to install anything else or do I?

BTW: Does anybody have reference to details of scripting engines - whose are they?  what documentation exist?


Automation Interface, Add-Ins and Tools / Event on reload project
« on: May 03, 2014, 06:00:55 am »
Hi guys

Have I missed something in the broadcast events, but can't see anything that is raised on a project reload - is there or any ideas?


Automation Interface, Add-Ins and Tools / Access to user permission
« on: April 05, 2014, 06:49:39 am »

Does anybody know if there is a AI method to access user permissions
or at least get details of the group for the current user?

Reason being that I want to limit some actions to users who have administrator role in those instances where security is enabled for the current model.


Hi guys

Today I got around to installing V11 Beta 2 and have done some tests with several add-ins - some work fine whilst others crash EA and in some cases this blue screens windows :o

Tried on 2 different systems and seems to be repeatable!

So me thinks:
  • Have the system requirements changed?
  • Have any of the existing automation apis changed? In some of my addins I use a fairly extensive set and it seems to be these addins that are crashing so I suspect a change somewhere.
  • Anybody similar experiences?
  • Anybody found any new documentation - I remember there was something on the forum or Sparx web site about some new functions but nothing more.

Fair to say it's early days still for V11 but would be nice to get my stuff up to date ready for users  8-)

Any clues before I see if I can find out anything from the dump.


I am in the process of developing some example AddIns to demonstrate to potential developers.  Clearly they will all have their own preferences for developing software but the question that has come to my mind is:-

"what is the best language to write an AddIn?"

And further:-

"what are the best tools for developing and testing AddIns?"

Clearly there is a limited set of languages - VB, C++, C# - not sure if any others. And tools VS, sharpdevelop,...??

My answers are:
- VB.Net! The reason being circumstances - this is the language I was asked to use by my client for the 1st AddIn I developed and since Java isn't an option I haven't switched, and probably won't now due to familiarity.
- development is mainly done with VS-2010

Finally, any views on what would be good demonstrations - I've already developed some simple ones and plan to produce some more advanced AddIns so what would be good utilities.  I am aware of the good stuff done by Geert and Helmut but suspect I need to work at a level below these, at least to start with.

I would welcome your answers together with any views, suggestions and reasons for the choice e.g. Customer demand, no other options

Many thanks and happy christmas

Hi Guys

I've been playing with EA today rather than working (!) - trying to discover how some of the stuff I haven't used in EA works and in relation to Workflow have come up against a brick wall.

I get the scripts / event / functions etc - I looked back in the forums and can see that Phil and Geert had some function issues a long time ago, I assume that has all been resolved, but I didn't even get to the point that my functions were being called!

I think I have completely misunderstood what EA workflow is and how it could work.

I started with the assumption that I could define a process (in a diagram?) and provides some rules (e.g. in a script) stuff would move through the flow between users and subject to the rules?
Yes / No?

If yes is there an example / tutorial - couldn't find anything on Sparx site nor Google. Doesn't seem a lot written on this (same as many EA subjects).

So I assume NO - as none of the EA documentation (what little there is ! >:() provides definition of the process and clarity on terms.

So a few questions to help me, please:

1. What is meant by workflow - is it just that I can write code to intercept events that relate to creating/editing items and allow or otherwise?  Or can I define and execute the process I imagine?
2. Follow on from this is the workflow window under personal tasks - is this related and if so how.
3. What kicks off the calls to my workflow scripts?  I have a script and saw no calls - so assume I must do something. So what do I need to do to effect the call - are there settings (none found so far) that enable workflow for users / projects?
4.  Does EA call each script which has workflow functions? i.e. is it working on a broadcast as with the AddIn model.

BTW: I have security enabled and groups etc set up

Really interested in the answers, and of course examples.  

Workflow seems so promising ...


A little update:

I've observed that at times the calls to the events are called -  but behaviour seems to be odd, in that after making a change to a script you have to save it, refresh and then use.

If you only save then the event wasn't handled at all - i.e. appears that the script has been disabled.  Also appeared that it could take a few times and then I remembered that there was a potential issue with caching so assume that this is the same problem.  Not very friendly - so with lazy load off looks like it is working - however still interested in responses to questions above as this helps with the broader picture. Tnx

Automation Interface, Add-Ins and Tools / Reload project event
« on: October 28, 2013, 01:57:57 am »
I've been looking through the events and can't find anything that is raised when a user performs a "Reload Project".

Checked potential candidates e.g. obvious File Open, context change etc
but nothing fired and can't see anything in readme file, so guess that it's purely internal - anyone aware of anything?


I'm trying to select an object in the diagram.

In Diagram class it states that you do this by adding an item to its "SelectedObjects" collection, passing the ObjectID as a name (don't understand that)  and assume that the ObjectID is in fact DiagramObject InstanceID, but can't find a suitable method listed to perform this operation.  The collections AddNew method expects 2 strings (Name, Type)!  Not sure how I should interpret / translate this AddNew("ObjectID",InstanceIDasString)?

I've clearly missed something - anybody point me in the right direction.

Pages: [1] 2