Trouble with script & multiple elements

[motivatedgorilla]

I have the script below that works well for defining a relationship for a single element however I need to loop through a SQL query for all elements that the source element links to however am unsure how to do so. Can someone please help?

Code: [Select]

var selectedPackage as EA.Package;
     selectedPackage = Repository.GetTreeSelectedPackage();

     Repository.EnsureOutputVisible( "Script" );
     Session.Output( "JScript ConnectorExample" );
     Session.Output( "=======================================" );
          
     if ( selectedPackage != null )
     {
           // Create client and supplier classes under the selected package
           var client as EA.Element;
           var supplier as EA.Element;
           var clientID, supplierID;
          
               client= Repository.GetElementByID(9675)
               client.Update();
               supplier = Repository.GetElementByID(9676)
               supplier.Update();
            
               clientID = 9675;
           supplierID = 9676;

           selectedPackage.Elements.Refresh();
          
           // Get the connectors collection on the client element
           var connectors as EA.Collection;
           connectors = client.Connectors;
          
           // Create a new connector and set the appropriate details
           var c as EA.Connector;
           c = connectors.AddNew( "", "Realization" );

           c.ClientID = clientID;
           c.SupplierID = supplierID;
           c.Direction( "Source -> Destination" );

          
           // Save the connector!
           c.Update();
     }
     else
     {
           Session.Prompt( "No package selected!", 0 );
     }
    
     Session.Output( "Done!" );

[qwerty]

You don't need SQL in that case. Just iterate through SourceElem.Connectors and find Repository.GetElementByID(Connector.SupplierID) (or .ClientID depending how your connectors are oriented).

q.

[motivatedgorilla]

The issue i am having is how to plug a variable into say supplier = Repository.GetElementByID(testdestination)

[qwerty]

I'm no JScripter but

Code: [Select]

con = Elem.Connectors.GetAt(0);
e1 = Repository.GetElementByID(con.ClientID);should work.

q.

[motivatedgorilla]

I'm no JScripter but

Code: [Select]

con = Elem.Connectors.GetAt(0);
e1 = Repository.GetElementByID(con.ClientID);should work.

q.

Thanks qwerty. I'm not wanting to iterate through the connectors. I want to iterate through an array e.g. var testdestination = [9676,1234,9899]; which would then feed into Repository.GetElementByID(testdestination)

[qwerty]

Hm. Then what is the issue?

q.

[motivatedgorilla]

Hm. Then what is the issue?

q.

The issue is supplier = Repository.GetElementByID(testdestinationelement);. I get an "Internal application" error despite the value being an integer.

[qwerty]

Hmm. That could have a couple of reasons. Have you tried with supplying a simple integer. And then by first passing the array contents to an integer before passing that to the Get method?

Could also be a long/int issue.

q.

[motivatedgorilla]

Hmm. That could have a couple of reasons. Have you tried with supplying a simple integer. And then by first passing the array contents to an integer before passing that to the Get method?

q.

Yes. I was able to resolve the issue although it makes no sense. I needed to include quotation marks around the integer in the array e.g. "2".

[qwerty]

The values are some Win32 objects (variants). No idea how to create a dedicated integer in your language, but coercing from a nice string seems to work then.

q.

[motivatedgorilla]

The values are some Win32 objects (variants). No idea how to create a dedicated integer in your language, but coercing from a nice string seems to work then.

q.

What do you mean by "The values are some Win32 objects (variants)"?

[qwerty]

Maybe I was mislead by he way it's treated in Perl where the arguments are passed via Win32 OLE objects (variants). In Perl it does not matter whether you use a string or a number. Both will be converted the right way. But IIRC the parameters are generally passed as objects, not as primitives. To be honest, I'm not very sure how parameters are passed to the API of EA.

q.