why does designer love to yell The component 'Rubberduck.UI.Controls.LinkButton' does not have a resource identified by the URI '/Rubberduck.Core;V2.5.0;component/ui/controls/linkbutton.xaml'?
If I load the control itself, it's OK.
It's only when I load it through another control (e.g. Code explorer's xaml), it freaks out
I'm using an instance of WPF's Application and it seems to let me replace the existing Dispatcher.CurrentDispacther.Thread.CultureInfo with Application.Dispatcher.Thread.CultureInfo
However, I think I need to have the Application stay alive even if the addin get unloaded, based on the answers in this SO thread
Looks like just simply not shutting down the application get the same behavior we had, good.
@this a bit of brown mustard and a slice of Provolone cheese might make it tolerable...
@Duga wait... didn't you just do that?
Duga: I heard you're indecisive, darwinaliasoft
darwinalisoft: No, not really. Well, maybe, a bit. Wait, no, no I'm not! Umm... I'm not sure...
Ran into an issue with my production data load yesterday morning. I worked around it to get data loaded yesterday, but today, I'd like to nail down the issue and have a programmatic workaround if possible.
I issued my REST call and got some XML data back. Fed it into the stored procedure as normal and got this back
> Source: Microsoft SQL Server Native Client 11.0 Error Num: -2147217900 Description: XML parsing: line 1788, character 16, incorrect CDATA section syntax
I just pulled the data from yesterday again (by hand) and looking at line 1788 of the XML, I see this:
> <customer_id>30177</customer_id>
Character 16 is the > in <customer_id>
?asc(">") ->> 62
which, according to asciitable.com is a legit >, not some funky unicode character that only looks like a greater than sign.
Any idea why SQL Server would complain that a closing > is (or creates, or... whatever) an incorrect CDATA section?
The line above it is <globalId><![CDATA[b4fe957761520a39c0ac8d93a5617f66eeaddcdb4b08b387c9bbe7436ad05d31]]></globalId> which looks like a validly formed CDATA to me
and the line below is <account></account> which doesn't have a CDATA section either
Of course, some better error handling will allow me to trap errors like this then decide if I wanna continue processing or abort, instead of failing to catch the error until much higher up the call tree, logging and bailing...
@this i thought it was possible to change the settings of the Editor Format with a theme? E.g., the "foreground", "background", and "indicator" for Normal Text. I have seen the VBIDE accept some application colors, but the actual color of the modules, normal text, comments, keywords, etc., would still need to be set via a theme or individual settings
i believe you can download themes individually, to allow you to have editor format colors that aren't standard, but just providing a theme option using the standard colors could/would be nice, because going through and individually changing kind of sucks
i remember the first time i did it i had to make many adjustments to keep straight which was a "keyword" compared to "identifier"
now i'm working wiht black background with hot pink keywords and white indicators, where normal text is green... much more visually appeasing to sit in front of for hours compared to the white background wiht black text
i havne't figured out how to change the color of the dock background/text
@this that was part of the much larger XML dataset that was passed in as nvarchar(max) then SET @xmlStream = CAST(@inputStream as xml) and @xmlStream is what was chewed on as it was inserted into #TempTable.
according to this they don't have to be escaped in the CDATA
weird. looking at it I don't see anything that's obviously malformed. Unless, of course, there is some weird unicode character in there that looks like English but isn't.
but, even at that, since it's an nvarchar CAST to XML, SQL Server ought to handle even unicode, should it not?
I believe this is property versus function. debug.print now() will return a system setting formatted date, which is a property inherited by Excel. If I use a native function, without specific formatting, I will get the standard English output. The use of worksheet.function in VBA is being treated as referring to the standard Excel format, not the same as being in a worksheet and using the format. — Cyril2 mins ago
that is in relation to local returns versus english returns for things like format "ddddd"
I think that's a solid foundation, property versus function, as to when excel chooses which to display. Does that hold water with anyone else?
@FreeMan unicode shouldn't be the issue. Pretty sure you're not looking for a funky character but for a malformed CDATA.
@Cyril I stumbled on that because when the author says "function", the author means the functions used in Excel formulas, and not VBA functions, right?
@this All the ones I've looked at were most definitely of the form <tag><!CDATA[the text]]></tag>. I suppose that there could be a missing > or </ or something somewhere that's getting the parser out of sync.
the weirdest part is that it failed when called programmatically, but worked just fine when I pasted the data into a modified version of the CREATE PROC code.
that's the part that sorta had me thinking funky character. Maybe something VBA couldn't properly handle.
Yet, I simply executed a LogManager.Log statement in the immediate window to get the entire returned string into my log, opened the log with N++ and pasted the results into SSMS...
and, the translation through N++ may have cleaned something up.
> Participating on this stack, these days, feels a lot like going to an amusement park and walking out of the bathroom, only to realize that they've closed up shop...the lights are still on but everyone is gone and the last bus is leaving.
woot, confirmed: yesterday's SqlException was because I was passing a SqlConnection to sub-components, which themselves passed that connection to sub-components, which themselves...
i don't feel the profiles give the same "meaningful" impact; seeing that you reached 90M people, versus you've got 100M karma is significantly different
i would say a big plus, which i WISH the r/vba would use, is to modify their required inputs for the subreddit to leave space for A) the title, B) the background, C) the issue, D) the question, and E) the related code. SE/SO have outright said they don't do that because it affects otehr stacks, when /r/ has the ability to be more customizable
if you don't fill out all aspects, the mod/bot unlists your question until you can fix it
@MathieuGuindon Some groups would shut that down really fast.
Each subreddit can define their own rules beyond the basic ones Reddit requires.
And I agree. SE's primary thing was long-term visibility for the topic. But now that helping people is more important than providing a database of knowledge where people can help themselves, it's just not got the same impact.
OTOH, I finally sent this video to my dad from forwarding me irrelevant newspaper articles:
the amount of folks that just rip off code from an existing post, link to that post as the source of the code, and asking what to change to make it fit their scenario is already too high. if a bot-writing service existted, they'd just link to that to have someone explain what happened... then help them modify it
Assuming U.S. Jurisdiction:
In the case of the The People vs. Hansel and Gretel Holztfaller:
Ms. Gretel Holztfaller is charged with the following:
1 Count of Murder in the First Degree (Murder of Ms. Witch Hazel)
1 Count of Grand Larceny (Theft of precious metals and jewels from Ms. Hazel)
1...
gets "System.InvalidOperationException: Invalid operation. The connection is closed" in the logs, wonders what's wrong. runs app through debugger, sees command.ExecuteNonQueryAsync running against a connection that was never opened.
"don't deploy on Friday" isn't happening today lol
@Ze'evwantsSEtodoteshuva That popped into my head, too, but I'm not so sure. Attractive nuisance would hold the witch liable if the gingerbread roof collapsed on the children, for example, but I'm not sure that it absolves the children of their trespass or vandalism. The gingerbread house is attractive, yes, but there is no "nuisance" that would threaten to harm child trespassers. The source of danger is the witch herself, but people do not fall under the attractive nuisance doctrine. The house itself caused no injury whatsoever. — Nuclear Wang27 mins ago
the docs implies that for it to be effective, the client has to be configured accordingly (e.g. actually putting the results on separate threads or whatever)
i lived there for 6 years; even when that guy started the fire and was shooting at firefighters, it was a "quiet" day for Rochester as a whole. was a weird time
yarp; we were supposed to go over that way, but it was all blocked off by the police... so much for christmas eve!
@MathieuGuindon i'm always surprised by how often those moments happen... "i was there like a week before" or something related when awful thigns happen
i think my browser is f'ing up, @BigBen voted to close something, the menu never went away to "accept" my vote, so i closed the tab. came back to that question later (clicked on it in the list of unanswered questions) and my vote registered. i made a comment saying i voted to re-open as the person made an edit after my vote registered... closed tab re-opened tab (ctrl+shift+t), made another comment about what the confusion was and when i submitted that, my other comment went away... ctrl+f5 refreshed and it stillw astn't there
no, the usual scenario is something like the following: "we want to create our custom categories but if you use category ID = 2 we require the application to have some special logic around it"
as for enums... I'll still have the Id column be a PK/identity, with a Code column holding the NK/lookup value. that way all joins are off a simple int identity PK, and if/when NK is relevant, it goes against an index.
you actually hit on where i was going with the "helper" column. I was going to ask if SQL had a predecessor-field, where you can indicate reference to logic
acknowledge a predecessor, in this case the call to a specific view for this line, execute said view, then return to the previous view on the next line.
i believe i'm trying to rehash my understanding of valueset predecessors in xml
essentially you check a predecessor (an ID written to a helper column) and use the style of the predecessor for the current field
ok, rabbit-hole turned up soemthing related to what i was thinking and i was totally off-base. css checking style of another field (can defined preceding current task, inheriting a style), not the same as a style sheet, but an actual reference my bad... should just stay out of SQL topics
also: re keys - I've mostly seen people add identity to every table because #reasons. at a high level, it makes sense to choose a key strategy that meets the use-case, whether that's identity, guid, chosen, compound.... wth that does to query plans though, who knows. sql is voodoo... I know compound is probably not a winner.
I'm just glad that most of my work is front and (especially) middle. data tier is just storage to me atm, and that's how I like it.
@MathieuGuindon I remembered something else - if you use a separate column, don't you end up with queries like SELECT ... FROM Bar INNER JOIN Foo ON Bar.ID = Foo.ID WHERE Foo.Code = 'DoSomethingExtraSpecial';?
but, my schema was meticulously created with a NK/unique constraint, an int identity (1,1) PK, and any other non-clustered index queries might need, for all tables
The client's schema did have the appropriate indices; the issue was that there were lot of people hitting the same part of tables' contents which translated into slow application performance. No errors, mind you. Just annoyed users staring at the hourglass getting slower and slower.
Once we moved it into an indexed view, that released a lot of pressure because they no longer had to go to the main table which was getting slammed all the time, IIRC.
@this well, yes. but my I can see roughly how my code relates to what the CPU will do. Having to learn which magic incantations I have to chant to get a particular DBMS to devise a non-stupid plan is an abstraction too far for me.
Assuming U.S. Jurisdiction:
In the case of the The People vs. Hansel and Gretel Holztfaller:
Ms. Gretel Holztfaller is charged with the following:
1 Count of Murder in the First Degree (Murder of Ms. Witch Hazel)
1 Count of Grand Larceny (Theft of precious metals and jewels from Ms. Hazel)
1...
VBA Rubberducking
VBA Rubberducking