RELOAD!

[MDoerner/AdventOfCode2020] 2 commits. 399 additions. 1 deletion.

[rubberduck-vba/Rubberduck] 2 issue comments.

[Minesweeper] Games Played: 92, Bombs Used: 69, Moves Performed: 13305, New Users: 13

@this ooooh that is bad then

@Vogel612 I wish a wasn't a "web developer" but alas it is the best option for intranet service for some reason :/

I honestly don't understand how it wouldn't be very easy for MS to set up a framework to do using Winforms or WPF rather than a web browser as the frontend

especially if it is on a network hosted by windows server

@SonGokussj4 idk if technically breaking site rules but I upvoted for the good cause

if I am I will actually read it and spend 10 seconds confirming it is good first :)

[rubberduck-vba/Rubberduck] kangli-bionic starred us

If it's not good, don't upvote it! :-D But anyway, thanks.

[rubberduck-vba/Rubberduck] Talorthain created comment on issue #5769: Show Modules of Locked Projects in Code Explorer

@SonGokussj4 I have seen enough of your comments here to assume it :)

quick question for whoever:

if I have a set of pages represented by PageViewModel and I have a mediator class BookReaderViewModel that is responsible for telling the view which PageViewModel will be used for rendering does the PageViewModel need to know that it is the one being actively displayed or not?

@theVBE-it'srightforme what is the benefit for the PageViewModel to know about it's display status?

that's the pertinent question. Usually the ViewModel would just "serve the View".

Sometimes to reduce load you'd want the ViewModel to cache some data and regularly refresh that. Doing that while the View is not displayed makes no sense

but that's basically an edge-case

and if you do nonsense like that, the answer is obvious.

Hello

howdy, @Pochmurnik!

I have two sheets, Sheet "Start" containing CheckBoxes, enabling checkbox makes onther sheet visible, disabling make it hidden

screen flicker

I have suspicions it's because revealed sheet becomes active for a moment

Can I somehow remove this flickering?

avoid making the sheet active?

pastebin.com/tbnfgT7z

I want avoid flickering, no matter how (to be honest I don't know if this sheet activation is the reason of blinking)

After setting Visible to True this sheet is visible for a moment (some columns and other elements blink), then again I see "Start" sheet

set .visible = false, do your work, then .visible = true

visible of what? of "Start" or "Other" sheet? "Start" is something like menu, it should not disappear, "Start" contains a lot of checkboxes mapped with other sheets (sheets representing months)

mrexcel.com/board/threads/…

"It looks to me like excel does a screen refresh when a page becomes visible. Any sheet, not just the ones with shapes (a chart is also a shape). Even on an empty worksheet you can see the selected cell flicker briefly. It's just that it is more a lot more noticeable on sheets that have shapes on them because it looks like all shapes get repainted. I'm not sure there is much that can be done about that."

you might be able to avoid it by setting Application.ScreenUpdating to False for that change and then back to True, but that sounds like a bandaid for a problem that shouldn't even be there in the first place ....

I tried that at the beginning

Doesn't work

I think I can live with that flickering, but what a life it is...

@Pochmurnik I was intending Application.Visible, though that may freak people out as Excel disappears from the screen entirely, then reappears. Application.ScreenUpdating would be a more likely candidate...

[rubberduck-vba/Rubberduck] Talorthain created comment on issue #5769: Show Modules of Locked Projects in Code Explorer

@Duga hmm is that a GH or a Duga feature, scrubbing out the email addresses?

While that's kinda of improvement still would be nice to stop quoting the rest of the email messages. Can't have it turn into a NNTP of ye olde days.

it looks like GH did it

and yeah

printing email addresses was a bright idea.

only took them what? a year or two to realize it?

#BetterLateThanNever

:)

yo, got enough email addresses for our viagra sponsors? Yep, we can start scrubbing it and claim plausible deniability

If (a = b) Then:
    frmSupprimer.Caption = "Supprimer un matériel"
    'frmSupprimer.UserForm_Initialize ("Matériel")
    frmSupprimer.Show
End

would it be "too specific" to inspect for that?

basically locate : immediately following a Then, and flagging the colon as a no-op conditional expression (making the intended conditional block be unconditional)

2nd time this week I see an End statement that intends to close a block on SO

HOLY MOLLY not sure what's going on but my current VBA project (a small macro) is parsing at the speed of light, it's unreal - parser performance is getting seriously impressive.

@FreeMan I saw this solution, but I think in my case it will look awkward, thank you for sugestion

I think I will leave it for some time

@MathieuGuindon why would it be too specific? I think it's abhorrent.

arguably that specific case should be already covered by the "empty If block" inspection

although, it's not block syntax, but the block syntax is clearly intended

but what hint level is that?

If it's not an error, then it should be.

warning

because an empty If block is maybe funny but a colon'd If block is downright misleading.

yeah

so the inspection for colon'd block would be an error

agreed

also the "invert condition" quickfix wouldn't be applicable here

^

maybe that's better served with code path analysis flagging a no-op statement as conditional

(and thus indirectly marking the rest as unconditional, hinting the user about something being off)

