Jump to content


SQLite editing of database.

  • Please log in to reply
3 replies to this topic

#1 KeithSloan52


    New Member

  • Members
  • Pip
  • 1 posts

Posted 25 January 2018 - 11:33 AM

I would like to use an SQLite tool to edit an RM database to resolve a small amount of corruption.


I have SQLPro and can open the database, but when I go to delete a row I get the error

"no such collation sequence: RMNOCASE"


Googling for RMNOCASE I understand that it is a SQLite extension for RM that controls sequencing.


I checked http://sqlitetoolsfo...gers for Mac OS

and it suggests using SQLiteStudio as it deals with the RMNOCASE extension. However I cannot get on with SQLiteStudio as it does not want to open my database and the one time it did, it wanted to change things and certainly is not as easy to use/understand as SQLPro.


Is there any way I can use SQLPro and get around the RMNOCASE issue



#2 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 8120 posts

Posted 25 January 2018 - 02:49 PM

This question is best asked on the SQLite Tools website. 


#3 aecreations



  • Members
  • PipPip
  • 7 posts

Posted 22 April 2018 - 07:57 PM

I keep getting the error code SQLite error 11 - no matter what I do, I keep getting the error.  what is wrong with RM

I created a new file, and still get the error

I tried to run the dbase tools and get the error

I shut down the program and then reopen it and get the error

I am running windows 10, pc


everytime you have an update this happens, what is going on.

I have been recommending RM to other people but now I am thinking about going to another software.

your software sucks

#4 TomH


    Advanced Member

  • Members
  • PipPipPip
  • 6004 posts

Posted 23 April 2018 - 05:08 AM

As I responded on facebook, your database file is corrupted. You say here it also happens with a new database. What is your computer and operating system? This sounds like a system problem.

Tom user of RM7550 FTM2017 Ancestry.ca FamilySearch.org FindMyPast.com
SQLite_Tools_For_Roots_Magic_in_PR_Celti wiki, exploiting the database in special ways >>> RMtrix-tiny.png app, a bundle of RootsMagic utilities.