Wasn't me. I had to deal with the file that someone else provided. Learned that it was separated by semi-colon. Also seen em tab, pipe bar | and a couple other character delimited.
Is there any reason you don’t use a disconnected record set and just close the connection in the function you opened it? I wouldn’t keep a connection open any longer then you need
> As it stands, your answer reads like a comment. Please [edit] it to flesh up the valid point about disconnected recordsets, otherwise it will have to be converted to a comment, which can't be upvoted.
^ that would be my diamond-comment, if I had it
the valid point is literally worded as asking for clarifications
I agree with Mathieu here. As it stands this is not really an answer and more of a clarifying comment. If you could expand a bit on the point you're making and change the tone of the text to something more "answer"-y, that'd be appreciated. If you prefer to keep it like this, I can convert this to a comment for you. Just give me a heads up. Thanks! — Vogel612 ♦23 secs ago
I'm not having this discussion again. "answerer" posted an "answer" boiling down to "I'm too green to understand what's going on here, so I broke your code because I can't copy-paste and I'm making up Implements statements that aren't in the OP, so it doesn't work. Help!" - and if that's considered an "answer" by today's standards, the future is grim for CR. unlike the oh-so-important number-of-downvoted-answers metric.
"let's be welcoming" doesn't have to equate to "let's accept all kinds of garbage"
@MathieuGuindon This is not just a CR problem. Somebody made a comment on SO Meta about question votes to the effect that "One is the new zero.", and I'd probably extend that to "Zero is the new negative four".
@Hosch250 can github.com/rubberduck-vba/Rubberduck/blob/… ever be non-null? From what I've understood to date I'm saying no since CodeExplorerItemViewModel : ViewModelBase and ViewModelBase : INotifyPropertyChanged.
1) you have a declaration (sub/module/project). Get your declaration and get the folder annotation from there, walking up to the parent scope declaration if it's a sub, etc.
2) you land on a folder. From here, you need to get that folder and all its parent folders and concatenate the names with the separator set in the settings.
You have the node. If that node has a declaration, work from there. Otherwise, assume it's a folder node and concatenate the names of that folder and its parent folders.
That's what I've done so far. I think it was the lack of knowledge about the CodeExplorerCustomFolderViewModel that was causing the problem. I'm working through it right now.
When I right click on the virtual folder (the type is CodeExplorerCustomFolderViewModel) and use GetSelectedDeclaration() that's when the return value is null.
Duck check: @Comintern mentioned using a try-catch block since I'm using IO input to write to a create a temp file, write to it, import it, and subsequently delete it. How do I go about adequately logging if something barfs? I've looked at Logger.Log() but have never done any actual logging before.
@Vogel612 but i'm still missing something I htink - where are the vulnerabilities reported? Those seem to be just a simple listing of dependencies the RD has
sorry but that is how I feel. Obscure and unintuitive syntax, unhelpful error message, crappy documentation and various samples that don't work as-is. need I go on?
Today I had to basically combine pieces from 3 different samples just to put together something that'd work, with lot of documentation lookups and googling up the nonsensical error messages only to find out that Microsoft has been changing their APIs.
no, i'm trying to automate stuff with Azure, and they love dem poewrshell for automation, so I have to go as the Romans goes.
so they're just new scripts but the process of developing a script in powershell is far far more painful than doing the same task in C# or even VBScript would be.
Is there any reason you don’t use a disconnected record set and just close the connection in the function you opened it? I wouldn’t keep a connection open any longer then you need
VBA Rubberducking
VBA Rubberducking