Tom HoldenChange your cover photoUpload Change your cover photoUpload Tom Holden This user account status is Approved About About Posts Posts Comments Comments Updated to support the Association fact type introduced in #RM9. On Facts Having Place Details – Query #placedetails #events 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 load more comments