Is there a method (might be using PI OLEDB Enterprise) that I can extract AF attribute values to a Processbook using VBA.
Similarly do we have a method in Processbook to extact AF attributes, probably using PI OLEDB Enterprise Library.
Appreciate if you can share some code snippets.
conn.ConnectionString = "Provider=PIOLEDBENT.1;Data Source=hyong;Integrated Security=SSPI;"
query = "SELECT Name FROM [AFDB].[Asset].[Element] WHERE DBReferenceTypeID IS NOT NULL"
The example basically executes the query using PI OLEDB Enterprise, concat the output into a single string and display it on an existing Text symbol called "Text1". you can modify the query according to how you would like the output from the query to be displayed.
Note: you do have to add reference to the Microsoft ActiveX Data Objects Library for this to work.
This is exactly what I want. thanks a lot for this information.
Now, I will modify the query as per my requirement.