« first day (1554 days earlier)      last day (1626 days later) » 
00:00 - 17:0017:00 - 00:00

5:05 PM
oh wow... just spotted: Hacktoberfest Guidance
 
2 hours ago, by Vogel612
but first: coffee
 
yea, stuff came up... walking the dog, visiting my grandparents on the way, then being told that the windows updates I applies kinda broke two laptops, ...
#fun :)
 
@Vogel612 hey I want that
that's F'n bloody awesome
 
And it's possibly not even that much work
you could ask in the Charcoal HQ how they did it
 
Should there be a warning message about overwriting current files for exporting a project?
 
5:08 PM
there isn't??
 
Just noticed when I did an export then only needed to update a single module.
 
there isn't, and I don't think there should be - it's meant to facilitate SC integration; you want to overwrite the existing files every time
 
@MathieuGuindon I recently learned that they use 19 different ingredients for the fries,..
In Germany they use only 6
 
@Vogel612 in US?
I bet there's corn syrup
 
@MathieuGuindon ain't nobody dumb enough to take that bet...
 
5:11 PM
and depending on who you go through, you get meat grease in them too
 
@MathieuGuindon nope. but corn oil
 
@Vogel612 I bet that 15 of those ingredients or more are merely preservatives or otherwise have no (or negative) contribution to the taste/nutrition.
 
@Vogel612 question with CLI for git.
 
> I am reminded of a sign I saw in a pottery factory I once toured in England. It said that the 1100 degree Celcius kiln was "eleven times hotter than a kettle boiling at 100 degrees Celcius." I, being a smartass, asked the tour guide whether it was also "negative eleven hundred times hotter than an ice cube at -1 degrees Celcius." I got in reply a very strange look.
 
Sorry for the ping Vogel. I did git rm Filename -f when I wanted git rm Filename --cached for a simple unstage. I RTFM and figured solved it myself.
 
5:22 PM
@IvenBach I now pronounce you at least an early-intermediate software dev.
 
@Comintern I am not at all familiar with pre compiler directives
 
At a minimum. You might be higher. Not been here too much lately.
 
@Hosch250 :giggle: Shucks. Don't go inflating my ego with none of that.
 
Every time i have ever tried to use it, its failed out on me. (its been a while though)
 
I'll prove my ignorance before long.
 
5:24 PM
@Hosch250 whats the scale look like? Pleb, noob, novice, apprentice, journeyman, intermediate, <higher ranks for when i think harder>?
 
No, I go by standard job listings. Beginner, intermediate, senior.
 
ah ok
 
Beginner: needs lots of hand holding.
Intermediate: Can look things up by themselves, but need help with trickier topics.
 
I acknowledge I'm slowly leaving noobsville behind.
 
Advanced: Basically knows things from architecture to bytecode.
I'd say I'm near the boundary of intermediate/advanced, but still in intermediate territory.
 
5:26 PM
im not going to pretend im any good at this, im prob low to mid beginner
 
Of course, that's me. The other people here might not think that.
 
It's a hockey stick.
advanced concept (even some intermediate concepts) won't make much sense until you understand enough about other concepts, even at a rudimentary levels.
Which is why I told you to start w/ Joel's law of leaky abstraction
 
Obviously.
 
@Hosch250 aside from the stupid question, that's also bollocks...
 
With the way programming is nowadays, it's very very hard to be a full out expert; you have to know more and more about more and more.
 
5:29 PM
@Vogel612 LOL, the idea was they were conflating basic division and relationships between values.
 
it's only about 3.3 times hotter than a boiling water kettle, what with 372°K being the temperature of the kettle
 
He was discussing trying to produce relevant sense out of values that couldn't be sensically related.
 
@KySoto Just keep at it. Push through and you'll keep gaining knowledge.
 
^
 
@IvenBach i should rename myself Jon Snow
because i know nothing (lul)
 
5:32 PM
@Vogel612 Temperature difference between ~70F and 100F is 5% yet pineapples complain lots about it.
> The larger the island of knowledge the greater the shoreline of mystery.
5
 
@KySoto I know someone who actually did that a while back ...
as in ... three years back ...
 
Apr 3 '15 at 2:33, by Mat's Mug
> You know nothing, John Snow Mug
Mar 11 '17 at 2:26, by Mat's Mug
the more you know stuff, the more you know that you know nothing
 
