VBA Rubberducking

IvenBach

6:00 PM

That'd be one soggy mushkin after it thawed.

this

@IvenBach in only a weeek?

FreeMan

better...

clicks links to reinforce positive behavior

Hosch250

Oct 29 '18 at 12:09, by FreeMan

not much pumpkin left there, well done

It was barely holding together anyway.

Oct 21 '17 at 22:33, by Mat's Mug

I threw away my awesome pumpkin today. It had collapsed into a puddle of rotten flesh.

this

FWIW: bing.com/…

looks similar to DDG

Also: reddit.com/r/duckduckgo/wiki/index#wiki_webmaster_tools

I kind of expect a pumpkin to hold for a week at least.

Hosch250

@this Not this one. It was mostly holes.

this

6:04 PM

lol, yeah I guess.

Hosch250

Hmmm.

I wonder what a spiderweb pumpkin would look like?

FreeMan

VBA factories parameterized yielded this:

at the top of page 2 :(

this

@FreeMan did you see the reddit thread I linked?

Hosch250

Oct 8 '17 at 0:54, by Mat's Mug

Oh, that's the one that fell apart.

The year was wrong on the first ones :)

Mathieu Guindon

the back of it was the nice part

yeah the small one was last year's

FreeMan

6:07 PM

@this this part

> We get our results from various sources but mostly Bing, Yahoo and Yandex, so the outdated content is likely listed by those search engines too. If you request them to remove the links, then they'll be removed from DuckDuckGo as well shortly afterwards.

this

you carved the back, too? Awesome. what was it?

Mathieu Guindon

brains

this

Yes, hence why I linked the Bing search results

it is very similar, so obviously RD news isn't that well received by Bing and possibly Yahoo

Hosch250

DDG uses Bing now, instead of Google?

this

which then hurts the DDG results

Hosch250

6:08 PM

Wow, when did they switch?

this

I took it to mean it uses the data indirectly?

Hosch250

It used to be a wrapper around Google.

this

oh, really?

hmm

FreeMan

ah. so they searched google on my behalf so all the results were tracked to them.

kinda like tor for google

bing probably tracks as much as google does

this

not finding a news article indicating that DDG switched

FreeMan

6:10 PM

are you using DDG? that could be the problem. How meta

Hosch250

> We get our results from various sources but mostly Bing, Yahoo and Yandex, so the outdated content is likely listed by those search engines too. If you request them to remove the links, then they'll be removed from DuckDuckGo as well shortly afterwards.

this

LOL

Hosch250

What Freeman said.

That looks like they primarily use Bing now.

FreeMan

was just about to post my original...

this

@Hosch250 no, I'm referring to your comment that they used to be a google wrapper

I'm not finding any evidence that it suggested that they used to use Google

Mathieu Guindon

6:11 PM

this

that's awsome!

Mathieu Guindon

and the lid had brains carved in, too

that pumpkin was crazy

FreeMan

I'm thinking that, while this compiles, it's not exactly kosher...

Hosch250

> In July 2016, DuckDuckGo officially announced the extension of its partnership with Yahoo! that brought new features to all users of the search engine, including date filtering of results and additional site links. It also partners with Bing, Yandex, and Wikipedia to produce results or make use of features offered. The company also confirmed that it does not share user information with partner companies, as has always been its policy.

FreeMan

'@Interface
Option Explicit

Public Property Get Password() As String
  Password = this.Password
End Property

#amIright?

this

6:13 PM

That may be part of the problem: > DuckDuckGo also filters pages with substantial advertising.[18]

Mathieu Guindon

@FreeMan rubberduckvba.com/Inspections/Details/…

this

@Hosch250 yeah, it doesn't really say thing switching away.

at best, I think it always used 3rd party APIs which may have at one point included Google as the source

but then stopped since 2016

at least that's how I'm reading the wiki. Assuming it's accurate.

Hosch250

Roughly what I'm reading too.

