VBA Rubberducking

Duga

00:01

RELOAD!

[rubberduck-vba/Rubberduck] 2 opened issues. 18 issue comments.

[rubberduck-vba/RubberduckWeb] 1 opened issue.

[Minesweeper] Games Played: 158, Bombs Used: 94, Moves Performed: 21448, New Users: 22

Duga

00:13

[rubberduck-vba/Rubberduck] Vogel612 synchronized pull request #4984: Fix various bugs - Especially centered around the InspectionResults toolwindow

Vogel612

aight with that I'm out for tonight. I still don't have the slightest clue how the Grouping stuff works exactly

Mathieu Guindon

thanks @Vogel612, good night!

Duga

[rubberduck-vba/Rubberduck] zspitz opened issue #4987: Parse tree visualizer for Visual Studio

> **Justification**
[This wiki page](https://github.com/rubberduck-vba/Rubberduck/wiki/Viewing-a-live-preview-of-parse-tree) recommends installing Eclipse and an Eclipse plugin in order to view the parse tree. Writing a debugging visualizer for Visual Studio is relatively straightforward.

**Description**
I would consider writing a custom debugging visualizer for this purpose (I've done [something comparable](https://github.com/zspitz/ExpressionToString#visual-studio-debugger-visualizer-for

[rubberduck-vba/Rubberduck] zspitz added label enhancement to issue #4987: Parse tree visualizer for Visual Studio

Duga

00:32

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4987: Parse tree visualizer for Visual Studio

> I would absolutely love to see this available natively in Visual Studio. Having to install Eclipse and getting the plugin is a huge PITA in itself, especially for those unfamiliar with Eclipse's idiosyncrasies.

I'm not 100% sure whether the same visualizer would be used between the Visual Studio (e.g. the contributors of Rubberduck project) and the Rubberduck's end users. I don't think the parse tree is that terribly useful to those unfamiliar with the ANTLR, and there are far much more no

this

Hmm, just noticed this new Security tab

Duga

[rubberduck-vba/Rubberduck] build for commit ed717dfe on unknown branch: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] build for commit ed717dfe on unknown branch: 64.23% (target 0%)

Mathieu Guindon

              Off:
            Automated security fixes

this

just found the blog about it - doesn't seem useful, unfortunately. It's mainly for JS and Rails

Mathieu Guindon

yeah

or nuget, no?

this

00:40

you'd think so but the article doesn't suggest so

Mathieu Guindon

hm

Duga

01:08

[rubberduck-vba/Rubberduck] web-flow pushed commit 6717f02e to next: Update thanks-.md

[rubberduck-vba/Rubberduck] web-flow pushed commit dea72203 to next: Update thanks-.md

Duga

01:52

[rubberduck-vba/Rubberduck] retailcoder edited wiki page Code Inspections

Duga

02:41

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #63: Website still mentions Source Control

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #56: Broken link on wiki Code-Inspections current release

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #55: Parser Error reported on certain For Next loop structure

[rubberduck-vba/RubberduckWeb] retailcoder added label help wanted to issue #49: The web indenter does not understand one line if statements

[rubberduck-vba/RubberduckWeb] retailcoder added label bug to issue #49: The web indenter does not understand one line if statements

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #45: Indenter page needs to warn about the indenter being case-sensitive

[rubberduck-vba/RubberduckWeb] retailcoder removed label bug from issue #49: The web indenter does not understand one line if statements

[rubberduck-vba/RubberduckWeb] retailcoder removed label help wanted from issue #49: The web indenter does not understand one line if statements

[rubberduck-vba/RubberduckWeb] retailcoder created comment on issue #49: The web indenter does not understand one line if statements

> That would be the regex here:

https://github.com/rubberduck-vba/Rubberduck/blob/dea7220302fc660d328e2b77b8a8a9df048a46a3/Rubberduck.SmartIndenter/AbsoluteCodeLine.cs#L21

[rubberduck-vba/RubberduckWeb] retailcoder edited comment on issue #49: The web indenter does not understand one line if statements

> That would be the regex here:

https://github.com/rubberduck-vba/Rubberduck/blob/dea7220302fc660d328e2b77b8a8a9df048a46a3/Rubberduck.SmartIndenter/AbsoluteCodeLine.cs#L21

I guess it indents fine in the VBE because the editor "autocorrects" it to `End If`.

[rubberduck-vba/RubberduckWeb] retailcoder created comment on issue #32: Example code for each Inspection

> This is now live! 🎉

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #32: Example code for each Inspection

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #53: Does Rubberduck have a source control feature?

[rubberduck-vba/Rubberduck] IvenBach commented on Rubberduck.Core/Settings/ToDoListSettings.cs of pull request #4986: Allow reordering of ToDoExplorer header columns

[rubberduck-vba/RubberduckWeb] retailcoder edited issue #61: Accessibility and SEO issues

IvenBach

03:02

@Duga @MathieuGuindon is that along what you and Vogel had in mind?

Mathieu Guindon

yep

IvenBach

I'm stumped how to achieve that and IEquatable<T> at the same time.

Mathieu Guindon

?

what would T be?

I'd be happy with anything that has a Name and an Index, no?

actually, what is it that makes ToDoExplorerColumn specific to the ToDoExplorer grid in any way?

IvenBach

The DataGridLength Width but even that isn't specific.

Mathieu Guindon

exactly.. you've already solved the generic problem! ...just rename the class to GridViewColumnInfo or something like that :)

IvenBach

03:09

I have the correct words coming out, but I'm not having it click internally.

Mathieu Guindon

derive that class from ViewModelBase

IvenBach

public class GridViewColumnInfo : ViewModelBase, IEquatable<GridViewColumnInfo>?

Mathieu Guindon

yup

and now you can call OnPropertyChanged(); in your property setters

IvenBach

ok. I'm brain fogged right now from earlier today.

Duga

[rubberduck-vba/RubberduckWeb] retailcoder created pull request #70: Contact Page update to merge retailcoder/RubberduckWeb/master into rubberduck-vba/RubberduckWeb/master

> also makes the github api data refresh more often.

[rubberduck-vba/RubberduckWeb] retailcoder merged pull request #70: Contact Page update from retailcoder/RubberduckWeb/master into rubberduck-vba/RubberduckWeb/master

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #69: "Contact us" page needs a graphics tweek

[rubberduck-vba/RubberduckWeb] retailcoder pushed commit 516e08e3 to master: closes #69

[rubberduck-vba/RubberduckWeb] retailcoder pushed commit d8ce1cf9 to master: invalidate github api cache after 30 minutes instead of 24 hours.

[rubberduck-vba/RubberduckWeb] web-flow pushed commit 831d0dff to master

Merge pull request #70 from retailcoder/master

Contact Page update

Mathieu Guindon

03:22

@Duga live

</mug>

IvenBach

03:54

mumble mumble makes no sense mumble type is defined mumble WTF...

:barf: now you decide to work.

Fine then, be a stubborn MOFO. I'll outsmart you by making you a public field and abuse you until I make you do what I want, then I'll convert you back to a private auto property.

IvenBach

04:14

> Cannot build; files are in use.

Mkay that one's on me for once.

Duga

04:37

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #4986: Allow reordering of ToDoExplorer header columns

IvenBach

@Duga Hacking around it with lead me to breaking it again. Brain capacity at < 3%. Must recharge overnight to be affective.

I may need a breadcrumb to get me started if I continually whiff tomorrow. Hopefully a braintickle will get me on the right path the first time.

Unplugging for now and mind vegging</iven>

Duga

04:59

[rubberduck-vba/Rubberduck] build for commit 383169e0 on unknown branch: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] build for commit 383169e0 on unknown branch: 64.13% (target 0%)

