Dave Dyer wrote:
At 08:04 PM 11/30/2006, John Stanton wrote:
Those are Macintosh issues, not Sqlite, and you need to handle them in your 
application.

Yes indeed.  I'm only suggesting that sqlite would be a better
substrate if it provided a supported way to tell me "I can't open
the database" rather than "there is no table named xx".
Dave,

It is really fairly easy to do this yourself using the pragma user_version. Simply set the user_version to a known value when you initialize a database schema, and then add a check after you open a database to see if the user_version has the expected value. If not you know you have some other kind of file, if the file existed before you did the sqlite3_open, or a newly created empty database file that needs to be initialized.

HTH
Dennis Cote


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to