VBA Rubberducking

That's what I thought. It's getting cold there already? You're not participating in the heat wave that's sweeping the nation as a new fashion sensation? (or something like that...)

Hosch250

Freezing. Like 60 degrees and lower.

I missed the whole summer :(

IvenBach

@Hosch250 <sarcasm>We're sweltering here in 85°F heat right now.</sarcasm>

Hosch250

@IvenBach That's not sweltering, I love that temperature.

FreeMan

sounds nice. IN is still in standard summer time humidity fest mode. 85+ and humidity to match.

IvenBach

7:28 PM

Forgot to include my wrapper.

Hosch250

OK, have two minutes.

IvenBach

I forget tone doesn't transfer well in text.

shadowofsilicon

@Hosch250 No shit! Where in MN? I'm in MN too! =)

Hosch250

Plymouth ATM. Mahtomedi after work.

Raining and windy and cold.

OK, GTG, TTYL.

FreeMan

Current temp: 88°F, feels like 93° (BS - more like 103...) with only 56% humidity. :(

shadowofsilicon

7:29 PM

Ah... I'm in Alexandria

IvenBach

@FreeMan Where you at?

FreeMan

Indianapolis area

IvenBach

Am I one of the few/only west coasters?

Is there a way to flag a page for discussion rather than just making a blatant change? I'd rather consult for a consensus before.

FreeMan

isn't that what chat's for? ;)

IvenBach

#Derp

github.com/rubberduck-vba/Rubberduck/wiki/Introduction mind if the order is ~~Basic>Proficient>Competent>Advanced>Expert~~ in ascending order?

Looked at the referring article en.m.wikipedia.org/wiki/Dreyfus_model_of_skill_acquisition and got the order all wrong.

FreeMan

7:37 PM

I'd prefer to see the table auto-size and/or have narrower margins within the browser window so I can see the whole thing without side scrolling than worry about the order of the column headers, though I agree your ordering seems to make more sense.

Brandon Barney

Feast your eyes on this boys : stackoverflow.com/questions/45492958/…

" It has worked fine for 2 years"

IvenBach

Proficient/competent could be considered synonyms thesaurus.com/browse/competent. Is there a more appropriate word?

Brandon Barney

While they may be synonymous in meaning, the contextual/dialectal meaning is different. Competent < Proficient

IvenBach

@BrandonBarney Sweet-mother-of-duck...

3

Brandon Barney

Yup lol

IvenBach

7:41 PM

@BrandonBarney My cave-man sense tingles because I think Proficient<Competent.

I'll gladly defer because words are hard for me.

@BrandonBarney #IfItAintBrokeDontFixIt

Brandon Barney

Really? Any time I hear competent I think "They know enough..." whereas proficient I think "They are fairly decent..."

@IvenBach As with any code that bad...it will break...and it did.

2

IvenBach

That code brought a tear to my eye from laughter...

I think the only time I've had code like that was when I used the macro recorder.

FreeMan

@BrandonBarney at least he uses Wb1 and Wb2 instead of ActiveWorkbook or .Activate!

Brandon Barney

^ Very true. Deserves some credit I guess :). Though the lack of a With block still puts him at a severe credit deficit.

shadowofsilicon

@BrandonBarney Oy... Looks like something from my company's engineers :(

Brandon Barney

7:45 PM

@shadowofsilicon I am concerned for your company...and the engineering industry now.

2

shadowofsilicon

Eh... They are good mechanical and electrical engineers... It's just that none of them have a software development background. To be fair, even "machine programming" isn't anything near true OOP software development.

IvenBach

Engineer != writesGoodCode

FreeMan

@shadowofsilicon Shouldn't be - Machines tend to run on tight schedules and don't have time for all the OOP overhead.

IvenBach

For the RD wiki page is you should or one should preferred?

That's 2nd and 3rd person, respectively? I get them mixed up.

shadowofsilicon

That's true... computational resources are minimal. But the bigger thing is that none of the IEC 61131-3 languages come close to OOP -
http://www.controleng.com/industry-news/more-news/single-article/speaking-in-tongues-understanding-the-iec-61131-3-programming-languages/4123b0e66c3f2cb8bdd60d3cb20f944d.html

