> **What** Flag where `:` is used to separate statements as a code quality issue.
**Why** Unlike other languages, C# as an example, VBA doesn't allow declaring and assigning variables on the same line. Using `:` is putting a round peg in the square hole. While syntactically it is valid it can hide issues with code and you're essentially fighting against the language. Having a line for declaration and subsequent line for assignment keeps code from being "cute" and squashing those potential b
@MathieuGuindon I think that link must be outdated - it's from 2016. Net core has targets for x86 and x64, so I think bitness has been addressed. I need to investigate some more, as the sample project runs fine for me - oddly, regsvr32 on SlimDucky reports success, but doesn't appear to actually register anything (need to regmon to confirm) - I had to register all the class/prog ids key by agonising key just to get office to even try and load it...
I have a feeling its something dumb I'm doing / not doing, just not clear what atm.
I've stripped out everything from slimducky except stubs for IDTExtensibility2, so really the only difference between my project and the dotnet sample is that they define their own COM interface, whereas I'm importing IDTExtensibility2...
> He said pure functions, not immutable objects. A non-trivial program can't be exclusively composed of pure functions, however that doesn't take away the value of having as many as possible.
LOL, tell that to the Roslyn team...
The compiler is 100% pure functions from top to bottom so they can parallelize it.
Having weird issues with SSIS - I can't drag n drop from the toolbox to the design area. A double-click will place the item there, though. Once it's there, I can't drag it to a new location.
It could be because I'm RDP to my work machine from home. That an issue anyone's run into?
I know I don't get any hover-text in a web browser when I'm RDP from home, so there may be some "issues".
I am using this code which works fine, but runs painfully slow.
The code filters an Excel Table and then extracts only certain columns and pastes them into another sheet (in a different order).
Could it be sped up perhaps with a multi-dimensional array?
With Application
.ScreenUpdating = Fals...
A decimal separator is a symbol used to separate the integer part from the fractional part of a number written in decimal form.
Different countries officially designate different symbols for the decimal separator. The choice of symbol for the decimal separator also affects the choice of symbol for the thousands separator used in digit grouping, so the latter is also treated in this article.
Any such symbol can be called a decimal mark, decimal marker or decimal sign. But symbol-specific names are also used; decimal point and decimal comma refer to an (either baseline or middle) dot and comm...
If I need to import a variety of files all of the same format, but with different file names, I can develop the SSIS package with one of them as my example, then parameterize the name later, correct?
I had that at a previous gig... back in 2013... the code-behind wasn't any better. everything happened in the control's constructor - spawning COM objects, connecting to & querying the database, pulling the results, ...no data bindings whatsoever, and all hard-coded margins.
Yeah I know about the partial class and I don't think it's pretty to look but AIUI, whenever we messed with it, it regenerated the entire partial class, so I think that avoided the ugliness you would get if you DnD'd into a XML-based markup
I'm just about ready to pop between trying to fix some crap left behind by the ancestral devs here and getting tickets "An error has occurred" with no reproduction tips in it.
@this As far as it goes, I couldn't stand the DnD editor in WinForms. I'd just edit the class.
I'm going to ask about Git, ASP.NET MVC, knockout JS or angular/react/other JS UI frameworks, security, accessibility, DI, unit testing, OOP/FP/general paradigms, C# 8 development.
@RubberDuck aye - been meaning to get extensive xml-docs for all inspections for quite a while.. figured I'd just bite the bullet and do it.. and when that was done and I got to parse the xml and generate the inspections page I decided I wanted syntax highlighting for the code examples - and that was fun :)
@RubberDuck I think all that's preventing it to work with Core is the Rubberduck.Parsing and Rubberduck.SmartIndenter dependencies
the indenter could easily be ported. the parser.... not so sure.
I've been thinking about the column header ordering for the ToDoWindow. The setup done by CastleWinsor has me newing up 2 instances of the HeaderOrder. Does it make sense to have a static singleton that can be called to access the same instance for both locations?
also no, a static singleton doesn't really make sense - if you want the same instance injected, you need CW to register it with a "singleton lifestyle", i.e. the same instance is injected everywhere it's requested
singleton is the default though
(with Ninject it's "transient"; each client gets its own instance)
possibly the registration for it is being done by a rule that changes the lifestyle to something else
Can't figure out how to supply a single instance to both locations. One is new'd up via default settings in ToDoListConfigProvide. The other in ToDoExplorerViewModel is supplied from _columnHeadingsOrder = _configService.Read().UserSettings.ToDoListSettings.ColumnHeadingsOrder; which is New'd up on deserialization.
I'll have to refresh because of the long weekend. I didn't think a singleton would be a valid use for it either.
SSIS question: I'm working on importing survey results. Row 1 of my data is the Question ID. Row 2 is the initial 50 or so characters of the question. Rows 3-x are the answers.
In the Flat File Connection Manager on the "Preview" page, is a "Data rows to skip" option. If I change that from 0 to 1, it doesn't show me the question text. I believe that this applies only to the preview, though, not to the actual data import. Is that correct?
How do I get the import to skip the 2nd row of the file, the 1st row of "data" which isn't, in this case, actual data?
Currently, I'm adjusting that row in my VBA code before importing in an attempt to get it to get the wide columns (>255 characters) without truncating, so I could remove it in code before calling the SSIS package to import, but I'd be happy to have SSIS do it for me if it can.
I am working on updating the UI/UX of a 20 year old application and I seem to be stuck at this particular use case.
On clicking on the New button, the system asks the user to choose one of two options
Create New Work Order
Create new Task/Subtask for a pre-existing Work Order
Keep in mind t...
Sure, good questions. When I intereviewed some time ago, I found they don't even know the basics. They can shoot off all acronyms but when it comes to forming a basic HTTP request, they're like ".... I use a browser."
if they don't even know what a raw HTTP request/response look like, then how would they be expected to troubleshoot even most rudimentary errors?
It is true that one could get away building web apps with only C# (or maybe even a bit of CSS / JS sprinkled in), but when it comes to troubleshooting, they better know how a HTTP request/response look like
At least that's what I think - I honestly I don't think I was really effective at troubleshooting problems until I actually got to learning how to use telnet/Fiddler/Postman.
I am writing VB code in Excel to calculate the distance between an employee's home address and work address using Bing Maps API calls. The process follows this general flow:
1) Convert the employee's address to Lat-Long values using the GetLatLong function
2) Convert the employee's work address...
> Excel 2013+ seems to have a bug such that if you Freeze Panes and zoom in so that the freeze line is out of sight it starts to recalculate the worksheet's display constantly thereby causing high CPU load. In order to limit the scroll area and keep the battle fields on display use the worksheet property ScrollArea and limit to $A$1:$AF$32 as in the attachment. [Excel2013up-bug_frozenPanesOutOfSight.xlsx](https://github.com/rubberduck-vba/Battleship/files/3229740/Excel2013up-bug_frozenPanesOut
Working on the ToDoListSettings.ColumnOrdering issue. I have it serializing and deserializing as expected. When I display the ToDoWindow the order isn't according to the DisplayIndex I'm expecting.
SELECT
ISNULL(SUM(IIF(i.foo IS NOT NULL AND i.bar IS NOT NULL, i.qty, 0)), 0) - ISNULL(SUM(IIF(d.foo IS NOT NULL AND d.bar IS NOT NULL, d.qty, 0)), 0)
FROM inserted AS i
LEFT JOIN deleted AS d
ON i.ID = d.ID