FreeMan

@MathieuGuindon I'm bumfoozled... the example in that link strike me as being inverted... the first, as I understand it, should NOT trigger, while the second should trigger.

Hosch250

I can't find it, but I swear I was under the impression they basically wrapped a Google search.

this

6:17 PM

ugh. I type too fast for my own good. lot of words missing.

Mathieu Guindon

@FreeMan oh dang, yes that's correct - it's a problem with the website assuming example ordering when it doesn't find the hasResult attribute

gotta fix that...

FreeMan

whew!

this

implicit anything is evil!

FreeMan

@MathieuGuindon unfortunately, that also appears to be how the actual inspection works. I'm getting no inspection results for that code I posted.

#IssueIncoming

IvenBach

@FreeMan :consoles-FreeMan: yes our great Mug is fallible. It shook me too when I first learned of it.

Mathieu Guindon

6:20 PM

pfffff

@FreeMan it's a fairly recent one, are you on the latest build?

FreeMan

nah, I was just trying to wrap my brain around how "A" = "B" when clearly it was NULL...

@MathieuGuindon .4930

I'm usually pretty current, you should know that by now... :)

Mathieu Guindon

launches Excel... is running .4924

FreeMan

@MathieuGuindon slacker...

Mathieu Guindon

hm, not getting a result either

weird

is your interface actually implemented?

FreeMan

4 mins ago, by FreeMan

#IssueIncoming

Mathieu Guindon

6:24 PM

maybe it's not looking at the @Interface annotation

FreeMan

@MathieuGuindon no, just getting started on converting a bit of test code to a class, then asked and got directed to interface/implementation.

will include that detail, in case it's important

Mathieu Guindon

but yeah, the annotation should be taken as a hint about the intent here

Duga

[rubberduck-vba/Rubberduck] daFreeMan opened issue #5143: False negative ImplementedInterfaceMember

> **Rubberduck version information**
```
Version 2.4.1.4930
OS: Microsoft Windows NT 10.0.15063.0, x64
Host Product: Microsoft Office 2016 x64
Host Version: 16.0.4873.1000
Host Executable: MSACCESS.EXE
```

**Description**
In converting the beginnings of a regular class to an Interface, I added the `'@Interface` annotation and compiled. I still have actual code instead of just method headers, and I do _not_ get the error.

**To Reproduce**
Steps to reproduce the behavior:
1. Crea

[rubberduck-vba/Rubberduck] daFreeMan added label bug to issue #5143: False negative ImplementedInterfaceMember

[rubberduck-vba/Rubberduck] daFreeMan edited issue #5143: False negative ImplementedInterfaceMember

FreeMan

@Duga ha! chat recognizes the back-tick to format code here, even though GH doesn't recognize it in issue titles.

Feeds

Trust me, you don't want to get on the wrong side of the paramilitary enforcement arm of the International Earth Rotation and Reference Systems Service.

Mathieu Guindon

6:58 PM

why do people want SSRS reports that are nothing but a glorified SQL View running on a schedule so that they can take it into Excel and then spend 2 hours manipulating the data to answer their questions?

or is it something that's happening only here?

WHY DON'T YOU ASK ME FOR THE ACTUAL REPORT YOU NEED FFS

this

they don't know about data connections?

Mathieu Guindon

@this they want it in their inbox, VPN is too complicated

I'm growing sick of stupid SSRS reports that do nothing but list 20 pages of records

like, no summaries, nothing - just the plain naked records

this

i guess PBI is not an option....

