Messages

1

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: November 20, 2009, 01:13:25 am »

I have now set EA to Use JET 4.0.

My sql now works

Thanks

2

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: November 20, 2009, 12:43:52 am »

Hi Geert,
Thanks for your help so far.

I decided to go with your recommendation to do this via sql. After some tedious effort I came up with an sql query developed in Access 2007 that produces the information that I am after.
However when I took this over to EA to create a Custom SQL search, it came up with error  “DAO. QueryDef[3131]  Syntax error in FROM clause. The EA editor does not seem to like Inline views.

An example of what I am trying to do is below.

Select t_object.name ............
from t_object, (
                       Select end_object_id
                        From t_connector
                      where start_object_id = 7419
                    ) temp INNER JOIN  t_object t ON temp.end_object_id = t.Object_ID

It works fine in Access. My version of Ea is 7.5.848 and the Database version is 4.01.


Do you have any ideas on how I could go round this?


Thanks

3

Automation Interface, Add-Ins and Tools / Re: Developing a Traceability SQL

« on: November 12, 2009, 01:43:56 am »

Thanks Geert.
However I am struggling to do this recursive queries or Transitive Closure in Access as our EA is based on Access. I am an Oracle guy and in Oracle I would have a choice of Oracle SQL or stored procedure using a cursor to loop through.
I am currently learning C#. Is it possible to do this in C# and use it in EA and it so how?. The idea is to use it in search and eventually produce an RTF document of the search results.

Thanks for your anticipated help.

Tagem

.

4

Automation Interface, Add-Ins and Tools / Developing a Traceability SQL

« on: November 10, 2009, 11:08:32 pm »

Hello,
I have been asked to write an sql that would show related elements of an element, similar to how the Hierarchy Window works in EA. So basically if I have the following relationships (e.g agregations of requirements)
A -> B,  B -> C, C -> D, D -> E.  Then if I am asked to show the related elements of C, then the SQL should give me A, B, D and E.

Has anyone got a script or may be any ideas on how to accomplish this. The goal is to use the data from the sql to produce an RTF document.

Thanks

Tagem

5

Automation Interface, Add-Ins and Tools / Re: Automation Interface and Connectors

« on: November 10, 2009, 08:46:40 pm »

Thanks. Will try this.

6

Automation Interface, Add-Ins and Tools / Automation Interface and Connectors

« on: October 25, 2009, 02:12:53 pm »

Hi,
I am new to EA and also to VBA.

I have thousand + requirements that I have imported to EA using csv import. Now I need to create the aggregate relationships for the requirements, in other words, I need to create the connectors. It will be time consuming to do it via the tool, hence why I want to do it programmatically.

Please can some one provide me with advice on how to achieve this? Also any sample codes will be very useful.

Thanks

Tagem