« first day (1571 days earlier)      last day (1609 days later) » 

12:00 AM
RELOAD!
[rubberduck-vba/Rubberduck] 5 issue comments.
[Zomis/FactorioMods] 1 commit. 1 closed issue. 2 issue comments. 25 additions. 17 deletions.
 
@MathieuGuindon Hey
 
> The actual problem here is that the CodeString constructor taking an explicit selection removes the pseudo caret character at the selection and that the new position is computed as one to the right nonetheless. This means that we try to set the the position to the right of the code. This causes an exception we do not handle for some reason.
> @MDoerner linked commit moves that logic to TestCodeString - leaving that concern completely out of the "production" code path.
 
@Susi you do any VBA? or C#?
 
12:25 AM
guess not
 
@MathieuGuindon Actually i'm new here and i was just checking the rooms
 
:)
no problem! this one is where the Rubberduck devs hang out - we build an open-source plug-in that enhances the glorious VBE, which Microsoft abandoned since 1998
and there's plenty to work on, at every skill level
 
1:03 AM
> 3330 tests
uh, AppVeyor?
> Trial period expires in 3 days. Select plan to keep running your builds. After trial period is over only projects with public repositories will run.
If you have any questions or need to extend your trial feel free to contact us.
wait a sec, we're a public repository
#nosweat
 
 
2 hours later…
2:47 AM
Possibly because Bot-Rubberduck started using appveyor so they gave this new user a trial.
 
 
5 hours later…
7:43 AM
Hi, Are lLbound and cElements
both structs please? In [this](https://bytecomb.com/vba-internals-whats-in-a-variable/) is states the following:
consider the following snippet:

Dim myArray() As Long
ReDim myArray(1 to 2, -3 to 3)
myArray(1,-1) = 5
1
2
3
Dim myArray() As Long
ReDim myArray(1 to 2, -3 to 3)
myArray(1,-1) = 5

To the VBA programmer, no methods have been invoked. But behind the scenes the VB runtime has been busy. The ReDim statement invokes all of the following:
Call SafeArrayAllocDescriptor : Create the SAFEARRAY header structure
Set the lLbound and cElements properties on of each the two SAFEARRAYBOUND structures in the new SAFEARRAY’s rgsabound array.
I am trying to work out what the "Set the lLbound and cElements properties on of each the two SAFEARRAYBOUND structures in the new SAFEARRAY’s rgsabound array" refers to when stating "two SAFEARRAYBOUND structures"
I assume it means lLbound and cElements are SAFEARRAYBOUND structs?
*Please ignore the random 1 2 3 line numbers pasted there. Apologies.
 
7:57 AM
Side note: Does RD require .Net 4.6 and above?
 
8:23 AM
Yes, RD requires. Net 4.6 or above.
And, no, the article is not entirely correct in its statement. There is one SAFEARRAYBOUNDS struct, which is an array over tuples. In memory, the LBound and cElements alternate. Were these two struct containing the elements for all dimensions, you would see all lbounds and then all cElements or the other way around.
The meaning you understood is the right one. It is just that the sentence in the article is not completely correct technically.
Ok, I read it again. No, your understanding is not correct.
There are two instances of the struct SAFEARRAYBOUND, which is the tuple (cElements, lbound).
The example has two instances because the array has two dimensions.
 
 
4 hours later…
1:08 PM
Is there an efficient way to find out whether a component has an open code pane?
 
@M.Doerner why not do it blindly? I thought we were already doing that
I recall that accessing the CodeModule or something had that funny side effect of opening a code pane.
 
1:35 PM
Morning all.
Any idea why I'm getting this when I load my SSIS project in VS?
Message text is:
> Error loading Package.dtsx: The connection "" is not found. This error is thrown by Connections collection when the specific connection element is not found. C:\Users\<me>\source\repos\Integration Services Project1\Integration Services Project1\Package.dtsx 1
Everything works just fine when I run the package. i.e. it will load data as expected
I've looked at all my defined connections and they all seem to have names, so the "" is a bit confusing to me.
I haven't deleted any connections from the package (that I'm aware of), so it shouldn't be a left over from something
 
2:07 PM
SSIS package has a funny habit of ..... misplacing elements. To get rid of that, you need to open up the dtsx as a XML file and find elements that aren't in used (e.g. its' GUID isn't used anywhere else) and delete the element.
 
