VBA Rubberducking

6:00 PM

@this define "working". I installed .4457 this morning, but haven't done anything beyond load Access and have it do an initial parse. In general, though, yes I keep up with most new releases.

this

Now, if I expand ALL children nodes

then it work as expected; showing me only the matches. But it also kept "empty" folders, too....

Comintern

OK, I'll need to double check whether that got wired back up.

this

ok i'll open an issue.

Comintern

Keeping folders with no results was by design. Should it exclude those too?

this

IMO, yes

that's what VS does, doesn't it?

Comintern

6:01 PM

Projects too?

I never search in VS.

this

oh nice, photogenic memory. Such lucky man you are.

Yes, I believe it will exclude projects with no matches, too.

Comintern

I almost always navigate with "Go to definition"

this

@FreeMan mainly to verify CE is working the way it shoould be

That's good when you're at the right place. I'm basically opening up a project and want to get to the code module quickly without navigating the folders

Hosch250

@this Photogenic memory?

Now I'm imagining memory that looks good when photographed...

Comintern

I think that means making up things to vividly remember.

Might be a sign of severe delusions.

this

6:06 PM

@Hosch250 Yes, a synonym of photographic memory, of course. Have you been hiding in a rock lately?

Hosch250

Why, yes.

How'd you guess?

this

:D

Comintern

> Photogenic means it looks good in pictures, or that it photographs well. Rita Hayworth was photogenic.

Photogenic memory isn't even on the first page of result for me, other than some stuff from Urban Dictionary.

this

psh psh, it'll be the new word to know soon.

IvenBach

@Comintern Paralleling how VBA enums are just a Long behind the curtain?

this

6:12 PM

Yeah

COM won't yell at you if you go Something.AFooFlag = BarFlag or Something.AFooFlag = 42

Comintern

^

this

which makes sense for the remoting, BTW.

IvenBach

That's good to know.

this

you don't know if the client (which might not be even be written in same language) can handle enums.

Comintern

I totally read BarFlag as BarfLag there.

this

6:13 PM

That works, too.

IvenBach

While I like the flexibility it offers refactoring enums in VBA has lead to undefined errors when it was'nt in the list.

Comintern

Should be renamed to Wretching?

IvenBach

@Comintern My bad influence at work.

@this Oi? So if the language doesn't support the idea of an enum it stays the generic Int32?

this

yes, that's how COM works.

remember it's a ABI

IvenBach

ABI = Application Binary Interface?

this

6:15 PM

yes

Mathieu Guindon

FWIW VBA only superficially supports enums. .NET enums are more type-safe.

IvenBach

:click: IE Language agnostic.

I pretty sure I learned that before already. It's good to re-learn what you already forgot.

Mathieu Guindon

    Public Enum Foo
        Foo1
    End Enum

    Public Enum Bar
        Bar1
    End Enum

    Public Function Stuff(ByVal value As Foo)
    'happy to receive a Bar too
    End Function

IvenBach

^ That's bit me a few times until I really learned the implications.

Mathieu Guindon

i.e. enums aren't a type per se

this

6:20 PM

out of curiosity - is there any ohter language besides .NET that treats enum like a type?

IvenBach

The thin veneer over them is easily seen.

Hosch250

Maybe Java.

I can't swear to it, but I'm pretty sure it does.

Mathieu Guindon

Java enums are weird. They're pretty much classes.

(cue @Vogel612 going "nope")

Hosch250

F# enums are weird too, in an awesome way.

Vogel612

@MathieuGuindon no, you're correct

Mathieu Guindon

6:24 PM

woot!

Vogel612

Java enums are basically classes with a private ctor

and a handful of named static fields that are instances of the class

so public enum Foo { BAR, BAZ } is basically the same as:

Hosch250

F# enums are basically traditional .NET enums, but you have to initialize them with a number and always qualify access. If you don't initialize them with a number, then they are discriminated unions instead of enums. And discriminated unions don't have to have qualified access.

fsharpforfunandprofit.com/posts/enum-types

Vogel612

