Unhide SideList Born|Died Columns RM8

Quote from Tom Holden on 2023-02-14, 10:01 pmThe RM8.5.0 Side Index columns for Born and Died can be made to disappear
by certain adjustments of widths and cannot be made to reappear using the
UI. Reference: the discussionMissing Born and Died in Index
in the RootsMagic Community Forum.
This script resets the parameters stored in the database to the default
for a new database. On reopening in RM, the columns will reappear.Usage:
Close the database in RM which will save its current setting in the database.
Open the database in the SQLite manager and execute this script against it.
On reopening in RM, the columns will reappear.
The RM8.5.0 Side Index columns for Born and Died can be made to disappear
by certain adjustments of widths and cannot be made to reappear using the
UI. Reference: the discussion
Missing Born and Died in Index
in the RootsMagic Community Forum.
This script resets the parameters stored in the database to the default
for a new database. On reopening in RM, the columns will reappear.
Usage:
Close the database in RM which will save its current setting in the database.
Open the database in the SQLite manager and execute this script against it.
On reopening in RM, the columns will reappear.

Quote from Tom Holden on 2023-02-15, 11:18 amThis revised version resets the Born|Died column widths to the initial|default setting of 40, regardless of the current value. And I've discovered that the stored values can be decimal, not only integer numbers and that one can drag the Born width so much as to hide the Name column from which it may be impossible to recover through the RM UI. Hopefully, this version of the script addresses all cases of hidden Name|Born|Died columns as long as the SideList itself is wide enough.
CAVEAT: you must use SQLiteSpy (1.9.15 Win32 tested) or a SQLite manager with identical syntax for the regexp_replace() function for this script to work.
AND RM8 must not have the file open so that the changes the script makes will not be written over by RM on closing the file.
This revised version resets the Born|Died column widths to the initial|default setting of 40, regardless of the current value. And I've discovered that the stored values can be decimal, not only integer numbers and that one can drag the Born width so much as to hide the Name column from which it may be impossible to recover through the RM UI. Hopefully, this version of the script addresses all cases of hidden Name|Born|Died columns as long as the SideList itself is wide enough.
CAVEAT: you must use SQLiteSpy (1.9.15 Win32 tested) or a SQLite manager with identical syntax for the regexp_replace() function for this script to work.
AND RM8 must not have the file open so that the changes the script makes will not be written over by RM on closing the file.
Uploaded files: