On 19 Sep 2014, at 8:34am, Paul <de...@ukr.net> wrote:

> if database file is missing it must be created and initialized. 
> For that purpose I need  to provide a guarantee that *on_create* callback 
> will be called strictly once. 

Can you check to see whether the database file exists using file operations, 
not SQLite operations ?

SQLite doesn't usually cope with the problem the way you described.  It's more 
usual to use the form

CREATE myTable/myIndex IF NOT EXISTS ...

that way if the datbase file already exists and has the right structures in it, 
nothing is changed.

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

Reply via email to