Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic System Architect (steve huntington)
Decrease font size
Increase font size
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
Search Topic Search Topic
Topic Tools Topic Tools
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
 30-Aug-2006 14:23
User is offline View Users Profile Print this message


Jose Lima

Posts: 5
Joined: 24-Nov-2005

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
Report this to a Moderator Report this to a Moderator
 31-Aug-2006 20:00
User is offline View Users Profile Print this message


Duane Hennessy

Posts: 112
Joined: 18-May-2006

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.
Report this to a Moderator Report this to a Moderator
 1-Sep-2006 11:30
User is offline View Users Profile Print this message


Jose Lima

Posts: 5
Joined: 24-Nov-2005

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.
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic System Architect forum.
There are currently 1 users logged in.
The most users ever online was 16 on 30-Oct-2008 at 14:46.
There are currently 0 guests browsing this forum, which makes a total of 1 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.