On 1 may 2004, at 8:38, D. Richard Hipp wrote:
When you do a "SELECT *", the results contain only columns that are explicitly declared in the CREATE TABLE statement. If you have declared an INTEGER PRIMARY KEY column, then the rowid will appear under that column name. If there is no INTEGER PRIMARY KEY, then the rowid will not be a part of the result. The ".dump" command works by doing a "SELECT *". So if you do not have an INTEGER PRIMARY KEY in your table declaration, the rowid will not be part of the saved data and will be lost when the table is reconstructed.
This is the explanation I was hoping for. Excellent!
BTW... I think that this information should be mentioned in the documentation, FAQ, or Wiki (why not all 3! ;-) If nobody is against it, I can take care of the Wiki page. Is that OK with you?
I would like to thank everyone else that answered my post. I truly appreciate it.
Best regards,
-- Tito
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