Duga

11:42

[rubberduck-vba/Rubberduck] daFreeMan created comment on issue #4987: Parse tree visualizer for Visual Studio

> A setting to allow control of the level of detail visible in RD would be most helpful to those who write VBA but don't have a full, complete, in-depth understanding of what's going on. This could be a learning/teaching tool in addition!

Duga

12:03

[rubberduck-vba/Rubberduck] PeterMTaylor created comment on issue #4987: Parse tree visualizer for Visual Studio

> And visually see why inspections suggested by RD reflect a change in programming practice too.

FreeMan

12:44

monking!

I've got my ForEach Loop set up in my SSIS package. I've got an Execute SQL Task running a query and supplying a list of rows to the ForEach. It's assigning all the columns to variables per the instructions I followed here.

When I adjusted the connection in my flat file connection manager to use one of the variables, I'm getting this error:

> The file name """" specified in the connection was not valid.

You can see here that it's been cleared in the Connection Manager configuration.

However, I have the ConnectionString expression set in the Properties of the Connection Manager as shown here.

Have I totally missed something, or will the red X on the Flat File Source magically "go away" when the package executes and @[User::CompletePath] is populated with a valid value?

Note that the connection manager had a valid file name in it when I initially set it up, but it was set to "" when I edited the ConnectionString property - I didn't manually change it.

Mathieu Guindon

Is it preventing the build? If so just defer validation to runtime

FreeMan

> Build complete -- 0 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========

I guess not!

Oh, as an added bonus - that red arrow in the last picture is the divider between the Solution Explorer and the Properties windows, both of which are in their default docked position on the right side of the VS window. It it possible to adjust that divider to make one or the other taller?

I can't find the correct spot in my attempts to hover...

(i.e. the cursor never changes shape to indicate "drag here!")

FreeMan

13:39

@MathieuGuindon

May 29 at 18:48, by Mathieu Guindon

if you figure out anything simpler than setting up a SQL Server Agent job involving an SSIS Package Execution proxy user, a stored procedure in msdb that starts the job, and a stored procedure in a DB the VBA code can access & run... let me know, I'm interested :)

Care to share a little more detail on that and/or point me to some reading material?

this

hm. didn't I link to a blog article about that?

FreeMan

ah, yeah. that was a message or two down. Mah bad...

Unfortunately, Mat's suggestion of "defer" doesn't seem to be working. I've got those errors in the package noted above, and I get them still when I attempt to run.

> TITLE: Package Validation Error
------------------------------

Package Validation Error

------------------------------
ADDITIONAL INFORMATION:

Error at Package [Connection manager "BizSol SatSurvey"]: The file name """" specified in the connection was not valid.

