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.

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

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.

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!

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!

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)

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.