public final class Foo extends Enum{
   public static final Foo BAR = new Foo(0, "BAR");
   public static final Foo BAZ = new Foo(1, "BAZ");

   private Foo(int ordinal, String name) {
      super(ordinal, name);
   }
}

Hosch250

But when you start using F# pattern matching, it's more awesome than using a switch.

this

so for the purpose of enum = types, the answer is basically yes for Java.

e.g. I can't go something.Foo = Bar.Baz

Mathieu Guindon

6:28 PM

makes me wonder if enums are a thing as far as the CLR is concerned

Vogel612

@this huh? Course you can

Hosch250

@MathieuGuindon Pretty sure.

this

but in C#, you must cast

e.g. something.Foo = (Foo)Bar.Baz

Vogel612

implicit casts, boxing and all the other stuff applies

hang on... what are your types?

this

(assuming Foo and Bar are two different enums)

I don't think C# allows for implicit casting of enums.

Hosch250

6:31 PM

@MathieuGuindon Interestingly enough, they all inherit System.Enum.

So, no, C# enums are just classes too.

Vogel612

@this because C# enums are a special kind of int, IIRC

Java enums are not

Hosch250

@Vogel612 Yes, each value is an int by default.

Vogel612

java enums are actually classes at the bytecode level

Hosch250

However, you can make it inherit the other number types too, like short.

@Vogel612 Same for C#. docs.microsoft.com/en-us/dotnet/api/…

Mathieu Guindon

@Hosch250 not quite. I mean, as much as Int32 inherits System.ValueType or something

Hosch250

6:33 PM

@MathieuGuindon If I do public enum Foo{}, the structure is Foo : Enum.

Mathieu Guindon

keyword "structure", as in struct, as in ValueType, as in "not a class" ;-)

Hosch250

And Enum is defined as a class, but it implements ValueType, which is basically a struct.

The class, struct, and enum keywords are just language constructs.

Mathieu Guindon

there's some CLR magic going on to make that work

correct

Hosch250

At the end of the day, it's classes all the way down.

A CLR "class" isn't the same as a language "class".

Mathieu Guindon

at that level, yeah. but not if you're in C#

@Hosch250 this

Hosch250

6:37 PM

Once you compile it, a "class" implements System.Object directly.

A "struct" implements System.ValueType, which implements System.Object.

Mathieu Guindon

*inherits

Hosch250

And an "enum" inherits System.Enum, which implements System.ValueType.

Mathieu Guindon

yup

Hosch250

> Although ValueType is the implicit base class for value types, you cannot create a class that inherits from ValueType directly. Instead, individual compilers provide a language keyword or construct (such as struct in C# and Structure…End Structure in Visual Basic) to support the creation of value types.

etc.

Mathieu Guindon

although, for some reason I reserve the term "implement" to interfaces & abstract classes/members ;-)

Vogel612

6:40 PM

~heavy sigh

Hosch250

I'm a communist pundit when it comes to language :P

You have to follow the rules, but I don't ;P

Vogel612

I've been resolving conflicts for two hours now, I can finally start merging the semantic changes

Hosch250

Nice. Anyone want to bet that Vogel's just about brain-dead after that?

Vogel612

I'm beginning to longingly consider getting the rest of the chocolate from the kitchen

Weapons-Grade-Facepalm

        // search for an equivalent endpoint
        return endpoints.stream().filter(wsdlEndpoint -> Objects.equals(endpoint.getCSARId(), wsdlEndpoint.getCSARId()))
                        .filter(wsdlEndpoint -> Objects.equals(endpoint.getTriggeringContainer(),
                                                               wsdlEndpoint.getTriggeringContainer()))
                        .filter(wsdlEndpoint -> Objects.equals(endpoint.getManagingContainer(),
                                                               wsdlEndpoint.getManagingContainer()))

how not to query a database for a specific thingy

2

correct solution: return em.find(WSDLEndpoint.class, endpoint) != null;

"HAY DATABASE GIMME ALL THE RESULTS, I'M JUST GONNA THROW AWAY ALL OF THEM"

it's kinda ironic that the code I'm merging into my branch now has introduced a parameter into a handful of methods that's called triggeringContainer

