and i figured out how to sanely build tables

Access the database isn't that great - it's OK when it comes to local work. Access the front-end RAD tool is much better, though. But you're on your own to understand the normalization/db design/SQL and the abstraction before you can put the Access the front-end RAD tool to good use.

Yeah, i essentially pulled myself up by the bootstraps to get to the point where i know what i do about vba, sql and table design

been at it for about 3 years next jan

Good! As long you keep pulling yourself up further and further, you'll be good.

Just don't be that guy who's teaching database class and telling them how to use macros because that's all he needed to do.

Part of what ive been trying to do is build solid (probably not the acronym) code that just doesnt break, and does the job

so that i can be sure that when i use it, i know the code im calling isnt the problem when something happens

so far i have been successful

That's the whole point of our suggestions :)

@KySoto You've learned a lot since then.

man ive been trying lol

That's just about the point in my adventure in programming that I got connected with RD.

I had about 3 months of C++ and maybe 6 with C# and 4 with Java.

I started with C++.

Then had a Java class in college.

honestly, at this point, you guys are my goto resource for understanding new programming ideas in general

Then switched to C#.

we did have a few programming classes that didnt suck

the instructor was all about validation

Mat took me by the hand and I learned a lot when he was re-architecting RD for 2.0.

@Hosch250 why only 3 months of C++?

@this Between HS and college. I got into building UIs with C++, and everyone was like "Do that in C#, bro".

oh on your own?

the whole reason i was able to get decent at vba was probably my vb.net classes

I stopped my C++ journey when I started college.

I was thinking at university.

No, I would've taken C++ if it was an option. They only had Java.

Yeah, that's what got my attention

if there's an uni that legitimately uses C++ through and through, that would be the go-to for those who want to be sicknasty programmers, I think.

There's no escaping the low level details.

I just finished my C++ book last week.

Then again, maybe C++ is a disservice. It's ugly. They might be better to do it in just plain C.

Programming Principles and Practice using C++.

By Stroustrup. I can thoroughly recommend it.

cool

I told you I got the F# book I was looking at, and a book on Microservices?

And pre-ordered Jon Skeet's next version.

I think you mentioned that before yes

but not Jon's (or I missed it)

I'm expecting the first two any day.

I thought that implied it :)

Must. Take. Slow. Deep. Breaths. Explaining code to non-tech pineapples is vexing to say the least.

I hope I apologized enough when I first started coming to this pond with my abounding ignorance.

You apologized almost too much.

What can I say, my wife's got me trained.

LOL.

Back to C# in depth. It worthwhile for me to pick up 4th ed?

I'd say not yet.

3rd edition is good enough for a start.

Then the IoC book.

And 4th ed seems to have trimmed some of the C# 2/3/4/5 sections so they aren't as in depth to focus on 6/7.

No need again, I'd say. The 1st ed on that is more than good enough. That one looks like they are mostly updating the second-half, which is basically a tutorial on different containers.

[rubberduck-vba/Rubberduck] MDoerner synchronized pull request #4465: Reorganizing Rewriting

ive been thinking about my string issue

is there a smaller string datatype access might default to?

Access does have short and long text but that's a database engine data types

those are not known to VBA

similar to how you can just use ints, but it auto ups it to a long if the data you put into it is bigger than an int, but will throw errors if you add two int's overflowing an int

VBA only has one string data type = String, period.

the whole you gotta concat your string every so often so it doesnt truncate it is absolutely stupid

[rubberduck-vba/Rubberduck] build for commit 5986308c on unknown branch: AppVeyor build succeeded

Byte() = String in VBA.

^

You can directly assign between the 2.

@KySoto still need mcve....

thats fun

MCVE?

String is just an abstraction over Byte().

@KySoto Minimal, Complete, Verifiable Example. stackoverflow.com/help/mcve

I think we got everything but the "V". Did you chop your long lines up with vbCrLfs like Max suggested?

i was in the process

i got your MCVE

Public Sub t()
    Dim s As String
    s = "SELECT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaadsaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa';"
    x1 s
    x2 s
End Sub

Public Sub x1(ByVal s As String)
    Dim q As DAO.QueryDef
    Set q = CurrentDb.CreateQueryDef
    q.Name = "foo"
    q.Sql = s
    CurrentDb.QueryDefs.Append q
End Sub

it failed on x2

actually... it threw an error, but created it

