System.Collections.SortedList throwing error for some users

AronGahagan / cpt-dev

Code repository for the ClearPlan Toolbar

https://www.ClearPlanConsulting.com

3 stars 1 forks source link

System.Collections.SortedList throwing error for some users #13

Closed AronGahagan closed 5 years ago

AronGahagan commented 5 years ago

Even with the proper reference set to C:\WINDOWS\Microsoft.NET\Framework\v4.0.30319\mscorlib.tlb setting an Object reference to "System.Collections.SortedList" is throwing an 'automation error.' Why?

AronGahagan commented 5 years ago

Looks like the user must have Microsoft .NET Framework 3.5 installed (even though the .dll lives under v4.0.30319??) so this may be a bigger issue than I'd anticipated. See here for more.

Need to start thinking about a workaround / alternative method in case this goes viral. I used SortedList and ArrayList all over the place. Oy.

AronGahagan commented 5 years ago

[x] Look into Dictionary, Collection, and ADODB.Recordset as alternatives. Which is fastest to replace? Probably ADODB.Recordset - I have most experience in this, and it's easily "sort-able." Refer to VBA for Smarties. The key thing needed is the ability to sort so I think that makes ADODB our Huckleberry.

AronGahagan commented 5 years ago

Temporarily closing this issue -- no users actually reported a problem. A user reported a problem on a different project whose reference to the required had a typo in the Environ("winddir") calll, which should have been Environ("windir") and I assumed a problem for this project as well. #NoAssume and #FingersCrossed