Rootsmagic 7 to go tutorial how to#
Rootsmagic 7 to go tutorial download#

Rootsmagic 7 to go tutorial how to#

Read about the experiences of other beginners at How to query RootsMagic.

Rootsmagic 7 to go tutorial download#

You can copy and paste a script from this wiki into the same SQL editor space or download a script file and use File > Open SQL to load it into the editor. The results of this user-inputted query display the same way as for the macro query of step 6.Д¬ongrats! You have run two queries on your database. In the upper pane, type in вЂњSELECT Surname, Given FROM NameTable вЂќ and then press F9 or click on menu Execute > Execute SQL.Select any cell in the results pane and you can see its content in the bottom pane. Results will display to the right in the middle pane. Double-click on a table name and SQLiteSpy will automatically issue a (hidden) SQL statement or query to list all of the records in that table.Click on the + signs to expand and see the list of tables.Select your file and it will now be registered in the left panel.Start typing the first letters of the database filename or enter *.rmgc to get a list of the RootsMagic database files.Browse to the folder where your play database is located.

If you do not know how to do that, do not pass Go but proceed directly to Jail! OK, get ready to rumbleвЂ¦ First and foremost, make a backup of your RootsMagic database or a copy of it that you can play with so that if it gets messed up by your queries your master is intact. See RMNOCASE вЂ“ faking itвЂ¦ to get the substitute. Some of the queries simply will not work without it, returning the error вЂњSQLite3 Error 1 вЂ“ no such collation sequence: RMNOCASEвЂќ. You will also need to extend your SQLite manager to substitute for the secret RootsMagic RMNOCASE collation sequence having a large multilingual alphabet which is used to sort names of people, places, etc. I recommend SQLiteSpy to start with on Windows вЂ“ I donвЂ™t know Mac.

Because RootsMagic does not accept user inputted SQL statements, we use an outboard SQLite manager, an application that provides an interface for the user to input SQL statements to operate on a database file.Д«ecause SQLite 3 is a free, open-source package, there are lots of applications that can open a RootsMagic file. A script comprises one or more statements. These are commonly called вЂњqueriesвЂќ which is a bit misleading because a query can also modify the data. SQLite acts on the database in response to SQL statements or commands it is given. ThatвЂ™s because RootsMagic incorporates the SQLite 3 database engine to write and read its database files. You need a SQLite manager such as SQLiteSpy to read and modify a RootsMagic database using the queries or scripts from this wiki.