@this it would also be the uni where people fail at two separate sections of classes. The one half fails in programming class, the other half fails in theoretical CS

i put hte linebreak halfway through, and it properly created hte query.

Well there you go.

rewriting PR looks good to me.

Anyone wanna add stuff or press the big green button?

just sayin, thats dumb that it works that way, thanks for the help guys

@KySoto error 3219 - invalid operation?

@Vogel612 press it

[rubberduck-vba/Rubberduck] Vogel612 merged pull request #4465: Reorganizing Rewriting from MDoerner/Rubberduck/ReorganizingRewriting2 into rubberduck-vba/Rubberduck/next

[rubberduck-vba/Rubberduck] Vogel612 pushed 35 commits to next (only showing some of them below)

[rubberduck-vba/Rubberduck] MDoerner pushed commit 0ded26bd to next

[rubberduck-vba/Rubberduck] MDoerner pushed commit 16a56076 to next

yay, another tag that I can clean up later :)

[rubberduck-vba/Rubberduck] MDoerner pushed commit 7450c580 to next

which reminds me...

[rubberduck-vba/Rubberduck] MDoerner pushed commit 4494b8d4 to next

@this yes

[rubberduck-vba/Rubberduck] MDoerner pushed commit bd9c9c20 to next

gotta get Appveyor green release tagnames under control

[rubberduck-vba/Rubberduck] MDoerner pushed commit 57ebb43b to next: Merge branch 'next' into ReorganizingRewriting2

[rubberduck-vba/Rubberduck] MDoerner pushed commit 0c222592 to next: Merge branch 'next' into ReorganizingRewriting2

[rubberduck-vba/Rubberduck] MDoerner pushed commit 299e08ae to next

[rubberduck-vba/Rubberduck] MDoerner pushed commit 5986308c to next: Merge branch 'next' into ReorganizingRewriting2

[rubberduck-vba/Rubberduck] web-flow pushed commit bf75416f to next

@KySoto it's actually same error I was thinking of earlier with tabledefs

inline assignments don't work.

assignment to the property after the creation works.

well that is dumb

Why? Ask MS.

sigh

i wasted like 4 hours trying to understand what was going wrong

and it was an effing MS bug

if it's any consolation, I went that process myself years ago

it's flummoxing because the error doesn't occur until you invoke the Append

but in fact it's all about how it was assigned.

that doesn't explain the truncation, though.

When that error is thrown, nothing just happens. no query is created.

[rubberduck-vba/Rubberduck] web-flow pushed commit dd6eae54 to next: Change Stable-Release Tags to be more upfront

@Duga it's a nitpick but FWIW "Stable" just doesn't sit well with me. It's mainly a political thing but I'd rather it be "Release" or something similar.

the problem with "Release" is that every tag is a release..

just some are prereleases

hmm, true.

"Official"? "NotPre"? "Production"? "ItIsOkToUse"?

TBQH for how I'm intending to use it, it could've been anything

RubberduckGreen-v$(appveyor_build) would've worked just the same

this doesn't go into the name of the artifact?

if not, then never mind me.

no. just the tag

the artifact name is independent of that

Ok. then stable is just dandy. :)

BBIAB switching OS. Then tag-cleanup

I might disable Duga before I nuke the 110 ancient prereleases

I will retag the two green releases though.

[rubberduck-vba/Rubberduck] bclothier added label PR-Status: Review Requested to pull request #4520: Fixes 4349...take two

because green tags being just another major.minor.patch.build release doesn't sit well with me

agreed

Want them with the new stable prefix or the old 'dropped build' naming?

my vote'd be for consistent labeling

Lol.

That one's been gone for a while now

it is the stable release for that version.

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot published prerelease Rubberduck-v2.2.0.4157

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Rubberduck-v2.2.0.4157

[rubberduck-vba/Rubberduck] build for commit bf75416f on next: AppVeyor build succeeded

That's the rewriter changes

I wonder -- do we have an opinion RE: putting the issue # directly in a unit test?

[rubberduck-vba/Rubberduck] bclothier commented on RubberduckTests/Refactoring/RenameTests.cs of pull request #4520: Fixes 4349...take two

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.Parsing/VBA/DeclarationCaching/DeclarationFinder.cs of pull request #4520: Fixes 4349...take two