Mathieu Guindon

6:55 PM

Triggered much? ;-)

Vogel612

like constantly rn ...

the PR introduced an additional primary key field into a table that's split between two entities...

Mathieu Guindon

WTFs/min: 60

Vogel612

and just outright neglected to do the basic legwork of cleaning up the use of JPA

this

i guess they saw database as some kind of magical bag of holding.

Vogel612

and if I recall the conflicts correctly outright neglected to introduce the field into one of the two entities

Duga

7:03 PM

[rubberduck-vba/Rubberduck] CHR-IS-B created comment on issue #4725: Indenter does not indent preprocessor commands within procedures

> @comintern, yes, it was the indenter settings. I wanted compiler directives to be indented the same as everything else. This works when "Force compiler directives to column 1" is not checked and "Indent compiler directives" is checked.

Vogel612

guess how deletion works here...

this

drop the table and re-insert all rows but one?

Vogel612

nope.

select the rows to be deleted across both tables into two collections and iterate them one by one passing them to a method that issues a delete statement for an entity

this

well, points to them for not actually churning the database w/ deletions & insertions.

Vogel612

it's still apparently something nobody bothered to look at

Why did the SO query not have the question "Do you think your coworkers know what they are doing?"

2

because the answer to that would've been a HELL NO

Hosch250

7:09 PM

Here, it's "Some of them, sometimes."

Vogel612

query method returning a collection of entities logs every single result as a tab-delimited list at info level

before proceeding to invoke a method that returns a single result and throws an exception if there's no or multiple results.

actually nevermind...

it logs the whole fucking TABLE before running that query

Mathieu Guindon

wut

Hosch250

@Vogel612 At least you can fix it at your discretion.

Vogel612

I'm currently still working on an unmerged index...

just saying

Hosch250

I can't fix our site at my discretion; I've been told off for trying, and that I'm not to touch something if it's not broken.

Vogel612

7:14 PM

but yes, I'm ~~fixing~~ burning with fire at my discretion

Mathieu Guindon

> Hey we're getting negative feedback regarding performance becoming increasingly poor, inversely proportional to the size of the backend db, mind looking into that? IT'S A TRAP!!

Vogel612

@Hosch250 yea I had that at my old job

and honestly. I can understand where they are coming from, but that's not a healthy state for a codebase to be in and letting it rot even furhter does nothing to fix the state of the code

@MathieuGuindon do you think anyone is gettting performance metrics on this [expletive]?

Hosch250

And as a lowly dev, I can't architect my own solutions. Which again, I get why, but it's frustrating when the architects aren't necessarily that great either.

Vogel612

ya no, that's a load of BS

because if you as a dev can see something's very much easier by replacing with semantically equivalent code then doing so should be a no-brainer

Hosch250

Well, this is on the scale of choosing code patterns and adding new DLLs and stuff.

Like, the highest level architecture changes.

Vogel612

7:18 PM

hum. Well that's a bit more dangerous, yea...

Hosch250

So, we have massive DLLs covering dozens of responsibilities.

The typical monolith, you know.

I proposed splitting it into one DLL per group of related responsibilities. Say, our learning system (quiz + survey) would get it's own DLL, and our recognition system would, etc.

Even structuring it so the DLL's at the same level in the call stack would be together.

So, instead of BrandName.BL.DllName.* for one DLL, we'd have multiple DLL names with focused topics.

Vogel612

so: basic responsibility segregation and decoupling

Hosch250

And then instead of doing the mediator pattern with EVERYTHING, I proposed exposing an interface for the API and just having a few classes to implement/support that API.

So, we could do a LearningCrudOperations class with the CRUD methods.

Instead of two classes and a ****load of DI container overhead for each logic point.

Like, I can't even call a message/handler in a tight loop because the DI overhead is so big.

It's fine for a few calls, but not for 100.

@Vogel612 Yeah.

Hi, @FreezePhoenix. Did you get un-chat banned?

Vogel612

nope. their profile says they can't talk for another 149 days

FreeMan

7:38 PM

