Posted by jpluimers on 2020/11/12
Reminder to self: finish the script that initiated this 2013 question (yes ages ago!) [WayBack] powershell – Format-Table forgets some properties, but Format-List shows them all. Why? – Stack Overflow.
The question was based on code I was really happy I saved in the WayBack machine: WayBack: how-to: Print/List installed programs/applications sorted by date | Tech Off | Forums | Channel 9
So here the question and the answer.
Posted in .NET, CommandLine, Development, PowerShell, PowerShell, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/11/12
A few tips.
procedure _AbstractError; begin if Assigned(AbstractErrorProc) then AbstractErrorProc; RunErrorAt(210, ReturnAddress); end;
procedure AbstractErrorHandler; begin raise EAbstractError.CreateRes(@SAbstractError); end;
ClassName that has “Allow side effects and function calls” enabledClassName:
if it becomes [WayBack] E2003: Undeclared identifier: 'ClassName', then:
static, but it is actually inside a class, then remove the staticSometimes you cannot perform the last step: class property definitions have to be backed by static class methods.
This usually means you have a bad design anyway: you depend on global/singleton kind of behaviour that is almost impossible to properly test.
A better approach is to have regular object instances for that, then use constructor dependency injection (maybe combined with factory or dependency injection container) to setup the structures of dependencies.
Create a conference summary on the use of class versus instance methods, and static/regular.
Base materials:
–jeroen
Posted in Conference Topics, Conferences, Delphi, Development, Event, Software Development | Leave a Comment »
Posted by jpluimers on 2020/11/11
Excel date times are almost identical to OLE/COM automation date times (that used in many Windows applications).
Which means that dates are 1 unit apart, and:
That way you can easily add one hour to a date/time value by adding 1/24.
Source: How to quickly add hours/minutes/second to date and time in Excel?
Related:
–jeroen
Posted in Development, Excel, LifeHacker, Office, Power User, Software Development | Leave a Comment »
Posted by jpluimers on 2020/11/11
Sometimes you are in search of a real TAB character, as most editors (except a few like the ones for Golang) I bump into are space-based. A great answer at [WayBack] visual studio code – VSCode insert tab character manually – Stack Overflow:
Quick-and-dirty solution: Find a tab somewhere else, then copy-paste.
Chances are that you already have a tab character in the file you are editing, but if not you can generate one in another application or text editor.
You can also generate a tab programmatically in a bash shell with the following command (the brackets are optional):
echo -e [\\t]For your more immediate needs, I have inserted a tab character below…
There is a tab character between these brackets: [ ]
–jeroen
Posted in Development, Software Development, Visual Studio and tools, vscode Visual Studio Code | Leave a Comment »
Posted by jpluimers on 2020/11/11
Still not sure why the RTL code is like this:
procedure TRemotable.SetDataContext(Value: TDataContext); begin if (RemotableDataContext <> nil) and (RemotableDataContext = Self.DataContext) then begin TDataContext(RemotableDataContext).RemoveObjectToDestroy(Self); end; FDataContext := Value; end;
It means that if you ever have to change the DataContext property from the default global RemotableDataContext, it will be removed, but not added to the new DataContext.
When you assign it nil (so you can dump it to JSON, which often is easier to read than XML), and back to the old value, this results in a memory leak:
function TNotificationKeyPortTypeImplementation.prematchChanged(const prematchChangedRequest: prematchChangedRequest): prematchChangedResponse; var DataContext: TDataContext; begin // ... DataContext := prematchChangedRequest.DataContext; try prematchChangedRequest.DataContext := nil; // otherwise the JSON serializer will stackoverflow because DataContext points back to the TRemotable instance. Result := Format('prematchChanged: prematchChangedRequest=%s', [TJson.ObjectToJsonString(prematchChangedRequest)]); finally // `prematchChangedRequest.DataContext := nil` removed `prematchChangedRequest` from `DataContext.FObjsToDestroy` DataContext.AddObjectToDestroy(prematchChangedRequest); prematchChangedRequest.DataContext := DataContext; // does not add `prematchChangedRequest` to `DataContext.FObjsToDestroy` end; end;
or when you are outside an incoming SOAP call where DataContext might not be assigned at all:
function ToJSON(const Value: TRemotable): string; var DataContext: TDataContext; RemotableDataContext: Pointer; begin if Assigned(Value) then begin DataContext := Value.DataContext; try Value.DataContext := nil; // otherwise the JSON serializer will stackoverflow because DataContext points back to the TRemotable instance. Result := TJson.ObjectToJsonString(Value); Result := TRegExSanitiser.ReplaceSecretInText(Result, [rttJSON]); finally // `Value.DataContext := nil` removed `Value` from `DataContext.FObjsToDestroy` if Assigned(DataContext) then begin RemotableDataContext := GetRemotableDataContext(); if Assigned(RemotableDataContext) and (RemotableDataContext = DataContext) then DataContext.AddObjectToDestroy(Value); Value.DataContext := DataContext; // does not add `Value` to `DataContext.FObjsToDestroy` end; end; end else Result := ''; end;
–jeroen
Posted in Conference Topics, Conferences, Delphi, Development, Event, Software Development | Leave a Comment »
Posted by jpluimers on 2020/11/10
Two interesting sites to ease transforming JSON fragments in log-messages to a table system, for instance Excel.
Custom format ##0.00E+00 that just shows the exponents in multiples of 3 (so kilo, mega, giga, etc)[WayBack] formatting – How can I format bytes a cell in Excel as KB, MB, GB etc? – Stack OverflowThis way I copied the example code into adjecent Excel areas, so I could compare the values and calculate memory increase of a Delphi application.
—jeroen
Posted in Development, JavaScript/ECMAScript, JSON, LifeHacker, Power User, Scripting, Software Development | Leave a Comment »
Posted by jpluimers on 2020/11/10
I didn’t know there were multiple ways to push to multiple remotes.
[WayBack] github – Git – Pushing code to two remotes – Stack Overflow is intriguing as the accept answer shows one remote can have more than one URL, and you can push to all of them at the same time.
Most people just have multiple remotes with one URL per remote, and have a branch optionally track one remote brach: [WayBack] How can I tell a local branch to track a remote branch?
The other way around: you can find out which branch track remote branches as well: [WayBack] git – Find out which remote branch a local branch is tracking – Stack Overflow
–jeroen
Posted in Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management | Leave a Comment »
Posted by jpluimers on 2020/11/05
Cool post: [WayBack] Register and use a custom clipboard format in Delphi – twm’s blog.
It is about transmitting GPS (WGS 84) coordinates from one program to another via the clipboard.
One day I will find some time to dust off some draft clipboard posts that I have been dormant for too long.
These already got published:
Via [WayBack] I just now had the need to transmit GPS (WGS 84) coordinates from one program to another. First, I simply copied longitude and latitude separately using… – Thomas Mueller (dummzeuch) – Google+
–jeroen
Posted in Delphi, Development, Software Development | Leave a Comment »
Posted by jpluimers on 2020/11/04
Out of the box, Visual Studio Code does allow you to pull from and commit/push to git repositories, but it has not much more git support.
These two marketplace extensions will help big time:
I like GitLens most as it covers so much more than just git history.
If you only need git history access, then you can use Git History as well.
More information and a better comparison:
–jeroen
Posted in Development, DVCS - Distributed Version Control, git, Software Development, Source Code Management | Leave a Comment »
Posted by jpluimers on 2020/11/04
Multi-WAN routing always involves marking incoming connections to the replies go out on the same connection: [WayBack] Mikrotik Remote Access via Multiple WAN Links | Syed Jahanzaib Personal Blog to Share Knowledge !
# Mirkotik IP Firewall Mangle Section/ ip firewall mangle# Mark traffic coming via WAN-1 linkadd chain=input in-interface=WAN1 action=mark-connection new-connection-mark=WAN1_incoming_conn# Mark traffic coming via WAN-2 linkadd chain=input in-interface=WAN2 action=mark-connection new-connection-mark=WAN2_incoming_conn# Mark traffic routing mark for above marked connection for WAN-1 , so that mikrotik will return traffic via same interface it came inadd chain=output connection-mark=WAN1_incoming_conn action=mark-routing new-routing-mark=to_WAN1# Mark traffic routing mark for above marked connection for WAN-2, so that mikrotik will return traffic via same interface it came inadd chain=output connection-mark=WAN2_incoming_conn action=mark-routing new-routing-mark=to_WAN2# Finally Add appropriate routes in ROUTE section/ ip routeadd dst-address=0.0.0.0/0 gateway=1.1.1.2 routing-mark=to_WAN1 check-gateway=pingadd dst-address=0.0.0.0/0 gateway=2.2.2.2 routing-mark=to_WAN2 check-gateway=ping
Related:
–jeroen
Posted in Development, Internet, MikroTik, Power User, RouterOS, routers, Scripting, Software Development | Leave a Comment »
The Wiert Corner - irregular stream of stuff 