:hang-head: I need to work on atomic commits. Fix one piece at a time, even though several changes may be in the same file.
 
@MathieuGuindon and that doesnt apply to just the thing you learn about
 
git add -p ftw
 
5:34 PM
#TIL in Win10 Alt-Tab and hold down Alt, then you can click on the thumbnail of the app/window you're after instead of Alt-tab-tab-tab-tab... to get there
 
you learn stuff that makes you realize how little you know... it only takes a few connections to realize you know jack squat about anything
@FreeMan i think that works in 7 too
 
@Vogel612 I'm still trying to grok what the -p flag does.
 
Did/Do you use an external tool for interacting with git?
Because those tools tend to expose a part of the functionality from git add -p front and center.
I'm used to hearing it called "hunks" of change, though the shortname of the flag implies it should be called "patches"
 
> Of course, here's the trick: While myself and the usability engineer were fussing around with the usability study, the dev got bored and just implemented model #1 above. And it worked beautifully with all sorts of keyboards/characters. And of course, the secondary assumed sort is by the field with the date in it, such as the “Received“ date in the default view.
 
I'm using cmd.exe for the edits I'm doing on my Excel modules.
The only other time I use it is with VS and working on RD.
 
Forcing myself to work with it via CLI without anything else has helped me better grok everything involving git.
 
@Comintern @KySoto I use this all time to write two-headed procedures.
 
the gist of the p-flag is that it runs every contiguous changeset by you seperately and you decide whether to include it or not. It even allows you to edit stuff "on-the-fly"
 
#If LateBind Then
Public Function ExcelApp() As Object

Const xlSomeExcelConstant As Long = 1
#Else
Public Function ExcelApp() As Excel.Application
#End If

   'Some code....

End Sub
Like Zaphod, though, only one head is active at a time.
 
5:58 PM
What constitutes a change set? Is it an individual file chang or a commit?
Speaking of HFCS there’s 3 boxes of donuts in the break area.
 
@IvenBach Whatever you like.
I've thought of making a tool that will make a commit every time I press a key.
 
Guess I’ve outgrown my childhood love of sugar. Donuts don’t appeal at all.
 
Then squashing when I'm done.
 
6:10 PM
0
Q: Excel VBA printing formatted text

SKS read a number from an excel cell say 12345678945 convert the value to a string of length no more than 8 characters i.e 12.3E+09 Print the value such that the last character is positioned at 23 column of the text file row as shown below , where the last character 9 is in 23rd column. 0000000001...

i wish to downvote and ask this guy what the heck he actually wants
 
@KySoto VTC as unclear while you're at it.
 
my rep is.... 5 right now?
i cant do jack
oh wait, i was wrong, i have ONE rep
 
Meh, somebody else will do it eventually. That tag doesn't get much traffic over on SuperUser.
 
i had to link my account over to make the post
 
You didn't get an association bonus?
 
6:19 PM
IIRC I got 100 rep when I created for CR from SO.
 
WTH? SU is jacked up. It doesn't recognize my session - thinks I'm not logged in.
 
@IvenBach needs 200 rep on any single site.
it's called "association bonus"
 
dang
first answer on there is a negative
 
I'm honestly not suprised, considering how terribad the question was
 
protip: don't answer off-topic, unclear questions
 
6:28 PM
yeah
that and not reading it the 6th time where you realize he WANTS the exact opposite of what i thought he did. Answer Deleted.
 
@Piccinin - Inexperience <> stupidity. ;-) — Comintern 13 secs ago
 
I'll bite... is there a question in here somewhere? I'm really not sure what it is that you're after? Are you looking for someone to write some code for you? Is this a code golf to do it in the least possible code? Is it just a puzzle to figure out what the question is? — FreeMan 47 secs ago
I don't have enough rep at SU to VTC...
@Comintern sometimes...
back on topic... I just noticed that the CE uses Unix style sorting - upper case letters all come before lower case ones. Not a problem per se, but it took a few moments to realize what was going on.
 
@FreeMan I think there's an issue for that
 
6:45 PM
OK, I'm cool with it switching to Windows case insensitive sorting.
interesting tidbit... I've noticed that my zombie Access process seems to be much smaller now than it was before. <100MB for the 2 today - often >500MB previously.
I'm on release .3751
 
    private TestResult RunTestMethod(ITypeLibWrapper typeLib, TestMethod test)
    {
        var assertResults = new List<AssertCompletedEventArgs>();
        if (!VBEInteraction.AttemptRunTestMethod(_typeLibApi, typeLib, test, (s, e) => assertResults.Add(e), out var duration))
        {
            // FIXME i18n
            return new TestResult(TestOutcome.Inconclusive, "Test raised an error.", duration);
        }
        return EvaluateResults(assertResults, duration);
    }
