EA and SQL scripting

[bu66le]

We know that EA eventually stores everything into database or .EAP file, isn't it wonderful if there is a built-in support for SQL scripting in EA for tasks such as batch rename, batch copy paste (attributes and/or operations) etc? I personally believe this is a very flexible feature that would definitely increases productivity
What do u think? Should I write to feature request column?

[thomaskilian]

Doesn't your standard database support such kind of tasks already?

[bu66le]

standard database does support it but I'm not sure how to do that with .EAP file, cos that's what I'm working with

Also, editing the tables directly would introduce inconsistency if we are not careful enough, so I think there should be some kind of abstraction (view?) to be provided... or they are there already?

[thomaskilian]

Maybe I'm totally wrong, but it looks like you need an automation interface. Of course EA does not permit to actually manipulate its tables. But with automation you could do all these things you request.

[Bruno.Cossi]

The .EAP file is nothing but an MS Access database, .MDB file with the extension changed. Just open it using MS Access and you will see :-)

Bruno

standard database does support it but I'm not sure how to do that with .EAP file, cos that's what I'm working with

Also, editing the tables directly would introduce inconsistency if we are not careful enough, so I think there should be some kind of abstraction (view?) to be provided... or they are there already?

[bu66le]

thomaskilian is right, I should use the automation interface... it seems like modeling tools such as EA and rational rose prefer VB over other languages for scripting

thanks

[mikewhit]

... or Perl ...
http://www.sparxsystems.com.au/cgi-bin/yabb/YaBB.cgi?board=Automation;action=display;num=1096035939;

[Bruno.Cossi]

... or anything that supports COM interfaces...

Bruno