t_xref-entries by script; generation of GUIDs?

[Michael Hafner]

Dear all,

I need to insert new entries into table t_xref via script - or better, I would like to subset properties automatically, and there seems to be no way to do this by using the classes from the Element Feature Package.

However, I can't insert anything into t_xref by Repositoy.SQLQuery because DAO expects a primary key in XrefID - which, in this case, is a GUID.

Is there a way to create valid GUIDs by script?

Thanks for any suggestions.

Michael

[Michael Hafner]

OK... - Repositoy.SQLQuery works only with SELECT statements. Anything else I can do?  

[qwerty]

Repository.Execute (insert_or_update_sql);

Undocumented and unsupported, but works.

q.

[Michael Hafner]

Ah, thanks a lot, qwerty; that's a big help!

But the Primary Key issue still troubles me.

Any hints?

M.

[Aaron B]

or better, I would like to subset properties automatically, and there seems to be no way to do this by using the classes from the Element Feature Package.

From the release notes for EA 9.3.935:

Automation Interface for Attributes now provides properties for SubsettedProperty and RedefinedProperty

Install the latest build of EA and try using SubsettedProperty on the EA.Attribute class.  Is that what you were looking for?

[Geert Bellekens]

Michael,

In most places EA uses standard GUID's, which you can generate from a whole host of libraries or databases.

A google search for GUID + your scripting language/database should get you a solution quickly.

Geert

[Michael Hafner]

Aaron, Geert,

I really love this forum. You always get answers (quickly), and they always prove helpful.

Thanx a lot!

Michael

[Michael Hafner]

Note to self :-)

sub main
      dim objTypeLib  
      dim strNewGUID
      Set objTypeLib = CreateObject("Scriptlet.TypeLib")  
      strNewGUID = objTypeLib.Guid
      Session.Output strNewGUID
end sub