now that's how you abstract stuff away...
 
+1. Nice one with the VBEInteraction
 
@FreeMan #September
 
And it even always removes the OnAssertCompleted handler
 
7:00 PM
ha, was the AssertHandler leaking?!
 
@Vogel612 is that where the .NET runtime error was coming from?
 
@MathieuGuindon I'm not perfectly sure it was, but the rewrite I had was leaking on COM exceptions
that was after making TestMethod not know about the VBE though
        internal static bool AttemptRunTestMethod(IVBETypeLibsAPI tlApi, ITypeLibWrapper typeLib, TestMethod test, EventHandler<AssertCompletedEventArgs> assertCompletionHandler, out long duration)
        {
            AssertHandler.OnAssertCompleted += assertCompletionHandler;
            var stopwatch = new Stopwatch();
            try
            {
                var testDeclaration = test.Declaration;

                stopwatch.Start();
                tlApi.ExecuteCode(typeLib, testDeclaration.ComponentName, testDeclaration.QualifiedName.MemberName);
 
Hmm. Just a question - why are we using ITypeLibWrapper rather than say, IVBEProject ?
 
to avoid creating a new wrapper for every execution of the method
 
I mention that because the ExecuteCode would only work on a VBE Project, not on any ol' type library
so it's a bit misleading to say that it will work with a type library
 
7:03 PM
Is there a way to completely unload an unmanaged dll from an AppDomain and then reload it?
 
I didn't mess with that API that much, I think
@Comintern you mean aside from unloading the AppDomain?
 
This thing is leaking memory like it struck and iceberg...
 
uh.... that didn't make sense as I realized now that the wrapper works iwth a VBE project anyway.
 
i wonder... do they call them iPhones because they are a phone interface?
 
You might want to poke 202_accepted about that, IIRC he wrote something that does a similar thing
 
7:04 PM
@Vogel612 Yeah. The managed dll is a POS, so I'm basically trying to "reset" it so the OS can reclaim the memory it leaked.
 
is that for RD, @Comintern ?
 
No, it's for work.
 
Can you do with old skool LoadLibrary + FreeLibrary API calls?
 
Hmmm... that may be a possibility. I do have access to its process handle.
 
@MathieuGuindon I'll bite... What????
 
7:07 PM
Ever heard of the Eternal September?
 
can't say that rings a bell...
 
Folks posting their code assignments/instructions on various forums, hoping to get their work done by others. I could never understand that. Although I made a few bucks off that mentality back in college =)
 
ahh usenet references I actually understand...
 
7:10 PM
@Hosch250 Ah. Out of college by then, but not yet really online other than email...
 
@MathieuGuindon I have to say that who paid you for it is doubly dumb. Pay tuition then pay you more money? Might as well just not take college.
 
841
Q: Open letter to students with homework problems

user40980It is September once again (today is the 8755th day of September), and once again students are asking their homework problems on Stack Overflow and SoftwareEngineering.SE. We start seeing questions like: A car dealer has 10 salespersons. Each salesperson keeps track of the number of cars sol...

 
@this IKR? Although I'm still waiting for my paycheck from SO.
 
@this 💯
 
\o
Anyone know of a good xpath tester for save and share please?
 
7:21 PM
@Comintern that answer is beginning to have quite the decent score =)
 
but was hoping for something a little better
 
Kind of like an sqlfiddle for xpath?
 
yah
exactly
I don't like the one I found purely cos you have to scroll through a green haze in a box until you find your retrieved element/node text.
Not that intuitive for sharing with new users.
 
@MathieuGuindon As it should. I've been promoting it.
@QHarr You could write one in c# or java pretty easily, so I'd be surprised that there isn't a good one out there...
 
@Comintern :sighs: ...... I guess I should keep looking. I barely scraped one C# answer out of my brain for this site so I don't think I am up to writing anything clever. And java I haven't looked at since last year...... Why am I so lazy!
I bet there is a good one... just gotta keep sifting...
 
7:30 PM
This one looks decent: codebeautify.org/Xpath-Tester
 