(thought one typically doesn't use PBI just for records. It can be, though)

mansellan

@MathieuGuindon IIUC, it's to help with upkeep of APIs over time. Once you ship an interface, any change to it is breaking - you can't add, remove, or change the signature of any member without it being a breaking change. Given how many APIs are interface-based rather than class-based, they wanted to ease at least some of that. A new member would not be breaking as long as it has a default implementation.

Mathieu Guindon

the point is that if they get my SSRS report and then spend half the day in Excel butchering it and filtering and summarizing and whatnot -- then they could fucking ask for the SSRS report that does all that and spend their day analyzing the data rather than playing in Excel.. defeats the whole purpose of having a damn report server

@mansellan :lightbulb:

mansellan

7:04 PM

doh, just saw that @Hosch250 said the same thing. still catching up on chat.

Mathieu Guindon

I do SSRS every month of the year - and yet I haven't deployed an actual report in years, because all they ask for is glorified views running on a schedule

#KillsMe

time for a walk, I guess

this

ya know, you could just email them an Excel spreadsheet w/ data connection....

hey, ma, it's in the inbox!

Quack Exchange

-1

Q: ADODB Wrapper Class

I use ADO (specifically for accessing SQL) daily at work. So, I finally decided that I was going to create a class that makes it simple for myself and other programmers on the job to use. Just the other day, I saw @MathieuGuindon's post about creating parameters on the fly, and I really liked hi...

Mathieu Guindon

@QuackExchange huh what's the problem with that post?

FreeMan

@MathieuGuindon that was a short walk...

Mathieu Guindon

7:16 PM

Still walking

gets caffeine, starts walking back

this

7:35 PM

huh today I got upvoted for a obscure answer for a obscure question from last year by 2 people.

Mathieu Guindon

blame DDG obscure search results :)

this

LOL

Hosch250

Maybe someone edited the question or an answer or something.

So it got bumped to the home page.

this

hmm must be it.

FreeMan

@MathieuGuindon ha!

FreeMan

7:56 PM

If I want to make a generic Function CallRestAPI() that can handle any number of RequestHeaders, having byVal RequestHeaderList as Collection would probably be a good way to go, right? Then I can iterate the Collection doing WinHttp.WinHttpRequest.SetRequestHeader (key), (value)

Mathieu Guindon

do you not need to access the keys?

if so, a Collection won't do

FreeMan

Or, since this is part of a class, I can have a RequestHeaders as Collection property and set it before calling.

Mathieu Guindon

that depends if your object is intended to live for a single request

if the object should outlive a request, then the dependency belongs at the method level

i.e. a RequestHeaders property makes sense on some WebServiceRequest class

FreeMan

I'm thinking a single request will be the extent of it. At the moment, I'm only making 2 requests to a single API and, as I understand it, there's no connection/relationship/state at their end between them, so I have to provide everything new. Is that what you mean?

Mathieu Guindon

what did you name the class?

FreeMan

8:05 PM

RESTDriver

prolly not the best...

hrm... my server at home just notified me that the power is out and that it's exceeded its set run time so it's shutting itself down.

Handy feature. Wonder why the heck the power went out...

Mathieu Guindon

are you in Alabama?

FreeMan

Not last I looked!!

Indiana

Partly sunny, 91°, 20% chance of rain. Shouldn't be weather related. Somebody probably hit a power pole. :/

Mathieu Guindon

#REF!: Trump doctored a weather map with a sharpie to enclose AL in the path of last week's hurricane

Hosch250

LOL.

FreeMan

oh.

Hosch250

8:11 PM

The later news was funny, too.

NOAA said that his alteration was a possibility.

this

@MathieuGuindon ..... wtf.

Hosch250

Just low enough they didn't mention it for the evacuations.

@this Didn't you see that :D

this

there's a reason I don't read news....

#IgnoranceIsBliss

Mathieu Guindon

^

Hosch250

Basically, NOAA had it running along FL, and he extended the path into AL.

I don't read the news typically either, but I saw that somehow.

Mathieu Guindon

8:14 PM

and then some boot-licker skated around to make it look like nothing blatantly illegal and dangerous happened

Hosch250

I think it was on the sidebar of an old tech article I was reading.

FreeMan

@MathieuGuindon Guess I need a Dictionary, but, in general, I'm on the right track, right?

Mathieu Guindon

