« first day (1439 days earlier)      last day (1741 days later) » 
00:00 - 18:0018:00 - 23:0023:00 - 00:00

Duga
Duga
12:00 AM
RELOAD!
[bruglesco/memory-card] 3 commits. 444 additions. 171 deletions.
[rubberduck-vba/Rubberduck] 7 commits. 1 closed issue. 6 issue comments. 20668 additions. 13600 deletions.
 
Duga
Duga
12:27 AM
> RD has context menus for the following COM context menus:

Project Explorer
Code Pane
Form Designer
Form Designer Button

None of these show up in VB6, likely because the IDs differ.
 
Mathieu Guindon
Mathieu Guindon
Visual studio sucks
Tweeted by gitlost on May 14, 2018 at 4:29 PM
@gitlost Pfft. Try the VBE.
Tweeted by rubberduckvba on May 15, 2018 at 12:33 AM in reply to gitlost
 
Mathieu Guindon
Mathieu Guindon
1:36 AM
 
 
1 hour later…
Tweeting Duck
Tweeting Duck
3:06 AM
This is an amazing post by @davidpine7. Pay close attention to the term "Dark Matter Developer" and if you haven't read the article, do so. I know some of these devs and there is no way in hell I would ever want to be there. https://medium.com/@davidpine7/upgrade-yourself-becoming-a-microsoft-mvp-5a61826de93f
Tweeted by saltnburnem on May 14, 2018 at 11:56 PM
 
 
3 hours later…
Duga
Duga
6:18 AM
 
 
2 hours later…
Duga
Duga
8:37 AM
> When I press refresh I get "Unexpected Error"
![image](https://user-images.githubusercontent.com/6458444/40045965-0006b38c-582c-11e8-937b-ec4edf1aaef8.png)
 
 
2 hours later…
Duga
Duga
10:15 AM
> Thank you for reporting this.

To determine what went wrong we will need some more information. It would be great if you could go into the Rubberduck setting to enable logging, hit the refresh button again and post the log here. _Trace_ level would be ideal, but if you fear to leak too much information about your project on that level, _Warning_ or _Error_ might be sufficient.
 
 
2 hours later…
Duga
Duga
11:56 AM
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
 
this
this
@Duga still WIP; now testing to see how AV likes the changes to the script....
 
Duga
Duga
[rubberduck-vba/Rubberduck] build for commit 72bcd946 on unknown branch: 53.51% (target 0%)
[rubberduck-vba/Rubberduck] build for commit ad595ead on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
this
this
yeah not surprised.
 
Duga
Duga
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit d1c9ed64 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
Peter M Taylor
Peter M Taylor
Howdy @this. A question from reading the latest release from ThoughtWorks talks about domain driven scoped events. Would you say that the way RD is attempting to use events in context of parsing and resolving VBA code be similar to the direction ThoughtWorks is talking about? thoughtworks.com/radar/techniques/domain-scoped-events
 
this
this
12:13 PM
not familiar w/ their works so not sure how to comment
will read when I have more time
 
Peter M Taylor
Peter M Taylor
No worries...
 
Duga
Duga
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 865e1e4a on unknown branch: AppVeyor build failed
BUILD FAILURE!
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 50b549c7 on unknown branch: AppVeyor build failed
BUILD FAILURE!
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 8d6415cf on unknown branch: AppVeyor build failed
BUILD FAILURE!
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 7014b79e on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
Duga
Duga
1:09 PM
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 2a750a61 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
this
this
@Duga i think it boils down to AV not having the script VS is supposed to have in the same place. I love blindfolded easter egg hunts!
 
Dain Ironfoot III
Dain Ironfoot III
1:37 PM
I got something done at work and posted a screenshot for my boss. I almost said "Look, Ma! No [element]!", when I realized she's old enough to be my mom, and I'm not sure how she'd take it...
 
QHarr
QHarr
Question for the brainy people....
I have an OP asking about programmatically (sp?) adding ActiveX control and associating it with an event. Also added programmatically.
So I have told them how to use the VBIDE
Now they have changed their initial query from simply Click type event to MouseMove
But would I have to add an API call for the mousestuff ..
I guess that is just more lines to go into VBIDE.CodeModule at the top
no? Apologies for splurge......
 
Dain Ironfoot III
Dain Ironfoot III
Hi, @ÁdámBukovinszki!
 
this
this
1:53 PM
@QHarr not sure I'd want to write metacode to do this kind of thing. It makes sense for writing code that are used at develop-time but this feels a bit too much like runtime code than develop-time code and for that reason I'd probably be using a class to template the active controls and their events.
 
Ádám Bukovinszki
Ádám Bukovinszki
Hi guys,
I'm stuck a bit with ActiveX scrollBars in Word.
Just posted the q: https://stackoverflow.com/questions/50351952/vba-word-how-to-get-the-value-out-of-an-inline-scrollbar-or-how-to-have-a-si
Is there somebody who can help me out?
 
QHarr
QHarr
@this Agreed. I guess with the advantages of being easier to extend/ re-use etc..? Any thing else?
 
Dain Ironfoot III
Dain Ironfoot III
@ÁdámBukovinszki Maybe. I can't, as I don't write VBA.
If you have an interesting C# question, I'm game :)
 
Ádám Bukovinszki
Ádám Bukovinszki
@DainIronfootIII Nah, I need to stick with Office + VBA for now, but thanks.
 
Ádám Bukovinszki
Ádám Bukovinszki
2:27 PM
Ok, i figured it.
Actually it is even simpler then in Excel VBA.
I have no idea though why it did not work with ActiveDocument.InLineShapes("name").value ..
But it works as activedocument.SB_Q1_B131.value
 
IvenBach
IvenBach
@ÁdámBukovinszki glad you figured it out.
ps welcome to the pond
@DainIronfootIII crisis nicely avoided.
 
Duga
Duga
3:03 PM
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit aa254552 on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
this
this
@Duga gotcha. now to find out why it doesn't have $(DevEnvDir) defined....
 
Duga
Duga
3:26 PM
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
[rubberduck-vba/Rubberduck] build for commit 7c9192ab on unknown branch: AppVeyor build failed
BUILD FAILURE!
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=h1) Report
> Merging [#3975](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/3975?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/67c765707768cc330d9ed1202de38f7e7af9aea5?src=pr&el=desc) will **decrease** coverage by `0.15%`.
> The diff coverage is `n/a`.


```diff
@@ Coverage Diff @@
## next #3975 +/- ##
==========================
 
IvenBach
IvenBach
@this Making progress on your whack-a-bug adventure?
 
this
this
no, AV's being pigheaded
we both know it has the midl.exe but it won't set up the environment it needs.
gee, this build process makes a house of cards look sturdy in comparison
 
Mathieu Guindon
Mathieu Guindon
well it used to be relatively simple ;-)
 
this
this
i'm getting compiler errors all over. :(
until a jerk came along and made it overcomplicated....
someone should shoot him.
 
Duga
Duga
[rubberduck-vba/Rubberduck] build for commit 40db879b on unknown branch: AppVeyor build failed
BUILD FAILURE!
 
this
this
3:38 PM
@Duga yeesh, message received. No messing w/ the environment.
 
Mathieu Guindon
Mathieu Guindon
lol
 
this
this
and it does not help that MSFT decided it was a great idea to have different path to stuff on every system, because.... you know, flavors!
 
IvenBach
IvenBach
3:50 PM
Could shutting down SSMS without disconnecting beforehand from the server cause any issues?
 
Dain Ironfoot III
Dain Ironfoot III
Do it every day.
 
Mathieu Guindon
Mathieu Guindon
SSMS would be disposing its connections on shutdown, so no.
 
Dain Ironfoot III
Dain Ironfoot III
No issues yet..
 
Mathieu Guindon
Mathieu Guindon
^
ditto
 
IvenBach
IvenBach
I'd rather ask the question than be the duckhead that messes everything up.
 
Mathieu Guindon
Mathieu Guindon
3:52 PM
one could think the shutdown is faster & cleaner if you've manually disconnected first though
 
M.Doerner
M.Doerner
4:20 PM
The only thing I ever care about with SSMS is to not have a query running when I pull my laptop out of the docking station.
 
IvenBach
IvenBach
Is the proper nomenclature a Field or Column in SSMS?
 
Mathieu Guindon
Mathieu Guindon
SSMS is the client, you mean in SQL Server :)
and IMO that would be Column
 
this
this
SQL standard uses "column"
field is an Access thing
 
IvenBach
IvenBach
TYVM
ALTER TABLE foo DROP ColumnName; is the correct syntax to nuke a column?
 
this
this
yeah, I think so
 
IvenBach
IvenBach
4:31 PM
I messed up and didn't add NOT NULL when I added it.
 
this
this
there's this stupid quirk between column and constraint
no, I think you must say ALTER TABLE foo DROP COLUMN bar;
 
IvenBach
IvenBach
^
just saw that
 
this
this
because otherwise, it thinks you are dropping a constraint
 
IvenBach
IvenBach
I'm going to do my slow moving method to ensure I get it spot on.
 
this
this
on the flip, if you ALTER TABLE foo ADD bar; it is a column, not a constraint.
so ALTER TABLE foo ADD bar PRIMARY KEY (baz); is not legal.
yet ALTER TABLE foo DROP bar; is what you must do when bar is a constraint. Oh, T-SQL you're a riot!
 
IvenBach
IvenBach
4:35 PM
ALTER TABLE dbo.Foo DROP COLUMN [ IF EXISTS ] IsCompleted
Would there be issues for omitting IF EXISTS and the Column wasn't in the table?
 
this
this
you should get in habit of using the IF EXISTS
that makes your script a bit more idempotent
 
IvenBach
IvenBach
That's why I'm asking.
 
this
this
on the other hand, when you are doing DDL, they are destructive by nature so if data loss is going ot be a problem, you might rather want to get errors in your scripts instead of it running successfully and your data blown away
Personally, it's more likely we do want to blow away the data (and in case where there is a data loss, there are other script commands that moves the data to temporary table or whatever anyway) so having those errors ends up being unhelpful and for that reasons, IF EXISTS is a godsend, IMO.
 
Son Goku ssj4
Son Goku ssj4
Hi folks.
 
Dain Ironfoot III
Dain Ironfoot III
Hi!
 
Mathieu Guindon
Mathieu Guindon
4:44 PM
hi!
 
Son Goku ssj4
Son Goku ssj4
So I've tried, after a while (of some months) my 4 unit tests :-D
Well...
 
Duga
Duga
 
Mathieu Guindon
Mathieu Guindon
@SonGokussj4 FYI I've merged the Rubberduck.Resources PR, you should be able to pull these changes and resume the translations now
 
Duga
Duga
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon :) Nice! At first I went here to ask about that.
 
Mathieu Guindon
Mathieu Guindon
4:46 PM
@SonGokussj4 is the host document / VBAProject saved?
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon I just opened it. On OneDriver.
 
Mathieu Guindon
Mathieu Guindon
is ThisWorkbook.FullName a local path?
 
Son Goku ssj4
Son Goku ssj4
Happening with 10 days older version of the file saved on Desktop too.
 
Mathieu Guindon
Mathieu Guindon
the exception should be handled though
 
Son Goku ssj4
Son Goku ssj4
?ThisWorkbook.FullName
C:\Users\jverner\Desktop\MatigueDev_v20180509_1821.xlsm
 
Mathieu Guindon
Mathieu Guindon
4:50 PM
k
not sure what's going on then
 
Son Goku ssj4
Son Goku ssj4
 
M.Doerner
M.Doerner
@IvenBach Can't you simply add the not null constraint to the column?
 
Son Goku ssj4
Son Goku ssj4
Of the Error window
 
this
this
@M.Doerner AFAIK, not possible to modify - ALTER COLUMN is basically replacing the column in its entirety.
 
Son Goku ssj4
Son Goku ssj4
Tried 5 months old version of my Excel file and it's the same when I run the tests. So I think it's either Duckie or some SW change on my Machine at work.
I'll try my personal laptop.
 
M.Doerner
M.Doerner
4:57 PM
That would be rather stupid. Adding a nullable column, consecutively updating it and then making it not nullable seems to be a standard technique for no-downtime-deploys, as far as I have read.
 
Mathieu Guindon
Mathieu Guindon
AFAIK you can't use ALTER TABLE to make a column non-nullable [if the table contains data]
you can make a column nullable, or add a nullable column without dropping the table, but adding a non-nullable column requires recreating the table
 
this
this
hm. pretty sure it doesn't -- as long there are no nulls in the data , table need not be recreated
I've done it few times
what you can't do, though is put it in some other ordinal position or alter only the nullability -- you must alter the data type and nullablity and all other properties in one go
 
M.Doerner
M.Doerner
You obviously cannot add a non-null collumn without default value to a table with existing data. That would immediately violate the constraint.
If I understand the documentation of ALTER TABLE correctly, you have to provide the column data type when changing from NULL to NOT NULL, but it will not really change anything if you provide the same data type as before.
 
Mathieu Guindon
Mathieu Guindon
IOW best is to actually know whether you need a column to be nullable when you first create the table =)
 
Son Goku ssj4
Son Goku ssj4
Okay so:
v2.2.6672.28001 - Laptop - OK
v2.2.6702.24002 - Work PC - Crit Error
v2.2.6708.13023 - Laptop - OK - BUT (Rubberduck - Unit Test - ... no strings?, when I press the first empty space and Test Explorer Shows, There are #TestExplorerOutcome, #TestExplorerQualifiedModuleName, ...)
v2.2.6708.13023 - Work PC - Crit Error (same text missing)

So it's because of my Office 2013 Virtual Win 10 on Linux through Oracle ... Hmm... Why the hell...
 
Mathieu Guindon
Mathieu Guindon
5:10 PM
> Office 2013 Virtual Win 10 on Linux through Oracle
uh
 
M.Doerner
M.Doerner
What I meant with not really changing anything is that it only adds the constraint and does nothing else.
 
Son Goku ssj4
Son Goku ssj4
On my Centos7 Work PC running newest Oracle Virtual Machine with 1709 Windows 10 and Office 2016 32bit. To be specific. :)
But it's weird. I would give you a finger that it worked before. At least it's only testing :) Which I didn't do much for now.
 
Mathieu Guindon
Mathieu Guindon
oh this is scary
and IMO rather likely related to the reason why the typelib API can't find the module
not sure what we can do there
other than saying "running in a VM on a non-Windows host isn't a supported scenario. may or may not work"
 
Son Goku ssj4
Son Goku ssj4
It worked (all of it) without a problem till now. Well, last time I tested the Tests it was around January.
 
this
this
i run my vm off vmware and that wasn't a issue.
 
Mathieu Guindon
Mathieu Guindon
5:18 PM
that would have been before the typelib api was merged
@this linux host?
 
this
this
basically
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon What about these?
 
Mathieu Guindon
Mathieu Guindon
?
 
Son Goku ssj4
Son Goku ssj4
The only one that has the red strip all the way to the left.
 
Mathieu Guindon
Mathieu Guindon
hey @WaynePhillipsEA
 
WaynePhillipsEA
WaynePhillipsEA
5:21 PM
howdi
 
Mathieu Guindon
Mathieu Guindon
@SonGokussj4 IDK.. missing key in the .cs file, maybe?
haven't used resxmanager in a while, IDK
 
Son Goku ssj4
Son Goku ssj4
Okay. I'll ignore it for now. :) And continue with the translation.
 
Mathieu Guindon
Mathieu Guindon
:+1:
 
Son Goku ssj4
Son Goku ssj4
Good job. Thanks for the work to get it ready.
 
WaynePhillipsEA
WaynePhillipsEA
@SonGokussj4, you using the latest RD build? I put a PR in a few days back that was supposed to fix this for @IvenBach who had a similar problem
 
Mathieu Guindon
Mathieu Guindon
5:23 PM
@SonGokussj4 FWIW RubberduckUI.resx is going to be further broken down in the near future
@WaynePhillipsEA I only got to it and merged it yesterday though
 
Son Goku ssj4
Son Goku ssj4
@WaynePhillipsEA Yes. As written above, I've tried older versions, then updated it to the newest that is downlodable for now and still the same (with broken texts)
@MathieuGuindon Which means, for me, that I should.... Speed it up? Push regularly? Ignore RDUI.resx? :)
 
Mathieu Guindon
Mathieu Guindon
the faster the changes are in, the easier it'll be, yeah
I'll wait for your stuff and move on to tackle other issues, no rush
 
WaynePhillipsEA
WaynePhillipsEA
@SonGokussj4 so you're on v2.2.0.3242?
 
IvenBach
IvenBach
@SonGokussj4 I was having some issues with that. I renamed VBAProject to something since it looks like the ambiguity at not knowing which one was the correct VBAProject was causing the issue.
Wayne's already brought you up to speed it seems.
 
Son Goku ssj4
Son Goku ssj4
@WaynePhillipsEA Yeah: Rubberduck v2.2.0.3242-pre
 
WaynePhillipsEA
WaynePhillipsEA
5:30 PM
hi @IvenBach could you test if my PR fixed your issue?
 
Son Goku ssj4
Son Goku ssj4
In "About" there is v2.2.6708.13023
 
IvenBach
IvenBach
Yep. Should be able to a bit later.
 
WaynePhillipsEA
WaynePhillipsEA
cool, thanks
 
Duga
Duga
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon So do some translation, Push to my repo and create PR to your Rubberduck/next repo?
 
WaynePhillipsEA
WaynePhillipsEA
5:33 PM
@SonGokussj4 please try to step through the loop in the Get method that is failing. The loop should be working through each module in your project until it finds the TestModule1 (or not in this case). But hopefully by stepping through the code you might get a clue as to what is wrong
 
Son Goku ssj4
Son Goku ssj4
@IvenBach Sorry for potential stupid question, how do I rename VBAProject? I tried rename the TestModule1 to TestModule01 and different filename.
 
IvenBach
IvenBach
Tools>XXX Properties>Project Name
XXX will be whatever the project name is.
 
WaynePhillipsEA
WaynePhillipsEA
In your pastebin log, it looks like it is v2.2.0.3210. That one wouldn't have my PR
 
IvenBach
IvenBach
The non-unique name was what, apparently, was causing my conflict with unit tests. Changing it resolved the issue.
 
Son Goku ssj4
Son Goku ssj4
Ow wow. Seeing this for the first ime. :D Sorry.
 
Mathieu Guindon
Mathieu Guindon
5:40 PM
@SonGokussj4 wait are you using a local build or a prerelease build? If both are registered that could explain some of the problems
 
IvenBach
IvenBach
I've had many moment of "How long has this been here?"
Hope my problems help you get unit tests working. #HoorayForProblems
 
Dain Ironfoot III
Dain Ironfoot III
@IvenBach Since yesterday :)
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon On all my computers I try to use the newest Prerelease builds all the time. No builds. Don't know how to do that. Yet.
 
Mathieu Guindon
Mathieu Guindon
(although, I believe @this' Deployment stuff might be preventing these issues now)
 
Son Goku ssj4
Son Goku ssj4
@IvenBach It WORKED.
 
IvenBach
IvenBach
5:41 PM
:+1:
 
Dain Ironfoot III
Dain Ironfoot III
@SonGokussj4 FWIW, doesn't RD rename do that?
 
Son Goku ssj4
Son Goku ssj4
@WaynePhillipsEA Yeah it was a log just before I've tried the newest build. Sorry for misinformation.
 
WaynePhillipsEA
WaynePhillipsEA
np
 
Mathieu Guindon
Mathieu Guindon
@SonGokussj4 the machine you use to modify the resx files would need to have a debug build, not a prerelease
 
Son Goku ssj4
Son Goku ssj4
Well I'm modifying that on 3 machines. I have it saved on OneDrive.
Just pushing the changes won't work?
 
Mathieu Guindon
Mathieu Guindon
5:43 PM
It would... but don't you want to test it?
 
IvenBach
IvenBach
@MathieuGuindon So it seems I'll be re-creating the table...
 
Dain Ironfoot III
Dain Ironfoot III
@IvenBach No.
You can set a default value on the column.
 
IvenBach
IvenBach
How do I accomplish that?
 
this
this
@MathieuGuindon no, if there's a per-machine registeration, it'll trump. the deployment does per-user
 
Dain Ironfoot III
Dain Ironfoot III
So, you could set 0 on it now, and then write a script to update the value, or something.
 
Son Goku ssj4
Son Goku ssj4
5:45 PM
@DainIronfootIII If you mean THIS, that doesn't do nothin'
 
Dain Ironfoot III
Dain Ironfoot III
@SonGokussj4 :(
 
Son Goku ssj4
Son Goku ssj4
But hey, I didn't even know that I can rename a project.
 
IvenBach
IvenBach
 
Son Goku ssj4
Son Goku ssj4
By nothing I mean - I click on it and it just dissapears.
 
IvenBach
IvenBach
<column_definition>::=
{
    column_name
    type_name [ ( precision [ , scale ] ) ]
    [ <column_constraint> ]
    [ COLLATE Windows_collation_name ]
    [ NULL | NOT NULL ]
}

<column_constraint>::=
    [ CONSTRAINT constraint_name ] DEFAULT constant_expression
 
Dain Ironfoot III
Dain Ironfoot III
5:46 PM
2849
A: Add a column with a default value to an existing table in SQL Server

James BootherALTER TABLE {TABLENAME} ADD {COLUMNNAME} {TYPE} {NULL|NOT NULL} CONSTRAINT {CONSTRAINT_NAME} DEFAULT {DEFAULT_VALUE} WITH VALUES

Yes.
 
Son Goku ssj4
Son Goku ssj4
@MathieuGuindon That would be great. :-D To test it... Hope there is a really comprehensive tutorial how to build RD for that.
Because I see this and my stomach just got worse. :D
 
IvenBach
IvenBach
@DainIronfootIII Silky smooth Commands completed successfully.
Stuff is so much easier when you can understand what you're doing!
 
this
this
@SonGokussj4 the important point is that you should unregister your old machine-level RD
and set the execution policy. once done, it's automated.
 
Son Goku ssj4
Son Goku ssj4
@this By simple words - I should uninstall Prerelease version, have admin rights and then try the tutorial for building?
 
Mathieu Guindon
Mathieu Guindon
the about box showing a non-zero revision number would be a debug build, unless I broke something
 
this
this
5:53 PM
both prerelease and release build should be uninstalled
 
Son Goku ssj4
Son Goku ssj4
Sorry but the whole Build / register / COM / hklm process gets totally around me. I know some programming, I build PCs, I know HW, I remember and know how to install Win95 - Win10 and how to set up network, virtual machines etc...

BUT - I didn't build ever a single thing on PC and I've never tinkered with powershell. I'm more of a linux guy because of my work now.
 
this
this
it's only complicated because you have a older machine-level install
 
Son Goku ssj4
Son Goku ssj4
What's older machine-level install? O.O
 
this
this
the whole point of this riff-raff in the deployment is support per-user install
you know how RD used to required admin privileges just to install?
it doesn't anymore.
 
Son Goku ssj4
Son Goku ssj4
I know.
 
Mathieu Guindon
Mathieu Guindon
5:55 PM
speaking of registration, my newly setup dev VM can build and register, but not F5-debug
 
this
this
all because of that riff-raff.
 
Son Goku ssj4
Son Goku ssj4
I have the lastest prerelease per user.
 
this
this
oh ok
 
Son Goku ssj4
Son Goku ssj4
installed. Because I don't have admin privileg. on my work computer.
 
this
this
and prelease was downloaded?
i thought you had a per-machine install, my bad
 
Son Goku ssj4
Son Goku ssj4
5:56 PM
I go here like 3 times a week and installing the newest builds all the time.
https://github.com/rubberduck-vba/Rubberduck/releases
 
this
this
@MathieuGuindon how do you usually set up to f5?
so you download it, ok
it might be better to use git for that.
 
Mathieu Guindon
Mathieu Guindon
I don't do anything special...
 
this
this
don't you have to set up the command line arguments?
 
Mathieu Guindon
Mathieu Guindon
basically if I start Excel manually then the VBE happily loads Rubberduck. F5-debug launches Excel, but then the VBE can't find Rubberduck.
@this I did...
 
this
this
ah i know why
you are running VS as admin
and since you F5 Excel
it is inititated as admin
 
Mathieu Guindon
Mathieu Guindon
5:58 PM
wait you mean we no longer need to run VS as admin!?!
 
this
this
so you're now on the wrong side of the track
uh, i still run it as admin for like forever
 
Mathieu Guindon
Mathieu Guindon
damn now I need to reconfigure my taskbar shortcuts lol
 
WaynePhillipsEA
WaynePhillipsEA
I've just setup/loaded two projects called VBAProject in the same Excel instance, and I'm no longer seeing the typelib API issue that IvenBach reported. So I think the main ambiguity issue is fixed. However, I found a related issue, in that ModuleInitialize is not running, or more correctly, the ModuleInitialize is running, but not the one in the correct project that houses the unit test
 
this
this
not sure if it's even possible to run it as non-administrator.
 
Mathieu Guindon
Mathieu Guindon
huh, confused now
 
this
this
5:59 PM
TBH, I never had any good luck running VS as normal user
for any projects
 
00:00 - 18:0018:00 - 23:0023:00 - 00:00

« first day (1439 days earlier)      last day (1741 days later) »