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