Quote:
Originally Posted by Laurentiu
Where is that metadata.db table? A search on the calibre folder did not find anything.
|
It's in the root of the Calibre Library. It
is the Calibre database. You can't edit the sort field directly due to the trigger. For the adventurous, it's possible to DROP the trigger, change that field, then CREATE it back, but any change to the sort field would be overwritten during the following UPDATE, which starts the trigger. You'd have to change the code that Charles pointed to to keep the change. (I don't recommend this, but I was interested, so I wrote a bit of test code to do this, and I tried it manually. Both worked, but it's still possible that it has side effects I didn't notice.)