View Single Post
Old 09-29-2010, 09:09 AM   #14
Starson17
Wizard
Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.Starson17 can program the VCR without an owner's manual.
 
Posts: 4,004
Karma: 177841
Join Date: Dec 2009
Device: WinMo: IPAQ; Android: HTC HD2, Archos 7o; Java:Gravity T
Quote:
Originally Posted by Laurentiu View Post
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.)
Starson17 is offline   Reply With Quote