> On May 23, 2017, at 3:31 PM, Leona Struckhoff <moma...@yahoo.com> wrote: > > I placed the Leona.rmcg file in the same folder as the sqlite3.exeI double > clicked on sqlite3.exeI noticed my comand prompt had sqlite and not sqlite3. > Your examples below have sqlite3. > I entered the following:sqlite> sqlite3 Leona.rmgc ...> PRAGMA > integrity_check;Error: near "sqlite3": syntax errorsqlite> sqlite3 > [Leona.rmgc] ...> PRAGMA integrity_check;Error: near "sqlite3": syntax > errorsqlite>
It’s been a long time since I used Windows, but I think that if you double-click the EXE you will be running the SQLite command interpreter in the window that comes up. So you don’t need to use the “sqlite3” command. Instead, type “.open” (with a period!), then a space, and then the full path to the database file. That should open the database. Then you can type “pragma integrity_check;”. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users