Search SQL Database for Instances of Column Name
I needed to find where a certain column name was being used. Try this…
Category Archives: Software
SQL Cheatsheet
Multiple “Order By” Clause Separate the order by clauses with commas. Use “CASE” to Convert Non-String to String Value In this example, we want do display the SettlementType value (an integer) as a human readable value in a column named “Settlement”. Resulting SQL view. Update Row Value The basic command is: For instance:
Python Quick Tips for SoftPro Select Custom Order Rules and Automation Snippets
I keep a bunch of handy code fragments here so I don’t lose them. They are in no particular order. IEnumManager – Get IState, IBillCode, and Many Others You must use IEnumManager to get literally dozens of values that are come from lists that are either maintained inside Select (like IState) or are user editable (such as Bill… Read More »
Windows Special Folders
Windows uses an enumeration of special folder names to make it easier to find commonly used folders. Without this mechanism, we’d have to jump through a lot more hoops to determine this information since it is user dependent. I was trying to use a special folder as the root of a path for some common files shared by… Read More »
PowerShell Commands
File Search Related Operations Microsoft help on items in this section. Find Processes Get-Process (alias gps) allows you to get all running processes on your machine. It can also be used to create a filtered list. Find all processes with name that matches “mmc”. We are looking for an exact match so don’t need double quotes. All of… Read More »
Create Select Order on Server
The code below demonstrates how to create an order on a Select Server. The primary difference between clients and servers is that clients are created by a login process that provides a user and profile. Servers do not have profiles by default. Any order created by a Server will show up as created by “System”. I must make… Read More »
Use CancellationToken to Make Responsive Thread.Sleep() Wait
Using a time delay based on a Thread.Sleep() is truly easy. However, if you need a pause inside code that is using a CancellationToken, be aware that if the CancellationTokenSource calls the Cancel() method, Thread.Sleep() will ignore the request. CancellationToken Aware Sleep() In the example below, we get the WaitHandle from the token and pass in delay time… Read More »
Delete Git Branches in Azure that are Protected by Branch Policies
We use Git feature branches that are protected by policies that force deletion to occur via Pull Requests. I want an easy way to delete them after a squash commit. This is the best way I found. Of course it assumes you have permission to make the required change. Step 1: Change your permissions Step 2: Delete branch… Read More »
Run One-Time Adminstration Task when Installing Application – EventLog Source Name
I want my C# executable to write to the Application event log using a custom Source name so I can quickly find my events. My application must run under non-admin credentials but creating a custom log name requires administrative credentials. Since I also want to install everything with an Inno-based installer, I can use the period of time… Read More »
Where Does the Select Application Keep Your Default Select Server URL?
There are several ways to change the default Select Server your client application automatically logs into when you start Select. The typical way is hold down SHIFT+CTRL just after you double-click the Select icon on the desktop and wait for the program icon to appear in the taskbar. Then release the keys and you can use the popup… Read More »