> You will want to add the following test(s) to the ones already present in `ProcedureNotUsedInspectionTests`: ```csharp [TestCase("@TestMethod(\"TestCategory\"")] [TestCase("@ModuleInitialize")] [TestCase("@ModuleCleanup")] [TestCase("@TestInitialize")] [TestCase("@TestCleanup")] [Category("Inspections")] public void ProcedureNotUsed_NoResultForTestRelatedMethods(string annotationText) { string inputCode =
Hi folks. Anyone that is using Arrays in VBA? I'm trying to put a value in an array within 2-times nested dictionary and it just won't work. And if it does, it resets the alterady inserted values... Don't know what do I do wrong...
splittedItem = "1"
curKey = "SP_V1"; colIdx = 1
list(curKey)("Values") is a Ubound=24 1D Array
When I do list(curKey)("Values")(colIdx) = splittedItem it won't even insert the item.
When i do
varArr = list(curKey)("Values")
valArr(colIdx) = splittedItem then it insers the value just find into array position (colIdx). BUT when the colIdx is changed to 2 in the next iteration, when the line varArr = list(curKey)("Values") runs, I see in the watch window empty array...
Starting to think I don't have brains for that. Or understanding of VBA... Because in Python, I would have this in 5 minutes. VBA? 2 hours and nothing... :-/
So I tried to write a "test" sub... Still happening. That means there is something I don't know about VBA :-/
Anybody with free time to try to look at this or try to fix it? :-D
Sub TestNestedDictArray()
Dim str1 As String: str1 = "01|02"
Dim str2 As String: str2 = "01|02|03"
Dim coll As Collection
Set coll = New Collection
coll.Add str1
coll.Add str2
' RESULT should be
' list = {
' "Values": {
' "SP_V1" = ("01", "01", "")
' "SP_V2" = ("02", "02", "")
' "SP_V3" = ("", "", "03")
' }
' }
Dim list As Scripting.Dictionary
Set list = New Scripting.Dictionary
Dim longest As Long
longest = 3 ' from all strX longest split
Hmmm...the syntax looks legal enough without having VBA in front of me. Am I right that your problem is that your code "compiles" and executes without raising an error, but that the array in the collection never changes? If so, I think that's because your A.Item(1) might be returning a copy of th...
basically if you need a mutable nested data structure, you need a custom collection class
hm, thinking ArrayList might work for this
@SonGokussj4 huh that inner loop looks wrong:
For Each splItem In splitted ' splItem = "01"
list(curKey)("Values")(colIdx + 1) = splItem
Next splItem
Sub TestNestedDictArray()
Dim str1 As String: str1 = "01|02"
Dim str2 As String: str2 = "01|02|03"
Dim coll As Collection
Set coll = New Collection
coll.Add str1
coll.Add str2
' RESULT should be
' list = {
' "SP_V1" : {
' "Values": ("01", "01", "")
' }
' "SP_V2" : {
' "Values": = ("02", "02", "")
' }
' "SP_V3" = {
' "Values": ("", "", "03")
' }
' }
Dim list As Scripting.Dictionary
Set list = New Scripting.Dictionary
Sub test()
Dim foo(1 To 5)
foo(1) = 42
mutate foo
Dim i As Long
For i = LBound(foo) To UBound(foo)
Debug.Print foo(i)
Next
End Sub
Private Sub mutate(ByRef arr As Variant)
arr(1) = 10
End Sub
@jcrizk I'm thinking how to elegantly convert those ranges into arrays. I almost had it with collections with .add but there was a problem where the "next split" was longer and I didn't know how to tell the program to put it into X position instead of first or second...
I'm now looking into ListArrays. Didn't even know they existed. But they are behaving weirdly too.
I thought of that but didn't occur to me how. I tried to :add: but there was a problem "where" to add. Well I'm nearly finished thanks to that ListArray :-) That's what was missing. I couldn't do "collection(3) = ..."
@MathieuGuindon: Thank your for the ListArrays. They did the job! Finally it works.
now I can go to sleep :D Waking up in 40 minutes :-D
Sub TestNestedDictArray()
Dim arlist As Object
Set arlist = CreateObject("System.Collections.ArrayList")
Dim str1 As String: str1 = "01|02"
Dim str2 As String: str2 = "01|02|03"
Dim coll As Collection
Set coll = New Collection
coll.Add str1
coll.Add str2
' RESULT should be
' list = {
' "SP_V1" : {
' "Values": ("01", "01", "")
' }
' "SP_V2" : {
' "Values": = ("02", "02", "")
' }
' "SP_V3" = {
' "Values": ("", "03", "")
@SonGokussj4 here's an algorithm that i think would also help you
``` Option Explicit
Public Sub TransposeExample() Dim str1 As String: str1 = "01|16" Dim str2 As String: str2 = "02|16" Dim str3 As String: str3 = "03|16|0|80" Dim strColl As Collection Dim arrColl As Collection Dim newColl As Collection Dim arrLen As Integer Dim i As Integer Dim j As Integer Dim longest As Integer: longest = 4
Set newColl = New Collection Set arrColl = New Collection Set strColl = New Collection strColl.Add str1
oh jesus lol i gotta reformat that
what are the magic symbols for entering code in chat if not backticks?
@SonGokussj4 here's a better formatting for it lol
Option Explicit
Public Sub TransposeExample()
Dim str1 As String: str1 = "01|16"
Dim str2 As String: str2 = "02|16"
Dim str3 As String: str3 = "03|16|0|80"
Dim strColl As Collection
Dim arrColl As Collection
Dim newColl As Collection
Dim arrLen As Integer
Dim i As Integer
Dim j As Integer
Dim longest As Integer: longest = 4
Set newColl = New Collection
Set arrColl = New Collection
Set strColl = New Collection
i'll definitely forget until the next time i need to do it
@SonGokussj4 anyways, if you look at the newColl variable in the locals window in that algorithm, you'll see that it populates the items how you wanted them to be populated
@theVBE-it'srightforme I would like to :-D Free time. But nah. I work 5 year already :-) And no. No free day today. The other way around. I've got training for SolidWorks API :-D
@jcrizk But they won't highlight. :-)
@jcrizk Thanks. I'll look into that throughout the day! :-)
@theVBE-it'srightforme And you can backtik some code
But when you `backtick` more lines It `won't show` as code anymore
i would think it would have to. could you imagine manufacturers that have literally the same parts, but have like 2 dimensions that they just size up/down a million times?
> Would it make sense to make make a child annotation called something like "TestAnnotation" -> make those test cases the new annotation type -> exclude anything that's a "TestAnnotation" from the results?
I don't know exactly how all of the pieces work together at this point, so that's my initial thought of how to implement excluding those annotations from the results.
@theVBE-it'srightforme Yeah. solidvision.cz/registrace Well I'm not sure what language they will show us. I hope VB.NET or C# at least. But I don't have my hopes up. There were some problem where we just can't figure out how to write the script to do things fast. Hope it's not program fault but our and will learn how to write it better :-)
@theVBE-it'srightforme We are using this one at our work every day. beta-cae.com/ansa.htm and it's using Python. It's a blast to write scripts for that :-) Ansa - preprocessor, Meta - postprocessor, Komvos - computing.
just beware of huge programs built with dynamically-typed languages like python. they're nice for small stuff, but they get to be a huge headache to maintain. And this is coming from someone who has to work with giant Matlab repo every day at work.
@this Of course they do. Communism sounds absolutely fantastic on paper - that's why so many young Americans are so enthused about it to. (OK, Socialism, but it's just a short jump from there to Communism.) It's only after a decade or so in practice that the veneer wears off and you realize it's far worse than the capitalism that you just voted (or "revolted") yourself out of.
It seems that linked servers are the best only option for cross-server querying. What options are available if establishing a link is no permitted for "reasons" by the owners of one of the servers?
@FreeMan i will add a stipulation to the notion that people are pro-communism. offering adequate, if not minimal, access to necessities (the big four: food, water, shelter, & clothing) is not a socialist principle. it is considered the requirement for a republic, ensuring that the people of the republic are in a capacity to both understand and accept the rule of law (paraphrasing roman text with that statement). it's a significant jump from communism to socialism, both ideally and in reality
karl marx indicated that a true socialism could not be achieved in one generation due to the reality that people can only change so much; until all of those that supported the changed are dead and gone will the changed world be accepted as the true reality
lenin in fact took a marx quote, removed that section, and used that in in address to the soviet union, in support of the preceding years of oppression as necessary
@Cyril "access to necessities (the big four: food, water, shelter, & clothing)" is the big ticket that seem to be most missing in socialist or communist countries.
:53357565 not purely a socialist principle... forgot that word and only just cautght it
@FreeMan completely agreed. going back to "on paper" those are provided, but if everyone is equal, you need to keep power some way, correct? oppression is simpler than core-communism
@FreeMan Options: 1) Query "other" db, write data to file, import into "this" db. 2) Establish separate db connections in code, query "other" db, get data into string, insert/update "this" db with string of data
@FreeMan Note: "this" database, not "@this" database. ;)
@Cyril people complain about how the "rich people" oppress the "poor people" in a capitalist economy. What they fail to realize is that the "poor people" have an opportunity to become "rich" under capitalism. Under social/comun-ism that opportunity does not exist. You're a have or a have-not and you're stuck there.
@theVBE-it'srightforme Many CAD/CAE suites have scripting support one-way or another and Excel integration one way or another. SolidWorks, Altium, EPLAN, AutoCAD. If there is VBA support it's usually not 100%, but quite useful to know.
@FreeMan i wouldn't go as far as to say "does not exist," but I understand and concur with the sentiment of your statement. my above point was directed primarily at the "young Americans" aspect of your response to Ben's linked article and the "short jump" from communism to socialism, reflecting what was listed in Rome's Republic, a strong basis for the American government's system of representation
didn't someone 'round here have some sort of an ODBC/SQL wrapper class? I've done some searching on the hub of gits and don't seem to be able to find one. (my git-fu is arguably quite weak)
> What you could do is toame the annotation classes for tests inherit a marker interface `ITestAnnotation` and exclude all results with such an annotation from the results of the inspection.
You cannot make the test relevant annotations inherit from some new annotation class, since they are already on a different hierarchy.
> What you could do is to make the annotation classes for tests inherit a marker interface `ITestAnnotation` and exclude all results with such an annotation from the results of the inspection.
You cannot make the test relevant annotations inherit from some new annotation class, since they are already on a different hierarchy.
@Cyril it's weird reading "a short jump from communism to socialism" - I usually think of communism as more extreme form of socialism, so it should be "a short jump from socialism to communism"
@this it's a weird concept, yes... looking at ideology, communism is more defined than socialism, but the outcome of communism would be pure socialist society (weird to quote Jonestown transcripts without referring to "drinking koolaid"... but here we are). on the contrary, transitioning towards either communism or socialism, specific to "young Americans", the move from capitalist republic to socialist republic to democratic socialism (essentially communism), is a pretty big leap
in either situation, socialistic principles are utilized to push both communism and pure-socialism, which i take as the key-point in your statement
so in reflection of the above and tying back to "communism to socialism", the current communist/socialist governments (this is the painful part as it teeters between ideology and government, which are distinctly different) implemented communism preceding socialism. so the level of oppression, etc., are incredible; you have lost the four-necessities (touching on Freeman's above point) and are trying to "leap" to socialism... which is pretty f'ing impossible
i'm trying to be mindful of person's who have differing opinions, but my last statement is pretty impartial. sorry ='/
Here's the thing, I don't think "pure socialism" is a thing. As you said, communism, as an ideology is more defined than socialism which is basically a hodge-podge of good things we like from other ideologies, without the bad things we don't want from other ideologies. However, the more power you give to the government, and by necessity, you must for several socialistic principles to function, the more liable you are to end up with a corrupt and oppressive government.
I remember reading a point made by a famous author that has unfortunately slipped my memory but the gist was that you should be more afraid of the politicians who are doing it for your own good than you should be of the robber barons. The reasoning is that the politicians genuinely believe they are doing a good thing, a service to the people, and thus their conscience is not perturbed compared to a baron who wantonly oppress and plunder the people.
@this your final sentence is the crux of the problem. Funny thing, though, is that's the argument that's being used in defense of socialism. "Those Christians/Republicans/Capitalists are trying to control you! Join us, we'll set you freeeee !!!!"
9 most terrifying words in the English language: "We're from the government, and we're here to help."
my personal take is that nothing is free of corruption/manipulation for one's own gain. wasn't trying to impart my position on good/bad, but present a tangential point to a statement made
@this part of the apology on the "which is pretty f'ing impossible", pretty much my thoughts were exactly as you laid out in your final sentence
also, i'm racking my brain trying to remember who wrote abotu vanderbilt/rockafeller regarding the oligarchs versus politicians
might have a eureka moment later... not thinking of it
They made the laws deliberately so they would primarily affect the sharecroppers, which was most of the southern black community and a good number of whites. The rich people didn't have to sacrifice their crops.
For example, I might use Access as the tool to do cross-server querying where I cannot use linked server. Or simply pull data to the front-end if the data is going to end up staying in the front-end.
@this I guess really what it comes down to is instead of INSERT INTO thisDB.table SELECT x FROM thatDB.table, I have to SELECT FROM thatDB.table, hold the data somewhere, then INSERT INTO thisDB.table
Whether you do it with Access or SQL Server, heterogeneous query is definitely unfun and absurdly slow. Thus, just importing data usually might outperform the hetergeneous approach.
Sounds to me you're better off just bouncing the data over the filesystem between the two servers.
"They" would be my hang-up on your statement. Which "they" are you referring? Sharecropping, the concept of providing a portion of one's land to be farmed by another, whereupon that lord would receive a portion of what was produced. After that system was deemed "oppressive", some states put in place laws that indicated what percentage of "portion" was appropriate, while there was a latter federal law put in place to provide stipends for owned land. After the stipend bill came into effect, states began to push "pro-farmer" bills which required a portion of the stipend go to the farmer, no…
Once I figure out the connection itself, there's no reason, though, that I cannot connect to both servers from the same VBA code, right? I just can't use them in the same query.
i'm looking primarily at mississippi and alabama, the only two states i've done any research regarding feudal systems related to post civil-war through jim crow era laws
postscript, that's also going off of recollection from about 15-20 years ago when i was in college
You can use them in Access (I did say it supports heterogeneous query). If you're using ADO, then yes, you can't do heterogeneous; you have to use DAO + Access engine.
that's how I have to connect with SSMS - using "Active Driectory - Password" authentication.
I'm just never sure of exactly what things are called, so I don't not for certain which of the 10 bajillion variations of connection string I need to use...
Of course, this means I have to have my password in code shudder or prompt to provide it at run time
FDR, IMO, was one of the worst presidents ever because of his New Deal, his 4 terms, and his general management of WWII before we were officially involved--i.e. the lend/lease program. Not saying it was bad in itself, but it was expressly against what a large majority of the country wanted--he was running the US as if he was dictator.
@Hosch250 one thing i've never looked to read about... what was senate/congress doing at the time of FDR? guess i could see what kind of books pop-up for that topic. i have read a little on the checks and balances system during that presidency and the amount of "precedence" set for use of executive orders, etc., for circumventing that system
they always portray him as some kind of saint. It's not until you really get into college or reading good history books outside the school that you get to know who he was.
@Cyril That's the main weakness, IMO. The congress is habitually paralyzed and for that reason, presidents get much better images of being the benevolent and steady leader who rose to the crisis.
@this history books are written by the winners... i will say that back in the bush sr days my history teacher was pretty outspoken about executive orders and the gulf war, so we got some interesting tirades regarding LBJ, FDR, and the like
For example, he was unable to get the New Deal passed until he threatened to pack the court.
@Cyril I hate executive orders. From what I gather, they were barely used until the Civil war with Lincoln, and then they just got more and more and more prevalent.
IIRC, ever president since Lincoln has used more than their predecessor.
and with that, the later presidents seems not so bad in comparison. But that's a crappy comparison, since you can see that earlier presidents were in only one or two digits.
@this My understanding was Franklin Pierce was considered one of the first "bad guys" in office, by his contemporaries. he pissed off a LOT of people doing things that are still being fought over today
Grant followed up Andrew Jackson... who abused the F out of things, so I can imagine that Grant spent a bit of time with advisors drafting EOs to counter some of those antics until laws could be passed
@this i know most of my information from children, tbh. kids getting assigned presidents to report on, goign to their library to find books, talking to them about what they read
and grant was all "i just want more people to fight in the army" so he had to curtail all of the BS that accompanied Johnson's misuse of executive power
so he did almost all EO's in the first 4 months haha
so... looking up presidents and whatnot... i'm having a very productive day (i do have a lot to do, but man if this isn't more interesting)
oh, from the wiki, regarding A. Johnson: "Johnson implemented his own form of Presidential Reconstruction – a series of proclamations directing the seceded states to hold conventions and elections to reform their civil governments.
When Southern states returned many of their old leaders, and passed Black Codes to deprive the freedmen of many civil liberties, Congressional Republicans refused to seat legislators from those states and advanced legislation to overrule the Southern actions. Johnson vetoed their bills, and Congressional Republicans overrode him, setting a pattern for the remainder of his presidency."
and did not know it, but yeah... regarded as the worst president in US history
Funny, for the first several years, T. Roosevelt specialized in reconstructing the civil service rules. Then there was a series of foreign administration changes (Midway Is., Panama Canal, etc). Then in his last years, it was mostly parks and stuff.
@Hosch250 i will semi-misquote him... "business before pleasure, but never forget that ensuring those pleasures survive is an appropriate business" he then went on to set aside land for national parks refering to "reverence of the beauty is the greatest pleasure"
@Cyril granted but IINM, we had 2 party for the most of the country's life - the name of parties has had changed but it was mainly 2 parties, I think.
That said, one thing I understand is that within the party, things were much more fractured and tumultuous compared to today where they do much better job at making their peons toe the line.
splinter groups, example "new federalists", helped to swing votes. since wwii, the party-centric focus became engrained
e.g., the issue people have with mcconnel, where he controls what goes to senate as the "majority leader" was pushed after wwii because of FDR and agreement of a majority leader and the president
@this to an extent; those each started as splinter groups, and being in a splinter group was supported by both the existing party and the opposing party, presenting alignment for the represented persons
hence the "new federalists" comment
as a major party can 100% prevent something from being seen, party has become more important than representation
@Hosch250 hey, maybe you know a bit more than I do RE: WPF. I have this code:
public static void ChangeTheme(string theme)
{
Application.Current.Resources.MergedDictionaries.Clear();
// merge in the resource dictionary
Application.Current.Resources.MergedDictionaries.Add(
Application.LoadComponent(
new Uri($"/Rubberduck.Core;component/UI/Styles/{theme}{(theme.ToLowerInvariant().EndsWith("theme") ? string.Empty : "theme")}.xaml",
UriKind.Relative)) as ResourceDictionary);
This works initially; the correct theme get loaded. However, when that code is called again, the theme do get changed but only for newly drawn contents. For toolwindows that are already open, it still has the old theme.
I already tried adding InvalidateLayout() and UpdateLayout() on all windows, didn't make a difference. Any idea why it might not responding to the request to change?
Mind, all have DynamicResource binding so it should be doing so at runtime.
That's what puzzles me - it's should be all coming from the application's resource dictionary; I removed all the references to the theme XAML files in various XAML files.
Then, I built an image from my ASP.NET Core source.
Then, I tried to connect to the DB and run a migration at runtime with a specific endpoint on my web app, and it fails to connect. I get the same issue when I just try to connect and pull data--it's a failure to connect, not a schema mismatch.
VBA Rubberducking
VBA Rubberducking