Info View has gone awry

I’m another user, not Tech Support, but have delved under the hood of the RootsMagic database for many years. A vague recollection of what I had seen before in a table that I’ve rarely touched prompted me to look in again. Using SQLiteSpy, I’ve been able to both:

  • simulate your problem
  • fix it

I’ve realised that the instructions I gave to you earlier about window maximising, sliding this and that, and, likewise, any one else’s such suggestions are doomed to failure because the Date column has been blown wider than the maximum width allowed for the Edit Person Window. It’s not possible to bring the Date column’s right-hand divider into view. I also tried a drag’n’drop to a new database which fixed that issue as did your GEDCOM transfer but also lost groups.

So here’s the repair:

UPDATE ConfigTable
 SET DataRec=
  CAST(
       RegExp_Replace
       (
        DataRec,
        '<EditPersonDateWidth>[^<]+</EditPersonDateWidth>',
        '<EditPersonDateWidth>100</EditPersonDateWidth>'  -- 100 for a new database
        ) AS BLOB
       )
 WHERE RecID=1
;

I’m not aware that Tech Support is into the nuts and bolts and would have to refer this to one of the two developers to apply to your database. If you are disinclined to do so yourself, DM me or one of the other able tinkerers you can find in the Forum at sqlitetoolsforrootsmagic.com to arrange to send your file for one of them to tweak.

2 Likes