VBA Rubberducking

Duga

12:02 AM

RELOAD!

[rubberduck-vba/Rubberduck] 1 closed issue. 1 issue comment.

[Minesweeper] Games Played: 115, Bombs Used: 70, Moves Performed: 15296, New Users: 24

this

@MathieuGuindon FWIW: C# doesn't allow out as a identifier....

Mathieu Guindon

by conscious design decision; when they added a var keyword they had to interpret it in context. ditto with async and await, and adding out var didn't break out or var.

this

but does tB have the same luxury?

Mathieu Guindon

why not?

this

personally, I'd rather say "fix your silly VB6 code"

Mathieu Guindon

12:11 AM

also, this OP appears at times to read "backward compatibility" as "twinBASIC code should also work in VB6"

so...

this

Public Sub Derp(Out As Doh) is legal in VB.

Mathieu Guindon

yep, and has no reason not to be interpreted as ByRef Out as Doh

this

yeah or Out Out As Doh

Mathieu Guindon

or Out {expected: identifier} As Doh

this

2 mins ago, by this

personally, I'd rather say "fix your silly VB6 code"

Mathieu Guindon

12:13 AM

thing is, tweaking the parser rules around member signatures is the back-compat risk

not adding the keyword per se

if adding the keyword is done as intended, then an implicit ByRef parameter named Out should still parse correctly

@this nah I agree breaking implicit ByRef would be a problem

this

Yeah, I get it - you don't want to fix your 20 years monster codebase because of a new keyword

since if it can't migrate, it won't migrate -- no opportunity for tB.

But, I do expect it to get refactored. Surely you aren't migrating just for giggles, right?

Mathieu Guindon

sure but 100% back-compat does imply you can just paste your crappy legacy code and it "just works"

this

Sure. But surely you aren't going to leave it like that indefinitely?

I mean, if I'm visiting some procedure, I at least try to pay off the tech debt there.

"OMG YOU MUST NOT TOUCH THIS YOU NO KNOW WHAT CLD HAPP3NWTFBBQ!!!eleven!" is .... annoying.

Mathieu Guindon

for all I care VSC could just show every implicit keyword, written or not... makes no difference :)

this

and I honestly do believe the driving reason behind the "do not touch" mentality is the utter lack of refactorability in vb6.

Mathieu Guindon

12:23 AM

agree

this

I think Wayne has it right, thought - tB will have to drag vB kicking and screaming into 21st century.

2

Mathieu Guindon

we just need content. I'm writing about constructors and what they imply right now :)

this

:+1:

the VBE - it's right for me

@MathieuGuindon Oscar speech I'm really just so glad I figured out to use db first without having to ask here

Mathieu Guindon

:)

the VBE - it's right for me

12:38 AM

I think that pretty much settles it. However I will save that for the refactoring since from what I can tell the EF I currently have "works" well enough to continue developing the UI.

I imagine that smily as a (very) mild trollface btw

Anyways gl with the blog post!

Mathieu Guindon

12:54 AM

hey @user240781

Feeds

Mathieu Guindon has removed Hosch250 from the list of this room's owners.

Mathieu Guindon

you have write access now

user240781

I'm back due to popular demand!

3

It's Hosch again :D

Mathieu Guindon

> User was deleted on 2/12/2020 7:58:04 PM

user240781

What's up?

Mathieu Guindon

12:57 AM

good to see you man!

user240781

You too.

Mathieu Guindon

well kinda lol

user240781

And I hopefully won't need write privs for too long. I have a question up that's already got a vote.

Mathieu Guindon

mine lol

welcome back!!

Hosch250

I'm not going to make any promises, but I hope to sometime get one of those remote code server things up sometime.

It doesn't look too hard.

Mathieu Guindon

12:59 AM

have you seen / heard of / tried twinBASIC?

Hosch250

Unless Wayne already did with his new IDE thing.

I saw it this morning. Looks cool.

Mathieu Guindon

it's a bloody revolution in the making :)

Hosch250

I always did recommend writing our own IDE.

Mathieu Guindon

it's a VSCode plug-in though

this

@Hosch250 The problem is that we are not Wayne.

