Re: [sqlite] sqlite3_open: detecting creation vs opening

2004-12-27 Thread Roger Binns
I know that I can check for the existance of the database file - but I was hoping to avoid that particular hoop. That isn't necessarily as easy as you think. Unless you took great care to ensure that all characters in the pathname are ascii then it could be quite difficult to know exactly what

[sqlite] sqlite3_open: detecting creation vs opening

2004-12-27 Thread Gwendolynn ferch Elydyr
Does sqlite have any mechanism to determine if sqlite3_open has created a new database, rather than opening an existing database? The sqlite3_open returns SQLITE_OK for both creation and opening, and obviously doesn't supply any helpful error messages on success ;> I know that I can check for the