hmm... Maybe I should make a backup of said file before I attempt to mutilate it.
 
what, that wasn't implied?
 
the backup part or the mutilation part?
 
you have much to learn, young pawadan....
:p
 
indeed I do!
 
2:35 PM
morning
 
3:04 PM
I just lost my boss :(
 
uh i hope you mean in a non fatal way
 
She got promoted.
And IT got split up a bit (I'll refrain from ranting about that temporarily), and a few coworkers got promoted.
The best ones were picked for the promotion, but still :(
 
That can be a good thing. Someone even higher up who recognizes your talents and abilities.
 
Yes.
But the #2 guy and part owner apparently likes me too, so...
The #1 guy is mostly retired now.
So, my boss is the #3 guy in the control line now (was since June when her boss got fired).
 
None of those things ever hurt!
 
3:25 PM
> 0xC020844F -1071610801 DTS_E_ADODESTERRORUPDATEROW An error has occurred while sending this row to destination data source.
Is that the error I'd get if I tried to insert a duplicate key when using SSIS?
The only reference to "duplicate key" I can find on MS' Integration Services Error and Message Reference refers to duplicate keys in the cache
 
3:37 PM
@MathieuGuindon Duck check: Is it best practice to explicitly show both overrides. Would it be taboo for != to simply negate ==? That way both are always guaranteed to be opposites.
 
that's the idea, yes
 
@Hosch250 Claw you way to the top.
Reading about Tuple's for my comprehension. From a layman's viewpoint can it be thought of as just a key-value pair?
 
@FreeMan i just had to deal with a duplicate key error myself
 
except "element1" isn't necessarily a "key" and "element2" isn't necessarily a "value"
it's literally just "thing1" and "thing2"
 
3:52 PM
someone "fixed" the data and didnt change the timestamp
 
@KySoto if it's a SQL Server backend, why not use rowversion?
 
because i cant change the schema
and by timestamp i mean the datetime
 
that's what I assumed. But really? they can't even add one lousy column?
 
the other reason is access doesnt have rowversion
 
Access might not, but it can use them the same.
 
3:55 PM
i had to compramise to get the data on sql server
i have to dual update the data
 
it's just a binary(8) to Access.
so copy the RV value to Access and use SQL Server as the authoritative version of the truth
 
well we also have to send the data off to an engineer in the netherlands via access
but it has to join up with some temperature data that is collected
so when it gets imported in, access chokes if people have a duplicate time entry (since the data entry is one at a time)
(and it doesnt have an index on the view)
well the index part doesnt reallly matter, but the duplicate time really makes it mad
 
 
1 hour later…
5:25 PM
The Immediate window from VBA may have irreparably harmed my thinking. So used to using it while code is running or working.
VS gave me: The expression cannot be evaluated while in run mode. when I tried to do the same and gave me a big case of the sads.
 
5:39 PM
Working on Test Explorer Header widths not uniform #3831 has introduced a binding I can't figure out. github.com/rubberduck-vba/Rubberduck/blob/next/Rubberduck.Core/… is an example of it.
How does the binding work without specifying anything?
<DataGridTemplateColumn Header="{Resx ResxName=Rubberduck.Resources.RubberduckUI, Key=CodeInspectionResults_Type}" SortDirection="{Binding}">
With SortDirection="{Binding}" how or what does it know what to bind to?
 
6:37 PM
4
Q: WPF Binding Syntax Question

gn22I've seen this syntax show up, and have tried to google for it's definition to no avail; what does it mean when a dp is bound this way? <Grid> <ContentControl Content="{Binding}"/> </Grid> I was under the assumption that you have to bind to some property on the DataContext, or another elem...

 
Thanks for the link.
 
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4383?src=pr&el=h1) Report
> Merging [#4383](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4383?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/49d5bfb9e9d3e92e4a80acdb2af68123827bbf02?src=pr&el=desc) will **decrease** coverage by `0.91%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #4383 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 6db7a70f on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
6:54 PM
@Duga #wishlist Duga will post a FAIL gif every time instead of yelling build failure. At least it'll be more humorous.
 
[rubberduck-vba/Rubberduck] build for commit 6db7a70f on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
lesse whether it's the same "unexpected failure"
"2.0.* is not a valid version string" ... yadda yadda
@IvenBach maybe a better idea is that of a non-homogenous array
 
Meaning they don't all have to be of an identical type?
 
@this maybe just a sad-trombone?
 
@IvenBach yes
 
7:06 PM
Does a Tuple have to be dimensioned/sized before it can be used?
 
in a way
you cannot redimension it after you initialized it
but there's no such thing as an "empty tuple", because a tuple is a value
 
@Vogel612 hmm, not how I learnt it.
 
happy to hear what you learned :)
 
My understanding might be shaky but I was told that it's valid value to have zero member tuple
a tuple of {} is analagous to 0 in arithmetric
 
ahhh. bottom
I only know tuples as members of cross-joined sets or as a way to define a "this belongs togehter" in maths
a no-member tuple makes little sense in either context
 
7:17 PM
1     Foo
2     Bar
3     Bazz
4     Duck
And then drawing lines to the members?
1 -> Bazz, 2 -> Duck, 3 -> Bar, 4 -> Foo
 
7:32 PM
cross-join is everyone with everyone.
so {1,2,3,4} x {Foo, Bar} = {(1, Foo), (1, Bar), (2, Foo), (2, Bar), (3, Foo), (3, Bar), (4, Foo), (4, Bar)}
 
AH.... So that's why with SQL doing a Cross join results in OhMaiGawd results overflow.
 
@IvenBach yup. very useful for generating keys for reporting e.g. select all calendar weeks, all categories, all customer types; cross-join them all, get a table with a record for every calendar week + category + customer type.
 
7:49 PM
Makes sense, now.
 
8:00 PM
are there any plans to reintegrate git with rubberduck?
 
8:11 PM
I'm about ready to give up on this issue again. Can't make any headway on it.
 
@KySoto not until the core functionality is fully stable
i.e. parser + resolver stuff
 
and even then I'd honestly rather not
@IvenBach bidirectional binding doesn't help?
I think I used something similar in my fugly CodeMetrics UI
 
I mean, I wouldn't mind reconsidering it once resolver is 100% where it needs to be, no inspections yield any false positives, quickfixes and refactorings never refuctor anything, and we have all the features we've ever dreamed of :)
 
@Vogel612 Width="{Binding Data.Header1Width, Source={StaticResource ColumnWidthProxy}, Mode=TwoWay}" doesn't work.
Each grouping grid acts as if it has its own backing field.
IE they all initialize to the same default value 250 happens to be what I'm using. But when I change the width of ResultsByOutcome the other two groupings don't change.
 
hmm ... lemme check something
could you attempt adding NotifyOnSourceUpdated=true to the binding options?
 
8:27 PM
Adding event handlers to see if that does the trick.
I added them but the dependency property is never being set. Something's not correct.
 
8:46 PM
When setting breakpoints I can see that github.com/IvenBach/Rubberduck/blob/… is getting hit on both getter and setter. I've not understood and set it up properly since TexstExplorerColumnWidthBindingProxy is never accessed.
 
8:56 PM
@Vogel612 I've tried everything I could fathom or understand well enough to try.
 
I dug around and found my old UI thingy
pretty sure it's not perfectly applicable, though
 
If it were I wouldn't be frustrated and struggle to figure it out.
 
sorry for assuming you'd not have done the legwork ...
but I haven't been really good at XAML ever
 
It's me not understanding everything I'm working with. Binding, XAML templates, Logical/Visual tree, etc... When everything is piled one on top of another and interrelated it's easy for me to get lost.
Being able to achieve seeing an autoproperty on the view model being set let me know I was doing enough correct.
I'm confused as to how when only one view model is created it has the width field behave as it's distinct for each CollectionViewSource
 
9:12 PM
@MathieuGuindon hmm, when i was looking for a git in vba tool, it pointed to rubberduck
and i remember reading that rubberduck depreciated that.
 
9:27 PM
That's some cargo-cultist BS you read there. Whether it's a good practice or not depends on what you're doing with the recordset. All it's doing in this case, is delay the entering of the loop. — Mathieu Guindon 10 secs ago
#ProveMeWrong
 
 
2 hours later…
11:03 PM
:shudder: figuring out the differences between two workbooks...
 
11:20 PM
#TIL FC windows command.
 
11:38 PM
ugh. I'm dead. going to bed early today.
 

« first day (1571 days earlier)      last day (1609 days later) »