Error at Package: Connection "BizSol SatSurvey" failed validation.

Error at Package [Connection manager "BizSol SatSurvey"]: The file name """" specified in the connection was not valid.

Error at Package [Connection manager "BizSol SatSurvey"]: The file name property is not valid. The file name is a device or contains invali…

Quack Exchange

0

Q: Show File/Folder Hierachy as Grouped with Indentation

I was intrigued by this question on SO and was able to come up with a reasonably efficient answer, but I'm interested in learning about further optimizations. You can certainly look at my answer to that original question for some explanations of how I've implemented certain logic, but I'm happy t...

vba

this

If those are expressions they have to be deferred because by default SSIS eagerly validates everything, which it cannot.

I think you can do this at package level, too. I honestly can't remember if I disabled it at the task step or at package level.

FreeMan

Ah, ok, so defer is actually a setting. I'll go search & set.

that was almost too easy... Is this the one?

this

13:52

Yes but I also think you need the other setting - ValidateExternalMetadata

thesqlgirl.com/2016/09/17/ssis-package-validation

I wonder if we can keep DelayValidation to true but only set ValidateExternalMetadata to false

That'd allow you to get compile-time validation of flow but not the validation of the format itself since you can't do it anymore if the file path is now an expression.

As an alternative, you could consider having a default value for the expression but it's a dicey proposition because if it is allowed to run and doesn't change the value to the desired expression, it might end up taking the default file used for testing and put it in production. That's not fun. :)

FreeMan

well, I set all 3 and it ran. Albeit with errors, but it ran...

I got several of these types of error messages:

> Error: 0xC001F009 at Package: The type of the value (DBNull) being assigned to variable "User::Result" differs from the current variable type (Int32). Variables may not change type during execution. Variable types are strict, except for variables of type Object.

that makes perfect sense - I'm selecting several columns from my "load this data" table which I'm planning on filling in as the load progresses. Therefore, I'm getting NULL to begin with.

this

oh yes. I love how SSIS variables can't be nullable.

FreeMan

I guess I can't put a NULL in an Int32 SSIS variable?

jinx

this

MAKES TOTAL PERFECT SENSE!

FreeMan

instead of selecting the Result column on the initial selection, I need to have a step that updates it afterward based on some PK value that I select and put in a var?

OK... lots of little fun things to learn...

this

14:00

An alternative I can think of is to use a one-row ADODB recordset

which is questionable since the fields would be just Object/Variant

and you'd still have to do casting one way or other.

FreeMan

I still have all the work to do to assign result variables and put them back into the "load this data" table, so I guess I'll get there. I'd just like to know that it actually works!!!11!!11one!! on the whole looping principle first...

this

Actually I think that's why I ended up using a parameter table

KySoto

@MathieuGuindon oh i had a primary key, it just wasn't clustered.

Mathieu Guindon

huh I didn't even know that was possible

this

While clustering on an identity is a good default it's not always the best choice.

if you have a table that heavily depends on say, IncidentDate column, and they don't correspond to the order of insertions, then clustering on the IncidentDate while keeping the identity as the primary key may mean better query performance for those that depends on the IncidentDate

But for most tables, the querying patterns aren't as clean-cut, so it's hard to pick a good column to cluster on, so hence why identity is a good default.

KySoto

14:12

well in my case, i DO look most things up by primary key

this

That doesn't matter

The main benefit of clustering is with range scan

KySoto

well there wasnt ANY clustered index set

so i added in the clustering to the pkey, and then a second index on the second most used field

that is also unique

Mathieu Guindon

@ticker 500 line continuations won't run? #HeedTheSigns

Yes, fix the permissions and get a DBA to write the procedure if you have to. 500-liner SQL in a string literal is pure madness. — Mathieu Guindon 8 secs ago

Quack Exchange

14:30

-1

Q: Arrange Header's Data

I am working on a sheet of data with several headers and I would like to arrange each header in a specific column. My issue right now is that I have several headers througout the rows and I am only able to arrange the headers by the first set of headers in the first row and not in all the rows. I...

array vba excel

FreeMan

Holy Carp!!! it actually works!!!11!!11one!!

My little looping package actually went through all my "data to load" rows and loaded the data for them.

OUCH hurts elbow patting himself on the back

now to update the "data to load" table with the appropriate statistics and mark the rows complete!

Duga

14:59

[rubberduck-vba/Rubberduck] SystemsModelling opened issue #4988: Line number followed by multiple statement : parse error

>

Version 2.4.1.4729
OS: Microsoft Windows NT 10.0.17134.0, x64
Host Product: Microsoft Office x86
Host Version: 16.0.11629.20196
Host Executable: EXCEL.EXE

Sub ParseError()
1 DoEvents:
End Sub
"No viable alternative at input "DoEvents"

**Expected behavior**
No error

2019-06-04 15:49:58.2464;INFO-2.4.1.4729;Rubberduck.Parsing.VBA.RubberduckParserState;RubberduckParserState (91) is invoking StateChanged (Started);
2019-06-04 15:49:58.6214;INFO-2.4.1.4729;Rubberduck.Pars

[rubberduck-vba/Rubberduck] SystemsModelling added label bug to issue #4988: Line number followed by multiple statement : parse error

Duga

15:13

[rubberduck-vba/Rubberduck] retailcoder added label parse-tree-processing to issue #4988: Line number followed by multiple statement : parse error

Duga

15:23

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4988: Line number followed by multiple statement : parse error

> Did you know this `DoEvents` isn't an executable instruction, but a line label?

Rubberduck failing to parse a line with a line number and a line label is a blessing of a bug, IMO. Almost like *not* fixing it would be a better thing than fixing it and then implementing an inspection to locate line labels that look like they are intended to be executable statements.

[rubberduck-vba/Rubberduck] Vogel612 edited issue #4988: Line number followed by multiple statement : parse error

[rubberduck-vba/Rubberduck] Vogel612 added label antlr to issue #4988: Line number followed by multiple statement : parse error

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #4988: Line number followed by multiple statement : parse error

> Did you know this `DoEvents` isn't an executable instruction, but a line label?

Rubberduck failing to parse a line with a line number and a line label is a blessing of a bug, IMO. Almost like *not* fixing it would be a better thing than fixing it and then implementing an inspection to locate line labels that look like they are intended to be executable statements.

```vb
Public Sub test()
10 foo: foo
End Sub

Private Sub foo()
Debug.Print "foo!"
End Sub
```

Output: a

[rubberduck-vba/Rubberduck] SystemsModelling opened issue #4989: Home grown annotation throws parse finding

> For another addin which alters VBA code, I use my own annotation @notrace.
I guess I'll have to use some other prefix character if I want to use RD as well?

Public Sub O(ByVal ProjectLineNumber As Long, Optional ByVal Message As String) '@notrace

Annotation "notrace" is illegal in this context
An annotation meant to be specified at module level cannot be used to annotate members.

By the way, it would be handy to have a button or right-click shortcut to copy just *this* current inspe

[rubberduck-vba/Rubberduck] SystemsModelling added label bug to issue #4989: Home grown annotation throws parse finding

[rubberduck-vba/Rubberduck] Vogel612 added label enhancement to issue #4989: Home grown annotation throws parse finding

[rubberduck-vba/Rubberduck] Vogel612 added label feature-annotations to issue #4989: Home grown annotation throws parse finding

[rubberduck-vba/Rubberduck] SystemsModelling created comment on issue #4988: Line number followed by multiple statement : parse error

> It was originally Doevents: dosomethingelse
but I was stripping it down to the minimum for the report.
So it really was/is multiple statements on one line.

[rubberduck-vba/Rubberduck] SystemsModelling deleted comment on issue #4988: Line number followed by multiple statement : parse error

> It was originally Doevents: dosomethingelse
but I was stripping it down to the minimum for the report.
So it really was/is multiple statements on one line.

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4989: Home grown annotation throws parse finding

> > By the way, it would be handy to have a button or right-click shortcut to copy just this current inspection I am looking at so I can copy it and the error message into this issue report.

That's a neat idea! Seconded!

I think this `@CustomAnnotationForNonDuckyPurposes` warrants making `IllegalAnnotation` inspection simply ignore any annotation that isn't recognized as a RD annotation - note that this is different than the linked issue, where this was a parser-level issue.

[rubberduck-vba/Rubberduck] retailcoder edited issue #4989: Home grown annotation throws parse finding

Mathieu Guindon

@Duga and that DoEvents was a no-op line label

Duga

15:53

[rubberduck-vba/Rubberduck] SystemsModelling created comment on issue #4988: Line number followed by multiple statement : parse error

> Interesting. the "foo:" is indented left so it is seen as a label. And not executed. Thanks for that !
But DoEvents *is* recognised executed, as is, say, "Stop" and I guess other one-word statements.

[rubberduck-vba/Rubberduck] SystemsModelling created comment on issue #4989: Home grown annotation throws parse finding

> Then you'll have people complaining that their misspelt @Golder annotation was not reported. It's a tough call; one of us will have to give way; I guess I'll be the ship and you'll be the island.

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4988: Line number followed by multiple statement : parse error

> Ref #3175 -- Thunderframe listed some keywords that can't be a line labels. #FunTimes

[rubberduck-vba/Rubberduck] bclothier edited comment on issue #4988: Line number followed by multiple statement : parse error

> Ref #3175 -- Thunderframe listed some keywords that can't be line labels. #FunTimes

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #4988: Line number followed by multiple statement : parse error

> <s>Did you know this `DoEvents` isn't an executable instruction, but a line label?</s> *turns out it **is** executable.... just one of a bunch of obviously special-cased tokens*

Rubberduck failing to parse a line with a line number and a line label is a blessing of a bug, IMO. Almost like *not* fixing it would be a better thing than fixing it and then implementing an inspection to locate line labels that look like they are intended to be executable statements.

```vb
Public Sub test()
1

Mathieu Guindon

thanks @ThunderFrame!

3

Duga

[rubberduck-vba/Rubberduck] SystemsModelling created comment on issue #4988: Line number followed by multiple statement : parse error

> And for more detail:
This code raises the parse error finding at L2C6 (line label 1).
Comment the DoEvents line out or delete the line and the other two are not reported as parse errors.

Sub ParseError()
1 DoEvents: ' is executed
2 foo: bar ' foo is seen as a label and not executed
3 Stop: bar ' Stop is executed

End Sub

Sub foo()

End Sub

Sub bar()

End Sub

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4989: Home grown annotation throws parse finding

> Actually the "correct" solution to this is to have an allowlist for unknown annotations with a corresponding quickfix to enable users to allow certain annotations

[rubberduck-vba/Rubberduck] Vogel612 edited comment on issue #4988: Line number followed by multiple statement : parse error

> And for more detail:
This code raises the parse error finding at L2C6 (line label 1).
Comment the DoEvents line out or delete the line and the other two are not reported as parse errors.

```
Sub ParseError()
1 DoEvents: ' is executed
2 foo: bar ' foo is seen as a label and not executed
3 Stop: bar ' Stop is executed

End Sub

Sub foo()

End Sub

Sub bar()

End Sub
```

Vogel612

@Duga ~grrrrrrrr PLEASE format your issue comments!

Duga

16:14

[rubberduck-vba/Rubberduck] SystemsModelling created comment on issue #4980: Code Inspection doesn't see anything yet

> I get the same with Version 2.4.1.4729. Log file ends with

2019-06-04 17:12:16.2225;INFO-2.4.1.4729;Rubberduck.Parsing.Common.ParsingStageTimer;Resolved references in 3959ms.;
2019-06-04 17:12:16.2705;INFO-2.4.1.4729;Rubberduck.Parsing.Common.ParsingStageTimer;Determined module to module references in 41ms.;
2019-06-04 17:12:16.8245;INFO-2.4.1.4729;Rubberduck.Parsing.VBA.RubberduckParserState;RubberduckParserState (14) is invoking StateChanged (Ready);
2019-06-04 17:12:22.1775;WARN-2.4.1

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #4980: Code Inspection doesn't see anything yet

> I get the same with Version 2.4.1.4729. Log file ends with

```
2019-06-04 17:12:16.2225;INFO-2.4.1.4729;Rubberduck.Parsing.Common.ParsingStageTimer;Resolved references in 3959ms.;
2019-06-04 17:12:16.2705;INFO-2.4.1.4729;Rubberduck.Parsing.Common.ParsingStageTimer;Determined module to module references in 41ms.;
2019-06-04 17:12:16.8245;INFO-2.4.1.4729;Rubberduck.Parsing.VBA.RubberduckParserState;RubberduckParserState (14) is invoking StateChanged (Ready);
2019-06-04 17:12:22.1775;WARN-

Mathieu Guindon

@Mathieu Guindon : Field Size: Decimal, Format: General Number, Precision: 4, Scale 2, Decimal Places : Auto, other options are empty. I also tried to use adDecimal instead of adNumeric for the type of the parameter, it doesn't help. — Alsatian 1 min ago

^ @this wtf is Access doing there?

Duga

[rubberduck-vba/Rubberduck] SystemsModelling edited comment on issue #4980: Code Inspection doesn't see anything yet

> I get the same with Version 2.4.1.4729.

EDIT: I just had to wait five minutes for the inspections to appear. It's pretty slow.

Log file ends with

```
2019-06-04 17:12:16.2225;INFO-2.4.1.4729;Rubberduck.Parsing.Common.ParsingStageTimer;Resolved references in 3959ms.;
2019-06-04 17:12:16.2705;INFO-2.4.1.4729;Rubberduck.Parsing.Common.ParsingStageTimer;Determined module to module references in 41ms.;
2019-06-04 17:12:16.8245;INFO-2.4.1.4729;Rubberduck.Parsing.VBA.RubberduckParserStat

Mathieu Guindon

@Duga that NRE isn't helping

Duga

[rubberduck-vba/Rubberduck] SystemsModelling created comment on issue #4849: Code Inspection window section expansion expands all

> I'm still getting that in 2.4 Expand eg Code Quality and they all expand from Rubberduck Opportunities down.

Mathieu Guindon

@Duga and with any decent number of results, expanding can freeze the IDE for minutes. this is a showstopper bug IMO.

this

16:35

@MathieuGuindon put out a guess - TBH I don't normally use ADODB w/ Access as the backend.

Mathieu Guindon

Set Param = New ADODB.Parameter

Param.Type = adNumeric
Param.Value = 3.02

Param.Precision = 4
Param.NumericScale = 2

^ it's in the OP though

this

yuck. #MajorReadingMalfunction

Duga

[rubberduck-vba/Rubberduck] Vogel612 created comment on issue #4980: Code Inspection doesn't see anything yet

> @SystemsModelling that's understandable, considering the fix for this has not been merged into next yet.

Mathieu Guindon

@Duga lol

Vogel612

@Duga that is also not merged...

I like the bugreports but sometimes they really wear on my nerves

this

16:42

Be happy it's not at the level of "Why won't ducky talk back to me?!?"

Duga

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.Core/UI/Inspections/InspectionResultsControl.xaml of pull request #4984: Fix various bugs - Especially centered around the InspectionResults toolwindow

this

or "My screen is black, how do I fix it?

KySoto

if you shove your face through it... it will likely be red

Vogel612

@Duga nope, unfortunately not

Duga

[rubberduck-vba/Rubberduck] Vogel612 commented on Rubberduck.Core/UI/Inspections/InspectionResultsControl.xaml of pull request #4984: Fix various bugs - Especially centered around the InspectionResults toolwindow

[rubberduck-vba/Rubberduck] retailcoder merged pull request #4984: Fix various bugs - Especially centered around the InspectionResults toolwindow from Vogel612/Rubberduck/fix/various-bugs into...

rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] retailcoder closed issue #4980: Code Inspection doesn't see anything yet

puzzlepiece87

16:45

If I can get VS Prof 2017 for $280 and VS Prof 2019 for $1540, I should definitely get Prof 2017, right?

There's no feature amazing enough to be worth the $1260 price increase?

Vogel612

2019 has a complete testexplorer rewrite

this

there's also the .NET Core 3 to consider. I'm not clear if they'll backport to 2017

Vogel612

.NET Core is a MSBuild thing. VS2017 should be able to handle it

we're also on the new csproj format already, so .NET Core should be working just fine

this

this suggests otherwise

there are some saying they got it to work but as indicated it's not a supported scenario, so....

Vogel612

ohhhh. okay

this

16:50

also, I don't think we are actually using .NET Core 3 even for our build

puzzlepiece87

Oh, this is probably what I want: $500 2019 Prof standalone edition

this

I'm not sure what we are using for our SDK style but I don't think it's actually 3.0; otherwise, we woudln't need Sunburst in the first place.

Tweeting Duck

twitter.com/rubberduckvba/status/1135937073687465984

twitter.com/rubberduckvba/status/1135937077563015168

twitter.com/rubberduckvba/status/1135937075541348352

twitter.com/rubberduckvba/status/1135937083015671808

twitter.com/rubberduckvba/status/1135937079551156224

twitter.com/rubberduckvba/status/1135937084924080134

this

@TweetingDuck totally quacking it up today, eh?

Vogel612

small thread, soo...

@TweetingDuck @MathieuGuindon that thread is something for the "what bug made you wonder how computers ever worked" thread

twitter.com/jessfraz/status/1135360185290174464

Mathieu Guindon

16:56

ha!

@TweetingDuck "Erl"

grrr

this

@MathieuGuindon My Name is Erl

Mathieu Guindon

"Use vbWatchDog if you need actual call stack and line number info"

this

^

IvenBach

17:13

2nd time my Excel training for the office has been canceled. Starting to think there's a conspiracy.

this

you were going to lead it?

Duga

[rubberduck-vba/Rubberduck] pyhoon starred us

3

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created draft prerelease Prerelease-v2.4.1.4734

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot prereleased draft prerelease Prerelease-v2.4.1.4734

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot published prerelease Prerelease-v2.4.1.4734

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Prerelease-v2.4.1.4734

[rubberduck-vba/Rubberduck] build for commit 0db534ed on next: AppVeyor build succeeded

[rubberduck-vba/Rubberduck] build for commit 0db534ed on next: 64.23% (target 0%)

Mathieu Guindon

@Duga should show up on the website within 30 minutes

this

> I may have run into this. Had a 3k line stored proc in SQL Server that occassionally would actually corrupt the OS itself upon running and require full reimaging.

O_O

Mathieu Guindon

wut

IvenBach

17:33

@this Mostly going to be "There's a better way to do this" explanations for a lot of what I see in the office.

this

Soudns like you need to get a higher up to invest in this.

IvenBach

I think todays was rescheduled since it was already pushed back a week and we have HVAC work upstairs going on. Plus CEO/Owner is out on vacation this week.

If not :shrug: I have some RD time to code.

Tweeting Duck

18:15

twitter.com/rubberduckvba/status/1135959214180974593

this

@TweetingDuck FWIW that needs to be qualified - line numbers in code, we don't want. Line numbers outside the code, we want.

puzzlepiece87

18:47

@this Where is this from?

this

2 hours ago, by Vogel612

https://twitter.com/jessfraz/status/1135360185290174464

IvenBach

Achievement Unlocked: Take power out to the whole office. #FML

6

Mathieu Guindon

lol wat

bruglesco

@IvenBach What'd you do?

IvenBach

19:06

I will neither confirm nor deny whether I bumped into a meter which then may have fallen out of its mount.

In all fairness it is right in the entry way path.

Mathieu Guindon

wow that's dumb

IvenBach

@MathieuGuindon there’s a reason I’ve told you I shouldn’t have access to merge privs.

this

what?

no, no, no. I mean, why would they put a meter in an entry way path

Usually they're off to the side well away from any kind of usual traffic

IvenBach

@this spinny electrical meter things. #TIL the front part pops out.

this

or did California pass a regulation that electricians will not walk across the lawn to read the meter?

IvenBach

19:09

It’s in the electrical room. But on the wall right when you enter.

this

Still... You don't put it right there.

there's a reason why it's off to the side or toward the back, not at the front door, residential or commerical.

Anyway, look at this way.it's not really your fault. It was just #inevitable

Mathieu Guindon

@IvenBach it's ok, you're nowhere near GitHub's main power supply

5

FreeMan

^lol

IvenBach

19:37

@this Why not somebody else?

@MathieuGuindon Hah. Thanks Mug.

#DeepBreaths

IvenBach

19:59

@IvenBach that’ll teach them to cancel your training.

FreeMan

20:13

@IvenBach Oh, BTW, you can fix this by shoving a couple of 16d nails into the meter base to ~~short out~~ connect the mount points.

^ NOT highly recommended, though, unless the power company has shut you off for failing to pay your bill but you still need your satellite TV.

</FreeMan>

IvenBach

CoworkerWalkingIntoGlassDoor++;

4

Mathieu Guindon

that's hilarious

@IvenBach print a sign: "__ days without glass door incidents"

if (coworker.walksIntoGlassDoor) {
    coworkerWalkingIntoGlassDoor++;
    daysWithoutIncidents = 0;
}

^ mug idea

also, "I survived the glass door" t-shirts for survivors

IvenBach

20:52

Mathieu Guindon

lol

IvenBach

The new office is a death trap! Get out while you can.

IvenBach

21:12

Time to be productive and get to actual work.

Peter M Taylor

21:43

Oh dear....OHS trained staff will have their field days....@IvenBach have you been trained in that area?

IvenBach

What's OHS? Nope.

You mean osha.gov?

Or Is OHS Canada's equivalent?

Mark Balhoff

22:42

About as nice as I can say "Your edit is harmful" lol

IvenBach

Mark Balhoff

It's actually both hilarious and scary that one edit had that many glaring problems

IvenBach

^^ We need those notices now.

Mark Balhoff

@IvenBach lol

Mathieu Guindon

@MarkBalhoff rolled back =)

@IvenBach ha! that's even better!!

Mark Balhoff

22:46

@MathieuGuindon Thanks! I would have but alas I only have 1800 rep!

IvenBach

I just printed that page for co-workers.

Mark Balhoff

@IvenBach do you need mandated annual and incident-triggered Defensive Walking courses?

IvenBach

I don't.

Others in the office need it though.

Thinking about it I probably do...

Mark Balhoff

Make sure it's just as long and painful as the annual Defensive Driving modules

M.Doerner

23:12

And since you are at it, please also take part in the 8 hour module on steps and ladders.

Tweeting Duck

23:38

twitter.com/dan_abramov/status/1135999334397296640

IvenBach

Those can't be as bad as confined space videos. Surely not as bad as some of the Natural gas safety videos...

Transcript for