@this Based on some very quick testing: I only get 1 copy of each folder even after several parses. The code-pane -> CE sync works. Don't remember what other updates have been made that I might need to take a look at

this

the search was also supposed to be enhanced

the other main thing is performance

Comintern

@this I think that's a trivial fix - it must have just got missed when I was moving functionality out of the main VM to the node VMs.

FreeMan

search seems to work OK - Get shows GetTheFoo as well as all the class getters. One thing that would be an improvement (at least as an option) - automatically expand folders that contain the search result.

this

cool i forgot to post an issue and can't do it just yet.

@FreeMan actually that's exactly the issue I was telling Comintern about.

at one point it was auto-expanding but I guess it stopped?

FreeMan

I've not ever noticed any lagginess in the CE, so I don't think I'm in a position to state whether it's performant or not now. I'm noticing nothing to complain about at the moment. (Unless you're talking about the parse as a whole)

this

7:48 PM

parse is its whole another thing

hmm interesting got a notice about java changing its model

only skimmed a bit but it sounded like Oracle doesn't want developers to work on Java for free anymore.

Tweeting Duck

Hey, coders of all kinds: @StackOverflow is doing their annual developer survey, and we should make sure *every* dev is represented, especially if you’ve been underrepresented in the past. Only takes a minute to make sure you’re geard! https://stackoverflow.com/dev-survey/start?utm_source=so-friends&utm_medium=ad&utm_campaign=dev-survey-2019 #devsurvey2019

Tweeted by anildash on January 23, 2019 at 6:23 PM

I'm geard?

*heard, I guess

#humorFail

8:06 PM

@TweetingDuck Gone are the days when nobody cared if you were a lizard if you could code, I guess

FreeMan

@Hosch250 gone are the days when the only thing that mattered was that you were capable of doing the job. Now it's far more important to know what group(s) you can be put in. >:(

Hosch250

@FreeMan Same thing.

IvenBach

8:22 PM

@FreeMan We're supposed to be in groups?

Comintern

8:42 PM

I'm in the "drop what you're doing to rerun the query because <redacted> can't use a filter in Excel" group today.

IvenBach

Can't use a filter?

Comintern

IKR? Good thing it was already sorted too.

IvenBach

Are they somebody you report to?

Comintern

8:58 PM

No, although my direct report is shaky on the whole filtering and sorting thing too.

this

oh a chief executive officer? :p

Comintern

Actually, our CEO is pretty technical. Our sales and marketing...less so.

Hosch250

@Comintern Hey, give me a list of what you want me to cover, then have them hire me to come out for a 1 day training on Excel. I'll charge them premium rates so they think they got a good deal, and give you a kick of it.

this

That's relatively rare, a technical exec officer.

Comintern

LOL

Hosch250

9:02 PM

And go over my whole lesson with you before hand, so I don't embarrass you :P

this

Usually the bigger the corporates get, the less technical execs become.

Hosch250

Think a 50/50 split would be fair?

Comintern

If I had any shred of hope that any training would stick, I'd probably go for it.

Hosch250

LOL.

this

@Comintern that's what hockey cluestick is for.

Comintern

9:03 PM

I got asked again today how to calculate a ratio in Excel.

Like between 2 numbers.

this

I can see them going woah woah, too technical

Hosch250

> Zombie: How do you calculate a ratio in Excel?
> Comintern: Go back to HS.

2

Comintern

I also find myself saying "Your other back-slash" on a regular basis.

this

Pretty sure ratio was taught in middle school if not 5th grade.

Hosch250

@this I doubt it anymore.

this

9:06 PM

Well, I'm pretty sure I learnt that in my elementary school.

it was around the same time they were teaching the fractions. They still do teach fractions today, right?

Hosch250

Not sure.

Comintern

TIL that Chef is a framework and not just a programming language. Thanks, SO survey!

Why does the SO query put a huge textbox there for What is your age (in years)?, and then reject "You don't just calculate that from the 'age you first started programming' and 'how long have you been programming'?"

Seems like poor UX to me.

Hosch250

I guess they either want to see how many people put two incompatible numbers.

