Hi Simon, Thanks for your response. I'm using the node.js plugin. I've tried creating a table then closing the db, and the queries executed successfully, but I was not able to find the database file that it created. I searched the folder structure and was unable to find any .db file, even though the db was opened, a table was created, and the db was closed again.
Regards, Robert On Thu, Sep 6, 2018 at 12:32 PM Simon Slavin <slav...@bigfraud.org> wrote: > On 6 Sep 2018, at 5:33pm, Robert Helmick <robert.helmick...@gmail.com> > wrote: > > > by default, then creates an empty database when it doesn't find the > > pre-populated mydb.db file. This is why it can't find the 'plant' table, > > because the newly created blank database obviously doesn't contain a > > 'plant' table. However I can confirm that the database *is* in the /www > > folder, and that it contains the 'plant' table when I run `sqlite3 > mydb.db` > > What OS ? > Are you using the C API or some other library ? > > If you write code to create a new database (open a filename, do at least a > CREATE TABLE command, close the connection) what directory does it put the > file in ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users