OLE DB Access to History Information
I would like to access/extract OIT logged History data by means of the “ABB OLE DB Provider for HT”.
I have consulted the standard available documentation, but have not been able to find the OLE DB functionality described.
What I need to do is something like:
SELECT * FROM HistoryTable WHERE ObjectName=”MyObject” AND TIME>”2002-06-28 00:00:00”;
Can anyone point me to some documentation, or maybe some code/SQL samples that shows/explains how to accomplish the above?
I think that I will manage to create a connection via the OLE DB Provider, so my main worry is naming conventions and table structures.
System: PPA 2.1
Preferred language: VB
Best regards
ABB A/S - INPC - Denmark
Jesper Bolding
I have consulted the standard available documentation, but have not been able to find the OLE DB functionality described.
What I need to do is something like:
SELECT * FROM HistoryTable WHERE ObjectName=”MyObject” AND TIME>”2002-06-28 00:00:00”;
Can anyone point me to some documentation, or maybe some code/SQL samples that shows/explains how to accomplish the above?
I think that I will manage to create a connection via the OLE DB Provider, so my main worry is naming conventions and table structures.
System: PPA 2.1
Preferred language: VB
Best regards
ABB A/S - INPC - Denmark
Jesper Bolding
Answers
I found the document 3BSE025995_EMethods_Book.pdf (section 18)in <PPA installed dir>\doc useful.
/Edgar
/Edgar
Add new comment