Author: Arnor Baldvinsson

Author Published on Leave a comment

I recently had a situation where a program had a file or a folder locked and I had no idea what program that might be!

I needed to restore a folder from a Macrium backup but I didn't want to just overwrite the folder, so I wanted to rename it.  But I wasn't able to do that because some processes had a folder or file locked in there.

After some search, I found an answer that didn't need any additional software to be installed, but rather use a tool that has been in Windows for several versions.  The Resource Monitor!  The answer can be found on Superuser.com

Run the Resource Monitor, then go to the CPU tab, and expand the "Associated Handles" panel - see the screenshot below.

Click the checkbox next to "Image" at the top of the "Processes" list and it will select all the processes in the list.

The "Associated Handles" will then fill in - it can take a few moments if there are a lot of processes running.

You can then sort and filter the list to narrow it down to what you are looking for, see the screenshot below.

Here I have filtered it to show "C:\" so it will show any files on the C:\ drive that are locked.  I also sorted it by the "Handle Name" so it is easy to find based on the path.

You can also find services, sessions, registry keys etc., so this is a very easy way to find things.  For more powerful options, using Processs Explorer from SysInternals/Microsoft has more options and is also 100% free and certainly an excellent tool along with Process Monitor.

Author Published on Leave a comment

We will be out of the office for the next couple of weeks or so.  We are helping our daughter move.   We will be driving a lot and may not have a good internet connection most of the time, so please be patient with us getting back to you 🙂

If you need support, please use our support popup on the website or email us at support at icetips.com.

Author Published on Leave a comment

We are going to be on vacation from today, September 10th to Wednesday, September 21st.  We are attending 50 year anniversary of friends of ours in Dublin, Ireland and are going to spend some time traveling in Ireland and Northern Ireland.

I will post photos, but meanwhile here are a couple of Creative Commons photos from Wikimedia 🙂

Irish countryside

2015-9971 - St Patricks Cathedral Dublin

Author Published on Leave a comment

There was some discussion on comp.lang.clarion last week about performance of REMOVE in terms of removing the page metafiles when a report closes.  The previewer uses the same method for removing the metafiles.  We have released a new build that uses windows API rather than Clarion REMOVE function to remove the files.  This should help with performance when closing large reports.

Please let us know if you experience any problems with this.

Author Published on Leave a comment

I discovered today that our hosting company had updated PHP on icetips.com.  If they let us know it did not register with us.  The new PHP removed some of the old database functions that were used in various places and thus the site was completely blank this morning!

I have got most of it functioning again and will get the rest updated tomorrow, March 2nd.  I apologize for any problems this may have caused.  Our email and all other services were working without problems.

One thing that will take me a few more days is to get the article search back up.  It was using a very old version of Code Charge code (probably close to 20 years old) that is also not compatible and I'm switching it over to using DataTables.  I have been using that library with very good results in development for a client.  Hopefully, I will have this all up and running in a couple of days!

Author Published on Leave a comment
I have a website that I like to visit, but I'd like to open it in its own browser window, without any of the toolbars at top, etc. After some digging, I found that Chrome actually has some interesting stuff available for command-line control. So I created a shortcut and used this:
"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --profile-directory="Default" --new-window --window-size=300,300 --app=
And then the url for the website after --app= Works like a charm, but a long-standing bug in Chrome (reported 7 years ago and, well, not fixed yet 😉 makes the --window-size not work. However with the --profile-directory="Default" it saves the last used size for the window in the user profile and opens in the last used size.
 
In my case, I wanted to open CBC One in Victoria, so my full command line is:
"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe" --profile-directory="Default" --new-window --window-size=300,300 --app=http://prod-chrome80-player-popup.s3.eu-central-1.amazonaws.com/popup_player_v1.html?station=cbcvictoria&tenant=www.radio.net
 
This opens the radio station up in a popup window (NOT existing Chrome window) and the size is saved.  So I now have a nice little window for my radio station!
 
For those who want to dig deeper (I've not even scratched the surface) here is the official list of command-line arguments for the Chromium project:
 
It's only 52 pages!!!
Since Windows Edge is based on Chromium, this should work for both Chrome and Edge.
Enjoy!

Author Published on Leave a comment

With larger monitors and more monitors, I have found that it has become increasingly difficult for me to find the mouse cursor on the screens.

I remembered that there used to be some ways to change the cursors and set out to find it.  Turns out it's pretty easy!

Start by going to the Windows Settings app by selecting it from the start menu.

From the Windows Settings app, select "Ease of Access"

On the "Ease of Access" page select the "Cursor and Pointer" option on the left and then you can change the cursor size and color and also the caret thickness.

Since most of the windows I work on have a light background, I chose to use the black cursor and set the size to 3.  You can only see the number for the size when you move the slider, but I found 3 to be a good size for both my 27" 1080p monitors as well as my 32" QHD (2560x1440 pixels)

Author Published on Leave a comment

SQLite databases came up on one of the newsgroups this week.  I have not used the SQLite driver in Clarion, so I don't have any experience with it - yet.

For many years I have used HeidiSQL with MySQL and MariaDB databases and it works great.  But it can only work with MySQL, MariaDB and MS-SQL.  So I wondered what tools there might be out there to use to browse and work with SQLite databases.  Both are open source and free and both work with Windows, MacOS and Linux.

I found two that looked interesting!

SQLite Database Browser

This program has been around since 2003 and the last release was in April of 2019 so it's being fairly actively developed.  It is available for Windows, MacOS, Linux (several variations) and FreeBSD.  This tool is primarily a database browser and based on the few screenshots I've found it looks a bit limited.

SQLite Studio

This program has also been around since 2007 and the last release was in July 2018.  This program looks like HeidiSQL and you can view data, enter your own queries etc.  It is available for Windows, MacOS and Linux.

In my experience one of the most important tools when dealing with database is a good, solid interface to execute queries and statements.