Quote:
Originally Posted by DaltonST
Custom Columns in Calibre have a sequential number assigned when table custom_columns is updated for a new CC. Your "Target" metadata.db has none of your CCs, so there is no Target CC for you to copy from Main to Target (yet). After you have totally updated all of your books and their Standard Metadata in the Target, you could copy a book from Main and have Calibre automatically create whichever CCs you wish. Then, they would exist. You would then have to add new SQL that is specific to the CC number in your Main and the CC number in your Target. They will NOT be the same, since the Q&S Target metadata.db comes with a dozen "standard" Q&S "work" CCs.
...............
There are web sites that can teach you SQLite SQL, such as http://www.sqlitetutorial.net/.
DaltonST
|
yup, thanks for the explanation.