Exploit your RootsMagic family tree database with SQLite Tools
A category for pages that don’t fit any other category.
Does not include any pages that have yet to be categorised.
I’ve just discovered that I caused a systemic error in several scripts dealing with Groups in relating the LabelTable.LabelID to the GroupTable.GroupID when the latter is actually related to LabelTable.LabelValue. It’s of no consequence when groups are consecutively created but not deleted because the LabelID and LabelValue match. The problem arises when a group before…
This script does two things: For those persons having one Alternate Name of type “Birth” and a Primary name of “undefined” type, it sets the Alt name as the Primary name and changes the previous Primary name to an Alternate Name. For those persons having more than one Name of type “Birth”, it lists the Record…
I am having trouble setting up this query. I want the results of the first query to merge/join/union with the second query where the ownerid from the first query equals the ownerid from the second query. The bold line should not be part of the query. I put it in to get the records…
RootsWeb is deactivating its Mailing List service on March 2, 2020, but leaving the archive of each List online, for now. A successor has been set up on Groups.io, operated by users. The old and the new list appeal to those who refuse to participate in the now 21,000 member facebook group and others for…
Search for: The above Search widget is the same as the one visible in the side panel. Tip: tag names imported from Wikispaces are searchable as hashtags, e.g., #events will have narrower results than events. The cloud below of Popular Tags excludes less common ones that may still be found in a post through Search.…
Home A Migration Test Page A Proposal for a Named Group and Color Manager A Query for a To Do List in a Grid Format A Sample Query Created with Views Adding Virtual Columns to an RM4 Table Addresses – How Used Ahnentafel 64 generations All Citations & Dupes Count – Query All Citations –…
You are probably aware that Wikispaces has announced a phased shutdown of its services with that for SQLite Tools for RootsMagic terminating on 30th Sep 2018. After much gnashing of teeth, I have started investigating alternatives to which the wiki might migrate. I would welcome your help in the process, especially if you are knowledgeable…
I have been using this query for a quite a while now: — Alternate Name Typos Select f.FamilyID, — 1 — Column B Gets the surname, given name and fathered for the fatherid from the famillytable for the fathers primary record. This is the husband. (select n1.surname || “, ” || n1.given || ” ”…
Problem Queries Create a New Page for your problem by editing this page, inserting a link from the Editor menu which will permit you to insert the text for the hyperlink and name your new page. After saving this revised page, click on your new link to create and edit your new problem page. On…
Posted to Facebook by Art Dembinski 11 May 2016: I have a long list of “To Do”s of various kinds that I will probably not live long enough to accomplish. I travel a fair amount, and usually with very little advance notice. The locations for doing these are scattered all over the USA and Canada.…