.NET
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Accessing database tables with AutoCAD PNID 2011
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Hello,
I'm having a problem accessing data manager tables in the 2011 version. My C# .NET code worked fine with 2010. Here is a sample of the 2010 code that works, but returns zero length tables in 2011.
C#
ProjectPartCollection oPP = PlantApplication.CurrentProject.ProjectParts;
PlantProject oPProj = PlantApplication.CurrentProject;
Project oProj = oPP["PnId"];
try
{
//get ACAD data table
System.Collections.Specialized.StringCollection strColl = Autodesk.ProcessPower.DataLinks.DataLinksManager.G
if (strColl.Count > 0)
{
String dlName = strColl[0];
if (dlName != String.Empty)
{
dlObj = oProj.DataLinksManager;
PnPDatabase pnpDB = dlObj.GetPnPDatabase();
// get a reference to all the tables in the P&ID project
// database
PnPTable drawings= null;
drawings = pnpDB.Tables["PnPDrawings"];
drawings.Select();
PnPRows drawingRows = drawings.Rows;
PnPRowIdArray DwgRowIndexes = drawings.SelectCachedIds();
......................................
........................................
end of try loop;
The last two lines fail to object any meaningful data in 2011. In 2010, I would have all the table rows and could access tags and asset information.
Any help would be appreciated.
Thanks,
Patrick
Solved! Go to Solution.
Re: Accessing database tables with AutoCAD PNID 2011
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
I do this and it works in 2010+
PnPTable drawings= pnpDB.Tables["PnPDrawings"];
PnPRow[] rows = drawings.Select();
I have had fairly unpredictable results using PnPTable.Rows, perhaps because of caching, but Im not sure at this point. The code above always seems to work.
Hope that helps
jess
Re: Accessing database tables with AutoCAD PNID 2011
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
Thanks.
I believe your solution is the only way to do it now. I've run into some other issues such that accessing some of the table parameters is not as easy as it was before and it probably is related to caching.
I've coded up this solution and it works for me for now. I have other scripts that may still be broken, but I'll deal with them later.
--Patrick