IDK

I mean there's the specific case of having a : token immediately following a Then token, but perhaps there's a more general thing we could be looking at that would pick it up while flagging other problematic things

hmm. yeah. a : on the end of hte line is suspicious

Yeah, nobody wants a blocked colon.

shows self to the door. Logs out for the day

lol

question: why is it a colon and not a colons?

@FreeMan is impressed by FreeMan's ability to log out his computer at a distance after having shown himself out of the door

We don't want to flag this:

ErrHandler:

but we do want to flag this:

ErrHandler::

by same token: Debug.Print "derp":: Debug.Print "doh"

thinking the general rule would be a colon at the end of a line containing code elements or has nothing in between itself and the next colon.

If an inspection flags colon-terminated empty instructions then :: should be flagged regardless of where it's at on a line of code

but yeah that's the more generalized inspection I was looking for!

and I think in all the cases those should be an error severity level.

in case like ErrHandler:: it's probably harmless but it's downright dangerous with Then:

I don't think we have that problem with say, Do: or Loop:.... right?

i guess because If...Then is the only thing that can be either a single line or a block.

@Duga Matt? This has been bugging me a long time. :-) How do you do those statistics. Is there some kind of "sending data from my PC to the internet" thing in your Battleships VBA code? :)

@SonGokussj4 that would be configured with the @Duga chatbot API.. Simon sent me a key for that at one point, but I didn't end up doing anything with it. There's no such code in Battleship (or Rubberduck, or anything I ever wrote), but it would be pretty innocuous, it's just a key/value counter; starting a new Battleship game could conceivably send a request to the API and then we would have "X new games started" or something. Perhaps even break it down by AI type for funsies.

@this because it's one punctuation symbol. The dot is not called a colon, otherwise "." would be a colon, ":" would be colons, and ";" would be comma-colon :-)

@this brain-tickle, feature-request: an inspection for double-operators. Flag "++" and "--". Somewhat related

AFAICS, there are exactly zero useful situations for doing that in VBc

@MathieuGuindon Hmm, I would have hoped that the new statement would be terninated by the line break, so essentially no-op. Guessing that's not how VBx rolls...

@mansellan #FunFact: it's actually a "dot-comma" in French

See, that's logical!

not claiming French has any logic to it lol. we say "ninety nine" as essentially... "four twenty ten nine"

@MathieuGuindon point-virgule, man my French is rusty.

quatra-vingt neuf (not googled, from school, almost certainly wrong!)

quatre-vingt dix neuf

and there's a whole bunch of rules about whether and where you put the dash and nobody ever remembers them

wasn't that far off counts it as a win

:)

only ten off

off-by-10 error :-)

In German, a colon is simply a Doppelpunkt, i.e. a double-dot.

again, logical :-)

Still, a semicolon is a Semikolon, which makes no sense if there is no Kolon.

Although I prefer Daftpunkt

@SonGokussj4 say you've made a Pong game, and for every new game you POST to some URL with a payload that says "starting a new Pong game", and every time a player beats the computer you POST to that URL with a payload that says "Pong computer took a beating". At the end of the day @Duga aggregates the payloads and posts "x new Pong games started" and "Pong computer took a beating n times"

basically the URL you POST to is a @Duga API endpoint

That I do understand.

that's ...all there is to it :)

I guess semi-colon has some logic to it. A comma is like half a full stop, so a comma with a dot over it is like half as strong as a dot with a dot over it.

But you said there is nothing in the excel VBA project (battleship game) I've downloaded

there isn't? the stats posted are for Simon's Minesweeper game

Okay. I'm thinking I'm an idiot....

don't worry :)

Simon's Minesweeper game != Your battleship game...

^

facepalm

hey, like I said, no worries!

Heh, not really hung out on VBF before tB landed. They seem to have some fierce wars on there..

Looks like they've also had plenty of people say "I'll rewrite VB, gimme 6 months". No wonder they're disillusioned...

@SonGokussj4 you’re in good company as you’re surrounded by them.

@mansellan yet the anatomical colon has only one hole while the grammatical colon has 2 dots. Something to be said about anal retentive grammarians, I suppose.

@mansellan they should get in touch with guy who wants to write a OS using VBA. HHICB?

@this gimme teh codez!!!

@MathieuGuindon thus, you can trade in a cent for 90 new cents

Tempted to write a tB issue asking what the MVP is for v1. IMO, that's not anything GUI-related. It's fixing all the outstanding syntax issues. After the MVP (maybe 1.1?), bring on 64-bit, that's something VB6 couldn't do.

FMM, GUI can happen in v2...

hm not just syntax issues

why MVP?

everything that crashes the compiler, all the restarts, ...

yeah... stability needed for sure.

wait, we aren't talking about model-view-presenter, are we?

minimum viable product

nooo... minimum viable product

the minimum viable product one yeah

^too fast

the minimum thing that adds value

lol was confused since you mentioned "not anything GUI-related"

if it's a pleasant dev experience, it doesn't matter what the limitations are I think

I'd argue 64-bit has to be there, though. If you can't use it for Office Add-ins, you lose lot of potential customers, IMO.

