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

Pages: 1 ... 530 531 [532] 533 534 ... 630
7966
Oh. Is there any standard? I thought each vendor just invented its own flavor. iiRC IBM invented SQL in some of their labs. So I guess that there is some IBM standard for DB2. But there is no ISO standard or something like OMG?

q.

7967
Strange indeed. I just ran the same query (but with Perl) and it returned the right result. Which language is it you're using?

q.

7968
That's maybe because the query is failing for some reason. Please try to supply a "handmade" query and see what that returns.

q.

P.S. I tried with a bad SQL and got this:
Quote
<?xml version="1.0"?>

<EADATA version="1.0" exporter="Enterprise Architect">

</EADATA>

7969
Those errors are connected to XMI processing.

q.

P.S. The SQLQuery returned the following in my test:
Quote
<?xml version="1.0"?>

<EADATA version="1.0" exporter="Enterprise Architect">

      <Dataset_0><Data><Row><Expr1000>1</Expr1000></Row></Data></Dataset_0></EADATA>

7970
Quote
The query:
"SELECT COUNT(*) " +
                        "FROM t_connector " +
                        "WHERE t_connector.End_Object_ID=\'" + Element.ElementID + "\' " +
                        "AND t_connector.Stereotype = 'Architecture'";
Your above query compares End_Object_ID as being a string. But it is an integer. So the query will fail with a type mismatch.

q.

7971
Out of curiosity I tried to run Sparx' provided Java code but got
Quote
Error: Could not find or load main class org.sparx.javaexample.Main
What voodoo is missing here?

q.

7972
Good luck then. It took me a couple of years to find out how that all worked before putting that knowledge in my book. And that was AFTER having understood the API.

q.

7973
So it's not just reading. If you try to create packages you need to touch two tables and interlink them. That's much easier with the API. You should be familiar with scripting/the EA object model before attempting anything of what you mentioned (applies also for the notes update for packages).

q.

7974
Yes, sure. I use Perl quite often, but PHP should be possible too. You can create an EA instance and work with that. In order to access a RDBMS you need to supply an ODBC connection string which you get from the context menu in the Open dialog in EA. Just pass that to the Repository.OpenFile API call.

I guess that when you are talking about PHP you're mainly after reading the database with SQL. In that case you can also live without the API since it's more or less just a thin layer on top of the database.

q.

7975
I suggest to start with the API before manipulating the database directly. Have a look into my Scripting and Inside books.

q.

7976
Wasn't meant as offense rather than as joke.

q.

7977
Hey you guys! Is your office soooo large than you can't discuss this personally but instead have to use this forum?

q.

7978
It's definitely tricky - and interesting. Does look to me again like something one could sell as a little App :)

q.

7979
At a first guess I'd say you have to bite the bullet and analyze the y position, though I'm not quite sure what you mean exactly with discontiguous. I assumed object activation.

q.

7980
I guess the reason is simply that returning the nested packages would also bear the need for the structure of those. So you'd parse either way. Write a wrapper that returns a collection of nested packages in the order you want it.

q.

Pages: 1 ... 530 531 [532] 533 534 ... 630