Duga

7:56 PM

[rubberduck-vba/Rubberduck] PowerAccess commented on issue #3215: VBE Toolbars Position & Visibility Aren't Persisted

> I was wondering that as well, so I had tested with repositioning built-in and other add-in toolbars to see if crash-on-exit killed prevented them from being persisted, and those layout changes for non-Rubberduck toolbars still do get persisted, regardless of the crash, unlike Rubberduck.
Do you have your own toolbar positioning persistence code or registry entries? If so, it seems likely would be tear-down / crash-on-exit related.

shadowofsilicon

Even though function blocks are objects, you wouldn't care about the concept of an object unless you were trying to write your own. Which they don't, they just use what is provided to them.

Duga

[rubberduck-vba/Rubberduck] IvenBach edited wiki page Resource links for C# duckling contributors (AKA those new to C#)

Brandon Barney

@IvenBach One is more formal whereas You is more personal. Whichever is more in-line with your intended tone is fine. I is First, You is Second and One is Third person.

FreeMan

@BrandonBarney Spoke too early... there's a bunch of .Activate, .Select etc at the bottom.

Brandon Barney

Think of person-perspective as distance from the subject. I is closest to the subject whereas One or the pronouns of a collective is the furthest away from the subject whereas You is right in the middle. It is not the speaker, but it is the subject so it is close (but not as close as I or Me)

IvenBach

7:59 PM

@BrandonBarney Is one more of a british usage and you more american?

Brandon Barney

One is more of an academic usage really.

IvenBach

Considered more proper?

Grabbing some lunch.

FreeMan