and welcome, btw!

Mathieu Guindon

1:01 AM

^ also that lol

this

(was VSC a thing 5 years ago?)

Mathieu Guindon

was probably just starting out... came out around .NET Core IIRC

Hosch250

> On April 14, 2016, Visual Studio Code graduated from the public preview stage and was released to the Web.

So, I have a new job; did I mention that shortly before I left?

Mathieu Guindon

was new in 2020 or you got a new-new one?

Hosch250

Nov 2019.

Anyway, we do a conference.

It was online last year because of COVID, and again this year (May 4th).

I gave a talk on accessibility last year, and I'm doing one on client-side Blazor this year.

sessions.mndevconf.com.

Mathieu Guindon

1:04 AM

nice!

Hosch250

Been working on building a chat system and sponsor hall for it (sponsor hall is "hidden" for now, but accessible at this url: sessions.mndevconf.com/conftuner/136980541487/expo-hall

You have to sign in to chat.

And I think chat is turned off for the conference (but not expo hall) ATM.

What have you been up to? Still an MVP?

Still running accounting/sales software for the fancy suit company?

Mathieu Guindon

yep and yep

Hosch250

Nice.

How's the COVID economy been treating you?

Mathieu Guindon

I'm lucky... currently on time-share working 4/5 days, others have it much worse

Hosch250

Yeah, I'm one of the really lucky ones that wasn't affected.

Mathieu Guindon

1:09 AM

I'm going to have to make phone calls soon-ish, been calling this boat "sinking" for like 3 years now

Hosch250

Jobs were tight when it started, but by the end of the year, my company was doing really well again.

Have you heard of OpenAPI (nee Swagger)?

Mathieu Guindon

not sure

might have seen the name before

this

they're on 3.0 now, no?

Hosch250

Yes.

petstore.swagger.io

this

(tbh I kind of dislike the current name -- "open api" is not that distinctive. )

Hosch250

1:11 AM

So, there's a similar system called AsyncApi for messaging systems.

They are hiring someone; all OSS, all remote.

I just saw that yesterday; if you are looking, might be something you are interested in.

I'd jump at it if I wasn't happy at my current job.

Playground: https://playground.asyncapi.io/?load=https://raw.githubusercontent.com/asyncapi/asyncapi/master/examples/2.0.0/simple.yml
Home page: https://www.asyncapi.com/

Mathieu Guindon

thanks! not actively looking right now though (maybe I should)

Hosch250

How's SE been? Mostly sane?

I see you and Vogel are both retiring your mod hats?

this

@MathieuGuindon sure your experience with shopify will be immensely useful, though. You already know what to not do, right?

Mathieu Guindon

@Hosch250 wah that's pretty slick!

@this lol!

Hosch250

@this Oh yes, I see references to Shopify everywhere.

Just read the blogpost on twinBasic. Is that using the duck's grammar behind the scenes?

Mathieu Guindon

1:18 AM

I don't think so

no idea actually

this

pretty sure he wrote his parser grounds up in c++

Hosch250

You could probably package different pieces of VB up as VS Code addons.

Like, just the refactorings or just the inspections.

Just say which file types you support.

this

on main page:

> Brand new custom parser (written in C++), built for flexibility and amazing performance

Hosch250

@this OK. That must have been a LOT of work.

this

I imagine so but since he was also writing his own compiler.... it's easier?

(compiler has to parse, right?)

Hosch250

1:21 AM

Makes sense.

I'll be back later. Playing a game of Civ 6 with a friend.

Mathieu Guindon

ha I bought that one for Switch, ..ugh, last year lol haven't finished my first game

this

later and good to see you (even if briefly!)

Hosch250

I've played about 10. I haven't won yet, although I've come close several times.

Maybe we can play together sometime.

@this You too.

IvenBach

1:55 AM

@Hosch250 well well well... Look what the duck dragged in.

Hosch250

Hey, Iven.

IvenBach

Glad to see you swimming around the pond again.

Feeds

2:26 AM

We've learned that weird spacing and diacritics in the methodology description are apparently the key to good research; luckily, we've developed an AI tool to help us figure out where to add them.

mansellan

1:36 PM

Had my first covid jab yesterday. I feel rotten :-(

this

@mansellan but you now can wear a half-mask!

mansellan

lol yeah

Still glad I got it, but damn it kicked my ass...

Hosch250

3:40 PM

I have chat privs now.

Hey, mansellan.

mansellan

@Hosch250! Welcome back. How are you?

Fatih Durmuş

hello

IvenBach

@mansellan I’m assuming hungry to work on RD. Considering how slow we’ve all been recently.

mansellan

3:55 PM

@FatihDurmuş Hi

IvenBach

@Hosch250 ^^ you ready to put us to shame with a barrage of new PRs? :)

@FatihDurmuş welcome to the pond.

Hosch250

4:25 PM

Good, how are you?

No, Iven. Want to finish a personal project first.

mansellan

Yep good thanks. Been lucky that my work hasn't been detroyed by COVID.

Hosch250

Just popped back to say hi.

Nice. Mine either.

Bought a house last October.

mansellan

Oh cool, congrats!

Hosch250

Need to paint the deck and seal the driveway, but otherwise in great shape.

mansellan

It's nice to have your own place

Hosch250

4:30 PM

Yep.

Been working on cleaning out the gardens a bit. They'd gone to seed since the owner got too old to care for them.

She died, and I bought the house from the estate.

mansellan

I need to do some work in the garden, but the weather hasn't really been good enough.

Hosch250

Nice thing is, she had that black cloth stuff down, so the weeds were growing in the leaf litter on that. They all came out when I pulled the cloth out.

mansellan

Ha nice - I really need to put some of that in. So much easier.

Hosch250

I might smooth the soil and put more down, but it looked really yucky since it was partially buried and all clumpy.

So it needed to come out anyway.

Bbl, going to vacuum now.

mansellan

k

Hosch250

4:35 PM

Nice talking to you again.

Hope you feel better soon.

mansellan

yep, been too long :-)

