Exploit your RootsMagic family tree database with SQLite Tools
ConfigTable RecID 1 DataRec Default The first record of ConfigTable consists of XML in the RecID field that stores various database file settings. The current version and its data can be restructured and displayed as follows (Values column to be verified): See sheet “ConfigTableDefaultRec1” on Database Design Spreadsheets.
Problem In a discussion on the RootsMagic Forums, maginnis reported a problem with People View. After customising to add Place and Place Detail for many fact types, People View repeatedly threw up the error message “SQLite Error 1 – at most 64 tables in a join” until RootsMagic closed. The same error cropped up when…