Or maybe they figure we fudge it a little.

For example I was nearly 18 when I started programming.

M.Doerner

Typical rounding issue.

Hosch250

But it might be past my birthday now, so I program for 6 years and 2 months, and suddenly the numbers don't match.

M.Doerner

9:19 PM

Still, for a survey, +-1 year really does not matter.

Comintern

^^ That should wash out with a large enough sample size.

Mathieu Guindon

@Comintern it's a test, to gauge how accurate your other answers might be ;-)

also, disappointed we don't get to guess the number of pennies or lego bricks or whatever, to get some SO swag

Comintern

Ahhhh... I thought it was testing whether I thought like a programmer.

Mathieu Guindon

@Comintern let me guess. and that person calculates gross margin percentages all day

Comintern

TBH, I'm not sure what this person does all day.

Mathieu Guindon

9:29 PM

taps keyboard randomly to make it sound like I'm working

Comintern

That's a valuable job skill, especially for those of us who automate away work.

It's one of the reasons I like a mechanical keyboard. It sounds like I'm working harder.

Mathieu Guindon

I don't have a mech kb, but ever since I got a replacement kb for my laptop (following some coffee accident) I'm making typos because half the keys work half the time, so I bang the keys quite much harder than I used to. I don't anticipate a very long lifetime for this new keyboard.

Hosch250

I'd say it's already broken.

Comintern

What really sold me on mechanical keyboards is that they don't fatigue my hands and wrists like the membrane ones. I can also type a lot faster on one.

Hosch250

Yeah, I like that too.

OTOH, it's not an old-style LOUD mechanical keyboard...

Unless I always misunderstood what people were talking about...

Comintern

9:36 PM

A lot of it has to do with the switches they use. There are also "after-market" sound dampening things you can put under your keycaps.

I wonder if anyone makes an SO keycap yet.

Quack Exchange

0

Q: Loop through rows and columns in range and apply formula

I am needing to apply a countifs formula on each cell in range that includes rows and columns. I am able to make it work if it is for a specific range or rows within one column but not sure about how to apply the same to multiple columns. My current code is below. Sub CountIfsFormula2() Dim l...

IvenBach

10:28 PM

@this I was never taught fractions, or at least remembered learning them. Got to Middle school with Numerator = 3 and Denominator = 4 and figured it out pretty fast.

this

hmm. i thought all kids had to do the pie thing

(or pizza)

IvenBach

I don't remember any of that if they did teach it to us.

this

That's how they usually introduced the idea of fractions. Ratios wasn't too long after

IvenBach

I was lucky that I could look at math and just know the answer.

Up till Geometry. That was the subject that knocked me down and curb stomped me.

this

you should check w/ your lawyer. You might have a case for massive educational negligence against your old elementary school. :D

oh that makes me curious - why? It was one of my favorite subject. Didn't even have to study.

Mathieu Guindon

10:32 PM

Boy this is going to be a "fun" drive home. 2 hours this morning, and it looks even worse now.

this

Sometimes they just work later and drive home without the rush

(or early but that's not usually an option as often)

Mathieu Guindon

snow tends to turn rush hour into rush hours

this

ouch

IvenBach

Past-Iven: What's wrong with this math? Why don't I understand you Geometry?
Geometry: It's cause you have to study to understand me. Get to studying kid!
Past-Iven: "Study"? What's that mean? I just know the answers.
Geometry: LAFF. Now drop and gimme 20. Think I'm harsh, wait till Calculus. He's gonna make me look like a chump.

this

I guess that also puts a damper on the working late idea - that only means you'll get your ass frozen skating on black ice.

@IvenBach LOL

Mathieu Guindon

10:34 PM

I;m asking not about SOAP. Main question how to interact with p12 certification — Pavel Zimogorov 1 min ago

Yeah because that was crystal-clear

1.2K rep, I'm kinda baffled.

Anyway, heading home at a speed measured in inches per hour.

this

I guess he assumed everyone is telepathic like him.

Drive safe!

IvenBach

Be safe mug. Avoid the frozen pineapples on the road.

Transcript for