@Comintern Aghhhhhhhhhhhhhhh..... you are joking? That is the one I used to beautify and didn't even notice the save and share.
 
LOL
 
Thank you @comintern. Deity.....Break time me thinks.
 
7:46 PM
Mat's a gem, for sure — Marcucciboy2 30 mins ago
aawwww
 
^^ man-crush!!!
:D
 
Can you normalize the data first? — Comintern 14 secs ago
^Excel <> Database...
 
what do you mean by that @Comintern — James 1 min ago
 
@MathieuGuindon evidently he hasn't recited the pledge of allegiance to Codd.
2
 
7:59 PM
^^ the "Use Index/Match" answer is exactly what I was thinking. I'm glad to know I'm in good company
@this Codd?
 
@FreeMan The guy who invented normalized databases.
 
stupid Google search results!
ah...
 
The Codd in Boyce/Codd normal form.
 
I probably suck at explaining normalization to people who don't know databases.
Normalizing means basically storing the data in a way in which you would not have multiple "data points" in a single field. If Life Insurance;Banks;Non-life Insurance;Nonlife Insurance is a single data point, normalizing it would be splitting it into 3 distinct pieces of data. That may be what you're trying to do, but it does make it a lot easier to evaluate relationships. — Comintern 45 secs ago
 
Edgar Frank "Ted" Codd (19 August 1923 – 18 April 2003) was an English computer scientist who, while working for IBM, invented the relational model for database management, the theoretical basis for relational databases and relational database management systems. He made other valuable contributions to computer science, but the relational model, a very influential general theory of data management, remains his most mentioned, analyzed and celebrated achievement. == Biography == Edgar Frank Codd was born in Fortuneswell, on the Isle of Portland in Dorset, England. After attending Poole Gra...
 
8:01 PM
@OP: note that NonLife Insurance won't match Non-Life Insurance. Data needs cleansing first. I also suspect LifeInsurance will match NonLifeInsurance. — Mathieu Guindon 1 min ago
 
Apparently I can't count either. That's 4 records, not 3.
 
8:15 PM
@QHarr - if you find it helpful, an upvote is always appreciated... wink
 
8:32 PM
@FreeMan Defo.
I have left a comment under that I think you need a select tag in order to employ AsSelect method. The function though is indeed useful so thank you.
 
8:59 PM
ohhhh dang... our primary C++ engineer is heading out
and im speculating that i may have to step up and help out on some of the projects
since im probably either the most knowledgeable or second most in the company
 
Time for you to join the "real" software developer world?
 
hah
 
i.e. Not BASIC-based world :P
 
well i took two c++ classes and tutored those classes for like a year year and a half
and one of the super important c++ apps is running on windows 98 se
 
WT*.
I'd be heading out too.
 
9:01 PM
lol
we need to edit the application to move the datasource to sql server
currently its using access as a backend
otherwise as far as i know, we dont need to mess with it
theres a lot more more modern applications he worked on than that
actually i think that one is the only one that is that old
 
[rubberduck-vba/Rubberduck] build for commit 69be12d6 on unknown branch: AppVeyor was unable to build non-mergeable pull request
BUILD FAILURE!
 
alright alright, whine about it being non-mergeable
 
9:38 PM
Long shot but has anyone used myglue.com?
IT software documentation stuff.
 
10:03 PM
grumble... test results are not displayed properly ...
 
[rubberduck-vba/Rubberduck] build for commit 013df3ef on unknown branch: AppVeyor was unable to build non-mergeable pull request
BUILD FAILURE!
 
ya I know it's not mergeable
I want to fix it before making it mergeable tho ...
 
oh well ... bedtime :)
 
@MathieuGuindon Working my way through rubberduckvba.wordpress.com/2017/10/25/userform1-show for the N<sup>th</sup> time with my recent comprehension. It's making sense.
 
10:27 PM
Would the use of Me.Hide still be applicable even though it's a global scoped variable?
 
@IvenBach Me global scope? Re-read "understanding 'Me'" ;-)
 
And here I thought I had learned and understood that post...
 
 
1 hour later…
11:33 PM
@MathieuGuindon You have IView_ShowDialog = Not cancelled yet the private variable was refactored into the private variable this. Should be this.IsCancelled if I've understood.
 
00:00 - 17:0017:00 - 00:00

« first day (1554 days earlier)      last day (1626 days later) »