I'm having a bit of a problem.
In my database I have several Collections that are excluded in the main library. I would like to be able to move items from these collections into the main library with out opening the actual program. Can you tell me what field holds the collection information? and what the entry is supposed to be for the Library collection?
Thank you
Joel
Database Fields
Re: Database Fields
The easiest is via drag and drop.
Without opening the program you would need to use SQL and the database format is not simple. Your looking at the "Z_1ENTRIES" tables that holds the relationship between a collection and entries, via two columns describing a collection unique id and an entry unique id that go together. Library is most likely Z_PK 1, but you would need to verify that by dumping the SQL information.
You are truly on uncharted territory here and do make sure to backup all your files as there a number of index to improve performance that would get affected by changing this information without using the actual program.
Without opening the program you would need to use SQL and the database format is not simple. Your looking at the "Z_1ENTRIES" tables that holds the relationship between a collection and entries, via two columns describing a collection unique id and an entry unique id that go together. Library is most likely Z_PK 1, but you would need to verify that by dumping the SQL information.
You are truly on uncharted territory here and do make sure to backup all your files as there a number of index to improve performance that would get affected by changing this information without using the actual program.