![]() |
Telelogic System Architect (steve huntington) | ![]() |
Topic Title: Accessing History table in a VB Macro Topic Summary: Trying to access the history of a property in a VB macro to list all the values the property had over time Created On: 30-Aug-2006 14:23 Status: Read Only |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
Hello,
I'm trying to list all the values that a property of a Definition had over time in a VB Macro in SA. How can I do this?
I can only access the History table in SAEM using the query SELECT * FROM Entity_History or in the Definition screen using the History Function button, but I can't find a way to access the history in VBA. This would be absolutely necessary since we are trying to import values from an external application and each time a new value is read it writes over the previous value, I would like to access all the historical values for each definition field and I wouldn't like to create a new instance of a "Value" associating it with the definition because this would result in a huge encyclopedia.
Anyone tried something in VBA related to the History of definitions/properties?
Thank you
|
|
![]() |
|
![]() |
|
You need to create a recordset in your VBA and access it that way. You can use the Encyclopedia object to get the connection string (which is actually held in the UDL file for the encyclopedia). So... I've attached code you can paste into a VBA module and walk through.
|
|
![]() |
|
![]() |
|
Thanks! I've accessed the Entity History table and I can now walk through the history of a certain type of definition and list the values that the property had over time and export them into excel for example.
|
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.