[rubberduck-vba/Rubberduck] comintern commented on RubberduckTests/Refactoring/RenameTests.cs of pull request #4520: Fixes 4349...take two

@this "We" may not, but "I" do.

1.21
1.3
2.0.1b
2.0.2b
2.0.5-rc
2.0.7-rc
2.0.8-rc
Rubberduck-v2.1.1.2400
...

^^ "consistent labeling"

[rubberduck-vba/Rubberduck] BZngr commented on Rubberduck.Parsing/VBA/DeclarationCaching/DeclarationFinder.cs of pull request #4520: Fixes 4349...take two

and 1.2 is particularly egregious...

[rubberduck-vba/Rubberduck] BZngr commented on Rubberduck.Parsing/VBA/DeclarationCaching/DeclarationFinder.cs of pull request #4520: Fixes 4349...take two

bleh ...

I think the GH publish appveyor thingy doesn't create annotated tags...

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot published prerelease Rubberduck-v2.2.0.4158

when did we start using automattion for tags/releases?

[rubberduck-vba/Rubberduck] rubberduck-vba-releasebot created tag Rubberduck-v2.2.0.4158

[rubberduck-vba/Rubberduck] build for commit dd6eae54 on next: AppVeyor build succeeded

$ git describe Rubberduck-v2.2.0.3086 --tags
Rubberduck-v2.2.0.3086
$ git describe Rubberduck-v2.2.0.3086
v2.1.1-1017-g8fd7e120e

@this 2.1.1

that'd explain the consistency prior, then.

:D

yeap...

damn

aight. ~cracks knuckles

[rubberduck-vba/Rubberduck] bclothier added label PR-Status: Review Requested to pull request #4518: Add a check for easy hook's nuget package from nguet cache

[rubberduck-vba/Rubberduck] Vogel612 created tag Rubberduck-Stable-v2.2.0

^^ now THAT's more like it

You got your box up and running again Vogel?

nah, that's all from linux

still waiting for my new cooling solution to arrive before I even get the chance to get VS back up and running

and even then I'm probably going to do a really dirty hack to replace the PSU fan with a Case fan that's powered from outside the PSU

why can't you just put your box outside?

@this Did you check to see if your nuget cache was in the same place as mine?

You have any clue as to what the build issues I've been having are?

...or should I say "nguet"

:-P

@Comintern yes, it was in %user_profile%\.nuget\packages\...

Cool.

@IvenBach I can only guess. Mostly I agree with Comintern and this about what's the issue.

I'm pretty sure it's not NuGet though

I suppose I could add another check for the temp

I agree. Your errors is too early for that.

the Nuget thing is for deployment project.

well... they're too late and too early

too late for the restore phase of the NuGet packages for everything in the solution and too early for it to be the mess around EasyHooks

Schrödinger's build?

@this I'm pretty sure the 2 locations for nuget are fine. If you're going to mess around with it more, I'd copy to the ..\packages tree if it doesn't find it.

eeh.

feels like that would create more bugs

@this LOL, It builds fine when you're not watching?

:turns off build output:

I don't think you even have an option of watching it build.

If only it were that simple.

here's one dumb idea to try out

build the next

get the errors, but change the dropdown from default Build + Intellisense to Build Only

Where do I find that option at?

on the error list window

it's a dropdown on upper right corner of that window

Doesn't change any of the errors listed.

huh. Last time I tried, the numbers did not add up.

So that's what you meant about MSFT numbers not adding up?

Hey, uhhh.... @MathieuGuindon I think we lost a release somewhere along the way...

Like, I had 3 build errors and 106 intellisense errors, but only 96 build + intellisense errors.

Yes

@Vogel612 huh? how?

(which?)

we had lots of 2.1.2 prereleases, but no green release for that AFAICT

wait there's no 2.1.0 tag?

there is a v2.1.0 tag

there also is a v2.1.1 tag

what's the datediff between the 2?

there's a ton of Rubberduck-v2.1.2.* tags, which are all prereleases

and then here it just goes to 2.2.0*

meh, who wants an old version anyway

true, but it makes me think ...

we could go so far as to make AV not release green releases at all

because appveyor tags are only lightweight tags

and we basically skipped a whole bunch of releases in git's mind

@MathieuGuindon this guy in some obscure eastern european running on some Windows Vista with some weird version combination and hacked up Windows OS?

@this 1.4.3 is still available...

and yes, I'm only half joking

:)