I need to modify MDB properties from Processbook or dot net form.
I am new to VBA/Dot net programming. can anyone please share some examples for writing data into PI MDB properties.
Can you share what you are trying to achieve here? I'm not sure if you are aware that the PI Module Database is 'depricated' in favor of PI Asset Framework. If you are starting up a new project I would suggest having a look at PI AF. If you are working on a new project: did you consider porting it to PI AF ?
If you do not have these options: did you have a look at the 'PI Module Database' section of the PISDK manual? You can access the manual from the start menu by going to 'About PISDK' -> 'help' -> 'PISDK help' or find the pisdk.chm file in your 'PIPC\Help\EN' directory.
There is a section there called 'PI Module Database', under 'PI-SDK Documention' -> 'PISDK Manual' -> 'Programming Topics' -> 'Working with Advanced Server Features' -> 'PI Module Database'.
First I would like to echo Michael's comment as to you should consider using the latest tools - i.e. PI Server 2010 R3 with PI Asset Framework (AF) rather than PI Module Database. If you really want/have to stick with PI Module Database, then you can use the PI SDK as Michael pointed out. Either you do that in the VBA environment provided in PI ProcessBook, or you create a custom .NET add-in in PI ProcessBook.
If you opt for the new technologies (i.e. PI AF) then you need to know that the AF SDK is purely .NET and therefore the easiest way is to create a custom .NET add-in in PI ProcessBook. Of course you could create a wrapper that makes some of the AF SDK functionality visible/available to COM-based environments such as VBA.
Either way, if you need a custom form to appear in PI ProcessBook and especially if this functionality is needed in the context of several displays, you probably want to consider a .NET add-in. I would invite you to watch this webinar and use the add-in templates we provide. Then please do not hesitate to initiate new discussion threads on this forum if you have additional questions on creating add-ins!
Michael & Steve,
thanks for your reply. we are using MDB for ACE calculations. Planning to switch to AF in future but for now we need to deal with MDB. I'll check the SDK help file this
Retrieving data ...