Tom HoldenChange your cover photoUpload Change your cover photoUpload Change your cover photo Tom Holden This user account status is Approved About About Posts Posts Comments Comments That result troubled me and I found on further investigation that this revised constraint is required to cover what I… On Group – Persons with Text Dates #date #namedgroup Sorry, I forgot to respond to this. One approach would be to replace every instance of the constraint WHERE Date… On Group – Persons with Text Dates #date #namedgroup Done. That's a pretty simple one because the LabelTable became the TagTable along with some changes in field names. On Group – Persons with Text Dates #date #namedgroup The RM8 version runs without SQLite error on a RM10 database I tested. The error message you quote, if copied… On Group – Persons with Duplicate Events #namedgroup #events #date #duplicates I last used Dbeaver 15 mos ago to try out its Entity Relationship Diagram feature on a RM database. I… On RMNOCASE – faking it in SQLite Expert, command-line shell et al #rmnocase Updated script for RM8-10 added. On RIN MRIN – add Reference Number fact to all persons #mrin #refno #rin See my reply in the new Forum topic at https://sqlitetoolsforrootsmagic.com/forum/topic/update-wanted-for-media-duplicates-reports-and-remedies/#postid-1242 It's a better venue for longer form discussion. On Media Duplicates – Reports and Remedies Hi Jaime, those scripts are well and truly for RM7 or earlier because changes to table definitions in RM8 and… On Reports – Point Form Narratives Setup #reports Thanks, Cor. On checking further, RM9 preserves both the Standardized and Abbreviated values for Place Name, RM7 did not. I've… On GEDCOM & DnD transfer losses #gedcom Only site users with author or higher privileges can post new topics to the Blog but any logged in user… On Using ChatGPT AI to get help on querying the RM database load more comments