Jump to content


Photo

SQLite editing of database.


  • Please log in to reply
1 reply to this topic

#1 KeithSloan52

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

 

Thanks 



#2 Renee Zamora

Renee Zamora

    Advanced Member

  • Support
  • PipPipPip
  • 7451 posts

Posted 25 January 2018 - 02:49 PM

This question is best asked on the SQLite Tools website. 


Renee
RootsMagic