My first posting so I hope I get the etiquette correct.

1st question How can I determine from a C-program if a table was generated with the "WITHOUT ROWID" option? I have an application where it is important to know if a table has a rowid or not.

2nd Question After a database is defined and the tables created, I have an application which automatically generates C++ DAO and DTO objects for each table. At run time, I'd like to be certain that the schema and the DAO/DTO match. I had thought to use the schema_version pragma but it increments when the db is VACUUMED. Is there some hidden cookie or value I can use that I have overlooked?

Thanks in advance


_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to