Paul, have you considered using the CREATE FILE directive to make your backups?
https://manual.pvxplus.com/page/directives/create_file.htm

This directive (added in PxPlus 2016) was specifically designed to help with this problem.  It does a high-speed data backup of active data files while placing a temporary lock on the file that prevents any updates. 

Assuming your files are a reasonable size you should be able create duplicate files fairly quickly.  For example on my Suse Linux server here I was able to create a backup of a 750MB file in under 2 seconds using the CREATE FILE directive.  The system prevented any updates to the file during this process but still allowed other processes to have the file open and simply stalled any updates until the copy was complete. A few second delay during off-hours is likely not going to be noticed.

In theory you should be able to create a program that makes copies of all your files as your backup and optionally ZIP that that directory up or transfer to another machine.  This should help assure you clean backups.

Actually its easier than that -- just set 'Item to the index for the item you want to change then set 'ItemText$ to the new value.

If you want to change the current item the set 'Item to 'CurrentItem and then change 'ItemText$. Here is a demo program.

Code: [Select]

0010 PRINT 'CS'; LIST
0020 LET Lb=100
0030 LIST_BOX Lb,@(40,1,12,6),FNT="*"
0040 LIST_BOX LOAD Lb,"Dog/Cat/Pig/Cow/Ant/Gnu/"
0050 WHILE 1
0060 SET_FOCUS Lb
0070 INPUT *
0080 IF CTL=4 THEN BREAK
0090 LET item=lb'currentItem
0100 IF item=0 OR CTL<1 OR CTL>3 THEN CONTINUE
0110 IF CTL=1 THEN LET Lb'item=item; LET Lb'ItemText$=UCS(Lb'ItemText$)
0120 IF CTL=2 THEN LET Lb'item=item; LET Lb'ItemText$=LCS(Lb'ItemText$)
0130 IF CTL=3 THEN LET Lb'item=item; LET Lb'ItemText$=CVS(Lb'ItemText$,256)
0140 WEND
0150 ! list_box remove Lb
0160 END Run it and select an item from the list.  Pressing F1 will convert to upper, F2 lower, F3 mixed, F4 Quit

The new query does not actually pre-load data. This is an option setting for the classic query to allow column sorting. The new query will either load-on-demand or background load. The issue which you may be encountering is that you can only sort on a column when all the data has been loaded into the query listbox. With the classic query, there was no display until all the records were read, so when you clicked on the column header, the sort occurred. With the new query, records are displayed before they have all been read, so there could be a wait while records are being loaded before the sort could happen.