@FreeMan yep

Hosch250

@MathieuGuindon How is that illegal or dangerous?

Nobody paid attention :D

Mathieu Guindon

lookup the very reason NOAA exists

Hosch250

8:14 PM

And last I heard, there were no laws against predicting the weather (unlike in England...)

FreeMan

@MathieuGuindon thx

Mathieu Guindon

@Hosch250 there apparently are, against doctoring an official NOAA forecast

(for good reasons)

Hosch250

He wasn't representing it as an official forecast, though.

Basically, that's an anti-forgery law.

And everyone knows NOAA doesn't make their forecasts with a sharpie :D

FreeMan

Private Type api
  URL As String
  apiFunction As String
  UserID As String
  Password As String
  RequestHeaders As Scripting.Dictionary
End Type
Private this As api
Public Property Get RequestHeader(ByVal key As String) As String
End Property
Public Property Let RequestHeader(ByVal key As String, ByVal Value As String)
End Property

Other than changing the String to Variant to make it suitably generic, does that seem reasonable? I can get/set a single element in the dictionary (the Let Implementation would do RequestHeaders.Add key, Value

Mathieu Guindon

dictionary keys are always strings, IIRC

FreeMan

8:19 PM

ah, prolly true.

Mathieu Guindon

LGTM

FreeMan

I suppose for a REST API, the value would be passed as a string even if it's a numeric. and I would not be passing any sort of object to the API...

Mathieu Guindon

(assuming the Initialize handler goes Set this.RequestHeaders = New Scripting.Dictionary)

FreeMan

any reason to get/set the entire dictionary? Can't think of one right off the top of my head

@MathieuGuindon ah yes, thanks!

that would have been awkward!

Mathieu Guindon

@Hosch250 I know. Just pointing out that the decorum of the Oval Office and POTUS isn't what it used to be, and it's very sad that 40% of the country has absolutely no problem with that. Eventually the rest of the world will stop giggling and snap with "ok that's enough".

Hosch250

8:23 PM

Are you threatening to invade? :DD

I don't like it, but it is funny :D

FreeMan

@MathieuGuindon it's been going downhill at least since the late 80s. That downhill trend has accelerated over the last 15 years or so.

Hosch250

I mean, what else are you going to do? Besides vote someone else in?

Might as well laugh when the clowns are in the room...

FreeMan

FaceTwitStagramChat will be the death of ~~civilized conversation~~ civility.

Private Property Let IRestDriver_apiFunction(ByVal RHS As String) why does the VBE default the parameter to RHS?

Mathieu Guindon

because it's the right-hand side of the assignment

FreeMan

Why doesn't RD come with that as a white-listed variable name by default?

;)

only sorta half serious

Mathieu Guindon

8:27 PM

because value is a much better name for it :)

this

fwiw, I'd love to knock VBIDE's head and make it stop giving me RHS....

Mathieu Guindon

so much so

I TOLD YOU WHAT THE PARAMETER WAS NAMED, WHY CAN'T YOU JUST USE THAT

FreeMan

@MathieuGuindon Remember, most of this country can't pronounce "decorum" to say anything about knowing the meaning. When you have people with rainbow-bright hair, more piercings than the nail-gun tester board at Lowes, and wearing some of the clothes that I see people wear... decorum has totally gone out the window. People just don't care anymore.

/soapbox

this

#ProTip don't go shopping in your pajamas and crocs.

Wait, why do I have to tell you that?

#ProTip If you need #ProTip, you're #Screwed

:-D

Hosch250

@this Last I heard you're screwed if you have kids.

this

8:36 PM

@MathieuGuindon IKR? I get that I can rename the parameter to whatever, but c'mon....

Mathieu Guindon

probably has something to do with the ITypeInfo for the internal interface not even bothering to store parameter names

(?)

this

@Hosch250 what's having kids has to do with it? Having kids in itself isn't the problem. Not teaching them decorum is, and so is not having not.