thanks

IvenBach

5:48 PM

@IvenBach The mockedProjectSettingsProvider wasn't used be ImportCommand. Needed to be injected.

Blogging Duck

7:44 PM

Rubberduck News: Constructors in twinBASIC

posted on April 17, 2021 by Rubberduck VBA

If you haven’t tried it already, download VSCode and get the twinBASIC extension, and be part of the next stage of the Visual Basic revolution. When it goes live (it’s still in preview, and vigorously maintained), twinBASIC will compile 100% VB6/VBA compatible code and completely redefine how VB6 and VBA solutions will be maintained and… Continue reading Constructors in twinBA…

BigBen

8:34 PM

> That is why constructors should adhere as much as possible to the KISS principle: Keep It Stupid Simple.

Isn't it Keep It Simple, Stupid?

Vogel612

that possibly used to be it, but the stupid simple idea is somewhat less insulting

IvenBach

@IvenBach :+1: We've now found out how properly invoke projectSettingsProvider.Verify(provider => provider.Save(projectSettings), Times.Once()). Now to figure out record the last assigned property value for dlg.FilterIndex and test for that.

^^ As Vogel said.

BigBen

> While popular usage has transcribed it for decades as "Keep it simple, stupid", Johnson transcribed it as "Keep it simple stupid" (no comma), and this reading is still used by many authors.
Thanks, Wikipedia.

IvenBach

8:48 PM

@IvenBach I don't think we need to test for that. The updated dialog filter index is persisted via the Save(...) method. Check the projectSettings argument instead.

The dialog is created anew each time.

Duga

10:09 PM

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #5731: Add more filters for CodeExplorer import command

IvenBach

Iven study link: github.com/Moq/moq4/wiki/Quickstart. Need to better understand how to set up mocking, verifying, and how callbacks are used...

Duga

10:23 PM

[rubberduck-vba/Rubberduck] build for commit 71f4cc9c on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] IvenBach synchronized pull request #5731: Add more filters for CodeExplorer import command

Duga

10:40 PM

[rubberduck-vba/Rubberduck] build for commit eaf0ef97 on unknown branch: AppVeyor build failed

BUILD FAILURE!

Transcript for