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