SQL Query question: I have a list of fixed text options that are stored in a field and a free-form "other" text that is also stored there. (NOT MY FAULT!!! That's how the data comes to me.) I want to report on the fixed/known values, and select the rest as "Other". What's the best way to do that.

@IvenBach If one were to write that way, it would be a little more formal, however, I would probably not use that.

Brandon Barney

Yeah, proper and very impersonal.

Duga

[rubberduck-vba/Rubberduck] PowerAccess commented on issue #3215: VBE Toolbars Position & Visibility Aren't Persisted

> One possibly quick way to workaround the most annoying aspect of this issue (especially if related to harder to fix tear-down issues) would be to just have the toolbar added to the end (eg. right side) of the existing toolbar row(s), instead of adding it as its own row.

Actually, if you are somehow registering the toolbar as its own row, there is a chance changing that to only add to existing row might even fix the root issue for placement / merging into another row not being persisted, bu

FreeMan

8:02 PM

If you look at older newspaper stories from say the 70s and earlier, you will see references to "this reporter" where now you'll see "I". They mean the same thing, just more formal wording.

puzzlepiece87

@FreeMan Uh? How do you differentiate them when you're looking at them with your eyes?

(Since a column can only have one definition)

FreeMan

@puzzlepiece87 The column definition is nvarchar(300) the values are Known Option 1, Known Option 2, Other. Unfortunately, Other allows a free form text entry with that text stored in the same column.

The data is from a survey and that's how they provide it to us. They don't put "Other" in the Answer column then provide a separate Other Text column of data. If they did, this would be easy.

Duga

[rubberduck-vba/Rubberduck] PowerAccess commented on issue #3215: VBE Toolbars Position & Visibility Aren't Persisted

> I was wondering that as well, so I had tested with repositioning built-in and other add-in toolbars to see if crash-on-exit killed prevented them from being persisted, and those layout changes for non-Rubberduck toolbars still do get persisted, regardless of the crash, unlike Rubberduck.
Do you have your own toolbar positioning persistence code or registry entries? If so, it seems likely would be tear-down / crash-on-exit related, but I suppose even if not it could be related to that.

FreeMan

would that be a better question on Stack Overflow or on Database Administrators?

coolio! the [stack-name.SE] (or [ SO ]) auto-expand/make-link-thingie works in chat, too!

Gotta run - running an errand for the FIL.

puzzlepiece87

8:26 PM

@FreeMan Awesome, then I got you

@FreeMan

select case when ColumnName = 'Known Option 1' Then ColumnName when ColumnName = 'Known Option 2' Then ColumnName else 'Other' End as WhateverYouWantToCallIt

IvenBach

9:12 PM

click Don't store passwords in a DB, store the hash. #MindBlown

ThunderFrame

9:23 PM

@IvenBach now, be alarmed when a password reset email contains your actual password.

IvenBach

@ThunderFrame security.blogoverflow.com/2011/11/… just read it. I now understand the perils of that.

#TheMoreIKnow

Duga

9:38 PM

[rubberduck-vba/Rubberduck] alexpizarroj starred us

3

Hosch250

@ThunderFrame Be more alarmed if it contains the hash of your password.

IvenBach

Why's that?

ThunderFrame

@Hosch250 if it's salted, it shouldn't matter. Cleartext password means they're either storing it in plaintext or the hash can be easily unhashed.

Hosch250

Because it gives anyone who was listening a chance to crack it.

Not really an issue (of course).

The real issue is that they are savvy enough to do the one, but idiot enough to do the second. Which is often more dangerous than doing nothing.

I mean, I'd rather work with a 100% idiot than a 50% idiot who is more likely to think they know everything.

ThunderFrame

Hack me once, steal my salted+hashed passwords, have fun cracking each password individually, with thousands of years of computing power. Hack me with plaintext passwords, have instant access to every account.

Hosch250

9:55 PM

Oh, if they are dumb enough to share your salted/hashed passwords around, you bet they are doing other things dumb.

ThunderFrame

Crypto/security is typically logically simple, but incredibly hard to implement correctly/robustly. It doesn't help that most upper management doesn't think security is important, so won't fund robust security.

Hosch250

@ThunderFrame I have one response to that.

Hack them.

IvenBach

@ThunderFrame Duh Check: Cleartext is just plain password itself?

ThunderFrame

@Hosch250 how man stories have you seen about white-hat hackers pointing out security flaws, only to be victimized by the company? I find a problem with a website, I know not to say anything, just take my business elsewhere.

4

@IvenBach yep

IvenBach

cleartext == plaintext too?

ThunderFrame

10:05 PM

Yep

For example, I can break out of my c0rporate virtualisation software, run PowerShell at whim. But do I tell them? Nope. But they do wonder how I'm able to diagnose issues on the server...

2

Mar 21 at 2:07, by ThunderFrame

https://arstechnica.com/security/2017/03/firefox-gets-complaint-for-labeling-une‌ncrypted-login-page-insecure/

puzzlepiece87

@ThunderFrame This times 1M cannot star enough.

IvenBach

@ThunderFrame If I have questions with Powershell do you mind me asking you about them?

Duga

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #3215: VBE Toolbars Position & Visibility Aren't Persisted

> This might be because we add the toolbars as Temporary.

ThunderFrame

@IvenBach I'm one of those people where PowerShell works by Google-Copy-Pasta-MoveOn....

IvenBach

#SayItAintSo

You still have more experience than myself. I'm just now being exposed to it.

Duga

10:28 PM

[rubberduck-vba/Rubberduck] ThunderFrame commented on issue #3218: Refactor|Rename only partially deals with labels

> I don't think a non-existent label should cause a Parse Error (or resolver error) but it should generate an inspection. In any event, the module won't compile, but RD should be able to identify the missing label usages.

Duga

11:01 PM

[rubberduck-vba/Rubberduck] BZngr commented on issue #3218: Refactor|Rename only partially deals with labels

> I'm working on #3176 which revealed that rename\refactoring of enums work (or fail to work) much in the same way as the above issue with labels. I will have a fix for this issue along with the enums when I am done with #3176 (hopefully soon).

IvenBach

11:17 PM

The warm fuzzies were great while they lasted. Back into lost & uncharted territory again.

Hosch250

@ThunderFrame Dozens.

That's why I like black hats.

As a general rule, the company deserves what it gets from them.

And yes, I'm only partially serious here.

ThunderFrame

11:36 PM

@Hosch250 I guess you never know when a white-hat is also a black hat - arstechnica.com/tech-policy/2017/08/…

every time I hear the expression black-hat/white-hat, I have fond memories of Mad Magazine's Spy vs Spy