I had a spreadsheet setup to retrieve foundation forces at each column using GetColForcesForLCase. If the column had a brace framing into the bottom, it would instead find closest node to column base (i.e. node in which brace frames into) and retrieve the imemberforces pointer for the node via INode.GetReactions. Now after updating to V17 every column with a brace framing into its base is giving me incorrect values. After taking the code step by step in VBA I noticed all of the imemberforce pointers now have 0 values for all axial,shear,and moments in the nodes. Before I pull my hair out trying to fix it, is there anything that might have changed that would require me to change VBA code? I looked at release notes and it didn't seem like anything was implemented that would impact this spreadsheet.
I'm not aware of any v17 changes that might be impacting your code. The INode.GetReactions method appears to be functioning properly for a test model that has nodes with columns and braces. My only thought is that your model needs to be analyzed and saved before forces are available. If you continue to experience a problem, please create a service request. I will need to take a look at your model and code.
just submitted a service request. I have spent some time combing through it trying to understand what is going wrong, and the information its storing in ILoadCase is just one long id and doesn't have all the parameters stored within it that I thought it used to.
Thanks Eric, good tip on the ILoadCases filter to simplify my code.
Regarding this issue, it seems like there is definitely something weird happening with DataAccess and not necessarily my code or RAM model, because when I comment out the suggested line of code, or any line of code for that matter, I get a "Compile error: Method or data member not found".
I noticed this same error when I commented out a different line of code and it jumbled up my variable assignments. I checked my Locals window in VBA and noticed the variable type being assigned to each variable got jumbled up. And it seems like this happens no matter how I edit the code.
I did not encounter those problems while working in your workbook and don't have enough development experience to comment on what might be causing the problems you are observing. However, RSS wouldn't run and interoperability with other applications would fail if DA was broken. Perhaps you are seeing some memory related issues and might need to flush things out to get squared away. See if rebooting or removing/adding the DA reference helps clean things up for you.
It must have been some weird memory issue but I copied code over to new spreadsheet, commented out node filter, and it works now! Thanks Eric, would be interested to hear if a problem is found and fixed related to this.
I found that the GetClosestNode method was using an incorrect index into the main list of nodes when the Nodes collection was filtered. That defect will be fixed in the 17.01 release (March/April).
Answer Verified By: Andy
Excellent!