No can't be. It's there.

Otherwise, you couldn't foo:=bar

Hosch250

Nothing with that.

Mathieu Guindon

:facepalm:

Hosch250

Just that you're screwed if you have kids in general.

Mathieu Guindon

8:38 PM

IDK then, this RHS renaming thing is beyond me

this

hmmm. "you were screwed" and "you are screwed" is different.

Mathieu Guindon

@Hosch250 can confirm

@this also "I screwed up"

FreeMan

@Hosch250 probably a good thing your parents didn't think that before they had you...

Hosch250

Good for me, anyway...

Not for them.

FreeMan

@MathieuGuindon what does the direction have to do with it? ;)

Mathieu Guindon

8:42 PM

this morning was particularly #fun, let's just say

this

FWIW, we have nails and screws. We're just missing the bolts and rivets.

Hosch250

> My guess is that training to drive The Beast is more about "what to do if someone is shooting at you with several SAMs"
> Stay out of the air I guess, given that SAMs tend to go in that direction.

LOL.

> Cheekiness aside - SAM just stands for "surface-to-air missile", so those are the least of the concerns; if you're targeted by SAMs in The Beast, you have much, much larger issues to deal with first (GRAVITY).

Mathieu Guindon

9:00 PM

Unfortunately, there is no access back end. This is built by someone who left the company 5+ years ago and is so deeply integrated in the daily workings of half the company that it's scary. They do fetch some data from the Oracle database we have that runs the main web application, others from a csv that gets put on the file server, some from other access files that is run manually weekly (also automated but can't run), but this is for the behind the scenes workings of managing the data we get before importing it into the Oracle database, and generating some statistics. It's a clusterfuck... — Björn Brorsson 1 min ago

yup, the name matches the description.

this

9:16 PM

@MathieuGuindon fwiw SSEE doesn't come with SQL Agent

or rather it comes with it disabled.

Mathieu Guindon

oh darn, that's right.

still better off PowerShelling than trying to run Access as a headless ETL

this

^

Mathieu Guindon

9:33 PM

@ticker wtf did I just read

oh great, Shopify's REST API is completely changing how requests are paginated, just out on a fkn whim.

apparently not breaking every single one of your clients isn't a rule in the wonderful world of REST

> Action Required

this

if it's any consolation, Amazon basically gave us the finger.

Mathieu Guindon

@this huh, how?

this

3 months ago, Amazon told every sellers in US marketplace that shoes must be sold in US shoe size system. On the surface that seems reasonable.

but for my client that's a bicycle shop and sells cycling gears, including cycling shoes which are specialized shoes that's horrid.

Mathieu Guindon

having dealt with shoes inventory before, I can imagine

this

Apparently cycling enthusiasts are used to have their shoes in EU sizing

so we're looking at converting from EU sizes to US sizes and going WTF because the conversion is not straightforward

e.g. 2 EU could be 1 US shoe size, etc.

Nooowwww, the policy went in effect last month. Guess what? Amazon didn't follow through. Cycling shoes are still sold in EU sizes.

Mathieu Guindon

9:45 PM

lol

this

sooo, our effort to convert everything....

Mathieu Guindon

I would think popping up a size conversion chart client-side would be the best solution.. I honestly can't think of a single good reason to proclaim "all shoes shall be US-sized"

this

yeah, and shoe manufacturers don't even agree, either.

e.g. one vendor says their EU 45 is same as US 11, other vendor says their EU 45 is US 12.

Mathieu Guindon

^

this

so we had to set up a complicated schema of mapping all the vendors' charts just to comply with Amazon's new policy

so when they went "oops, just kidding, guys!"....

Mind you, we made multiple calls and talked with several support people about the discongruency between their policy and the cycling shoe market and they kept on going "no exemptions, no exceptions. IT'S US SHOE SIZES ALL THE WAY, BABY!".....

#NotBitterAtAll

Mathieu Guindon

10:03 PM

