Wow. Class before mine is going over git and GitHub. “Here’s a gitignore fire and it’s used to...” This feels so surreal knowing everything he’s lecturing on.
This pond is so awesome for its willingness to share its knowledge. Freely and without the express requisite for PR.
I had a bug where the IEvaluatableNode extended nodes were treated as statements to be iterated as part of the body of an IBranchNode.... that was causing dupes and throwing off the position
public string inputCode = @"Option Explicit
Public Sub DoSomething()
Debug.Print ""In path 1""
If True Then
MsgBox ""hello from path 2""
Else
Debug.Print ""hello from path 1""
End If
End Sub
";
and since I've just filtered for the IExecutableNode descendants, I'm not even seeing the child IBranchNode nope, IBranchNode : IExecutableNode
just write the damn test and run it already
[Test][Category("CodePathAnalysis")]
public void ElseBlockIsCodePath()
{
const string inputCode = @"Option Explicit
Public Sub DoSomething()
Debug.Print ""In path 1""
If True Then
MsgBox ""hello from path 2""
Else
Debug.Print ""hello from path 3""
End If
End Sub
";
var paths = GetCodePaths(inputCode);
Assert.AreEqual(3, paths.Count());
}
ugh I think I'm too tired to tell if that's what I want or not no, it's clearly wrong
the CallStmt is the MsgBox
so, I need to ExitExecutionPath when I enter an Else* statement
ah, and I need to handle the else block specifically because I don't get a Context for it
and since each IBranchNode needs to know how to traverse its own specific children... I think I'm going to add me some CodePath[] IBranchNode.GetCodePaths() or something
@M.Doerner I carry the assignment metadata (just the last assignment, for each assignment target) from the current path into the newly entered path, so when there's a use of foo in the path (but no assignment), I can still get the IAssignmentNode it needs to go against, without needing to work out where foo came from and where it was last assigned
Thinking about monetizing it, I think it would be 1) free to the public, 2) paid for organizations (and get access to an organization structure), 3) people can create their own sets of training material and either pay to keep it private or charge others a fee to use it, and I get a part of that fee.
#2 is even more exciting.
Making an HTML Grid UI that transpiles to normal HTML with CSS grid.
Because it's short-term gains (after 1-2 years, max, I'm planning on buying a house with mostly cash), I'm looking more an insured bonds. I have $40k to invest, and will keep $20k (not counted in the $40k) in the bank for an emergency. But the bank has horrible interest rates.
Technically the answer is yes to the both, although I plan to pull it back out after a year or two (not sure exactly when yet).
It would be a huge disappointment to lose it, though :P
But quite simple really. You don't want it in the stock market, and you probably don't even want it in the bond market, though that may depend what interest rate your bank offers you.
@Hosch250 As far as bonds go, we currently use this as our relatively-safe better-than-cash option. It's short-dated pretty safe corporate bonds. Yields all of 2% a year (probably 1.5% after you've paid management fees), and can potentially lose money though not too much (at the depths of the 2008 crash, I think it was only down 8%).
Probably better just taking a term deposit with a bank for whatever you can get, given the timescale.
@Hosch250 Yeah, big thing of course is making sure you definitely won't need the money in the meantime, but otherwise it's a pretty good match for your situation.
Definitely won't. If I need more than $20k, I can pull a loan. And the only thing I have worth that much is my car, and insurance would cover a good chunk if I got it wrecked...
And I'm on two insurance carriers (my dad's covers me until I'm 26, and I have my own too), so health bills are pretty low.
@M.Doerner the path also knows the foo=1 assignment isn't one it its children; so I can trivially get all assignment nodes under a path, and know whether, where and how a value was assigned prior to entering that path - which makes it easy to track everything off a flattened structure...
@Hosch250 This probably isn't the chatroom for it, but suffice to say that I think the whole thing is a complete and total fraud with gigantic debts and burning cash at a rate that could bring the whole thing crashing down any day.
And I say that as a fan of SpaceX. Check out $TSLAQ on twitter if you're interested in reading more about it.
Saw an amusing post this morning that San Jose is testing a few Teslas as patrol cars. One ran out of juice during a chase. Turns out they forgot to charge it over night. Granted an ICE can run out of gas, too, but if you forget to fill up at the start of a shift, it's a 5-minute stop to top up the tank at some point during the day, not "I hope I make it back... I hope I make it back..."
@Hosch250 I don't really have the time to go through it right now, but I do recommend searching that tag on twitter, or just follow @teslacharts and you'll get a pretty comprehensive summary.
Though bonus points if you can figure out which twitter account is my TSLA burner ^^
> sorry, for komplett information: Version 2.4.1.4954 Betriebssystem: Microsoft Windows NT 10.0.18362.0, x64 Hostprodukt: Microsoft Office x64 Hostversion: 16.0.11929.20254 Hostprogramm: EXCEL.EXE
@FreeMan FWIW, though I don't really like not naming parameters in call sites. Therefore, I'd prefer doing stuff like:
EXEC dbo.foo @bar = DEFAULT;
Have been burned one too many times trying to troubleshoot a misbehaving stored procedure that does EXEC dbo.foo 43, 'hi', @someRando, 53, @otherRando between different environments...
> I think the problem here is that a change of the document name actually does not trigger any event the VBE API exposes. The name of the document is not part of the actual project name; we just display it for convenience.
Das Problem hier ist voraussichtlich, dass der VBE uns nicht mitteilt, dass sich etwas geändert hat. Der Dateiname ist eigentlich kein Teil des Projektnamens.
The cached "display name" of a project is not getting updated. This is a very tricky case of cache invalidation, because as the comment indicates getting this information from the host document involves annoying side-effects. Because the VBE doesn't tell us when the host document is saved (or renamed), our
The cached "display name" of a project is not getting updated. This is a very tricky case of cache invalidation, because as the comment indicates getting this information from the host document involves annoying side-effects. Because the VBE doesn't tell us when the host document is saved (or renamed), our
> That said, we do have support for `IHostApplication`, which in theory can be extended to provide a mechanism for acquiring the current document name, which definitely will require separate implementations for each host's object model. Furthermore, not all hosts expose an event that can be used to know that a document was renamed which means we cannot be notified in all cases anyway.
I seem to recall someone at a point suggesting using a `FileWatcher` which would enable a host-independent ma
> Can of worms indeed! I'd prefer the `IHostApplication` approach, much fewer moving parts... besides if we only implement Excel, Word, and Access, we'll already cover 99% of the needs. A `FileSystemWatcher` would be something we would use, say, to detect changes to code files made outside the editor (and prompt to reload/replace the code file), say, in VB6 (or, in VBA, in a source control / repository scenario).
Plus `hostApp.ActiveDocument.Name` might be a COM hit, but it shouldn't involve
I've got a stored procedure that shreds an XML file, stuffing everything into a #tempTable with all columns nvarchar(255). It then does a MERGE into the primary table. I'm running into a variety of source data that isn't valid (like DOB = '1961-02-29') which causes the whole thing to bomb.
Is there any way to catch & report on those records that may have invalid data while letting the rest of the merge run to completion?
Note: the Merge does the appropriate, explicit Cast( ... as ...) before stuffing into the permanent table
@FreeMan my ETL involves dates stored in 6-character strings, and some are invalid: I wrote a function that takes that string and outputs either a proper DateTime value, or null
OK. will have to live with this for the next couple of days then. Have to get the whole thing into production by 1 Oct. Then I can get back to cleaning up. This shouldn't be an ongoing issue (I hope), and I can manually tweak as I'm manually backfilling data...
Anyway, that's one nice bonus about SSIS - it handles the error rows for you out of the box but in a sotred procedure, you're doing it in a sets, not row by row
the Invalid approach let you keep doing it in a set-based manner
Just discovered that the guys down the hall (no, Mug, not the Kids In The Hall, sorry), have an SSIS add on that allows it to grab data directly from a REST API. Wish I'da known...
> I think we can even enhance this quite easily by first trying to get the filename. That will fail for unsaved files, but then we can still fall back to the displyname.
IIRC, comintern went with the display name because getting the name via COM required iterating the properties of the COM object, which takes ages. This change saved a significant amount of time per reparse.
potentially stupid question... I've got a query that returns a bunch o' columns - essentially a report. I have the option of handing over the query or making an sproc out of it so it can be scheduled to run a daily data extract for FTP to a 3rd party.
an sproc really isn't suited for returning a large set of columns like that, I'd really want a table-valued function, right?
> Just installed Telerik Fiddler, and noticed this in the license agreement:
> On startup, the Software anonymously checks for new versions; you may disable this feature if you prefer. You may opt-in to submitting anonymous data about your system configuration and use of the Software to help improve future versions of the Software. If you opt-in, Telerik may collect data related to: certain features and extensions of the Software, identifying trends and bugs, activation information, usage sta
VBA Rubberducking
VBA Rubberducking