and that

To me, that's being able to code any/all legacy code (except UI) in VSC, and know that it will work the same.

but it's fine if that's just the paid license version (x64 I mean)

@this but that's how it is right now. Minimum implies "current, but improved"

Not saying that 64-bit shouldn't be next ;-)

stability issues fixed is viable

^

everything else can come after

not sure I follow, though. VBA7 is 64-bit capable right now.

IDK I thought I saw Wayne say x64 would be the commercial one

if all you were shooting for is a parity with VB6, then sure. just the stability.

Yeah but tB doesn't really have integration story for VBA just yet. I'm sure it will, but now it's about VB6.

yes that's my understanding but that's still a MVP --- can't charge money for unfinished product?

that's where I disagree

I guess the question is more "at what point do you call it v1.0"

twitter.com/WaynePhillipsEA/status/1389607860338896896

Oh wait, not suggesting money can be asked before x64. Just v1.

@this wah nice!

x64 is a unique selling point, that's where the $$$ start appearing

Exactly. Thus why I think 64-bit is the MVP

actually both the MVP and the USP

Because I think office add-ins is much bigger niche to fill in, far bigger than re-compiliing VB6 apps.

If tB were to disappear tomorrow, not getting to x64, but feature-complete for non-UI x86, that would still have value.

So that adds value. Perhaps not the dream, but value.

not as an Office add-ins, no. As a standalone EXEs, I suppose, yes.

M is "minimal" - the smallest unit that adds some value.

But to my thinking is that if it's just a standalone EXEs why not python? why not rust? why not C#? why not C?

Office add-ins? Now that's value.

Because maybe people don't know those langs.

@Vogel612 Basically because I don't know how to apply the styling for a selected page without the ViewModel telling the View it is selected.

Maybe not but I doubt that's determinative in which lang gets used for an EXE project.

Why not C# - because huge runtime ;-)

LOL, ofc.

@theVBE-it'srightforme why is that the specific view model that tells your view what is selected and not the "mediator" as you called it?

My point is that those already has existing framework and everything else you need to get your problem solved.

@Vogel612 it is not

the mediator does tell viee

with tB you get COM ecosystem.... and that's it. As an EXE project, that's not nearly as valuable as an Office add-in (which must work in COM world)

but I want to apply styling to the tab corresponding with the currently selected page and couldnt figure out how without the page VM

Agreed. But look at it this way - I'm a VB6 developer who wants to write a non-UI lib for VB6/VBA-32 devs to use. I could use the VB6 UI, or C++, but neither of those would feel like home. So tB, soon, might be. That's value.

maybe it is just an issue with not knowing razor/html well enough

But I think we agree - a big arena for tB will be COM addins, and for that, x64 is essential.

which sounds like a very narrow scope, especially if you factor in the fact that more and more people are moving to 64-bit Office and thus require 64-bit VBa.

^

it didn't seem like the page VM "should" know whether it was selected or not

So... 64-bit is part of the MVP

to me, an Access guy, yeah

I think for Wayne too - he was very keen to get COM demos up.

I can see why a VB6 dev might disagree and that's cool. But I'd push back that if 32-bit is all they care about, then they would be more comfortable in VB6 than in tB with no UI support (yet)

yeah, that's fair.

Hmm, in fact, I'd argue that if they want to bring forward their VB6, they probably will have to be able to do it in 64-bit and therefore, be able to compile that app in 64-bit

I wouldn't just take my existing VB6 app and just recompile in tB and stop there. I'd probably want to add features or whatever.

I think many VB6 apps are quite comfortable in 32-bit space. The real driver for 64-bit is Office.

if you are not going to update your VB6 app then why bother moving to tB?

Personally, I'm hoping that tB breathes new life into VBc apps, lets them evolve again. It would be awesome to see them on GitHub, rather than some 90's style forum...

To my mind, the whole reason of going to the trouble of moving to tB is so that you can get new features for your VB6 app.

I hope so

BASIC was always a great intro language. Python seems to have replaced it, but not convinced it's better in all respects...

I think Wayne has it right, though - dragging BASIC screaming and kicking into 21st century. :-)

Just curious. What you don't like about python?

@this I only used it briefly, but it seems to be a bit... dynamic?

I don't doubt that it's beautiful in its implementation, but as a c# chap I was a bit, meh...

well, it's a scripting language so dynamic is kind of the thing.

^

I'm sure it's fine for scripting. C# is getting closer to the metal every release though.

And BASIC seems to offer something in between - access to low-level if you want, guide rails if you don't.

Yeah, I think it did very very well in getting non-programmers programming.

Pretty sure tB can offer close-to-C performance once it's optimised. It's just compiling to native after all...

VB6 did offer that, right?

or was there a caveat?

Well, kinda. It had to do (expensive) callbacks into its runitme lib. tB doesn't.

But yeah, it compiled to x86.

Interesting.

@Vogel612 yup sat down to look at it again and figured out in ~2 minutes I was being a dummy with the html. ty for confirming my sense of code smell

Interesting - apparently they are something similar for VB.NET