gosh, it's so much TTQW

mansellan

@Hosch250 wait wut? we have people who like to predict the weather using seaweed...

Mathieu Guindon

source/context

#Sharpiegate

anyway, TTGH

mansellan

10:18 PM

yeah, but it is the best sharpie. i'm telling you, it's like the best sharpie ever. never wrong folks, never wrong. i trust the sharpie, he's a good guy.

That sharpie is gonna help us build the wall and #MAGA

this

MAGA?

Megaman attacks Gutsman again?

Military Action Guaranteed Anonymously?

Millions Ants Gnaws Attractively?

mansellan

Megalomaniacs Are Gaining Acceptance.

this

#TIL

Too good Hitler didn't live to see it.

mansellan

Time your country ditched the electoral college system. #JustSaying...

this

I don't think it'll make a difference.

mansellan

10:32 PM

Oh? Hilary won the popular vote though?

this

See, that's the problem.

mansellan

If its any consolation, UK politics is fucked atm too...

this

It all amounts down to choosing between Coke and Pepsi.

when US really needs is some unsweetened tea.

or even water.

mansellan

Heh, I think south park did it best... Giant Douche vs Turd Sandwich...

this

Pretty much. The correct choice should have been just simply "No."

this

10:57 PM

@this I was going to post an issue on Sam's repo about adding the code-gen attirbute but this apparently was already done. So I'm wondering if this comment means we can just add common code to this and all context get it?

@MathieuGuindon ^

Mathieu Guindon

11:11 PM

@this oh wow, it totally looks like it!

this

yeah, I have to admit I'm kind of confused now - if none of the base*** are code-gen'd, then what is?

probably because of that option, I guess

and that, too

Mathieu Guindon

what would we put in there though?

could be a good place to move all IParseTree extension methods

this

that's what I was wondering, actually

it would be before we create all those contexts with Sam's tools, I presume

for CPA, if we used the delegation approach, that can be done there

but we don't know which interface the context will have so...

Mathieu Guindon

If I made that base class implement e.g. INode, I think it could make ext.methods like Descendants work with that interface hierarchy - e.g. tree.Descendants<IExecutableNode>()

that would be a Big Win(tm)

this

now that I've seen the .g4 files' options, yeah, looks like a possibility

Mathieu Guindon

11:24 PM

I don't think it helps much beyond that though

4 mins ago, by this

but we don't know which interface the context will have so...

^

this

yeah

we need it after the fact, not before.

wouldn't hurt to see if ANTLR has that as an option...

Mathieu Guindon

I'm happy with every node inheriting a CPA interface though

this

yeah, just piqued my curiosity.

a glance suggests, that no, it can't be augmented after the fact (no surprise)

Mathieu Guindon

11:38 PM

Unrelated, but this looks interesting

mansellan

fwiw, setting a very lightweight (or even empty) interface, to which extensions are then attached, is a huge part of what net core ia doing. seems to be very effective.

Mathieu Guindon

could be used to constraint e.g. BYTELITERAL to 0-255

@mansellan so that's basically INode (currently a marker interface)

mansellan

sounds like. not following in depth though.

Mathieu Guindon

hm, looks like we could use rule element options to make 32767 parse as an integer and 32768 as a long

and then literal type hints screw it all up, thanks VBA

nah I misread, it does constraint the match, but then issues some message.. not what we want

mansellan

I may be way off the mark here, but it sounds similar to red/green... you have the underlying INodes (green) and then an ICodePath : IEnumerable<INode> abstraction layered on top (red)...

not identical, the INodes are not a tree, but similar...

this

11:50 PM

not sure green/red analogy helps us here....

the way I read it, green/red deals more with parsing itself and we can't use that since we are using ANTLR

mansellan

heh. i was way off the mark :)

was just an instinct, set my spidey senses tingling.

in terms of layering of abstractions was all

i'll shut up now, not versed enough.

this

you have the right idea, I think