Try: .schema [tablename]
Since there is probably nothing there, you probably need to create a table. If you are new to SQL / SQLite, then here are some helpful videos: https://www.youtube.com/playlist?list=PLItP5KoawLqkPV2jqAVCH79fZGO5k0Uzy Cheers, -Randall Nagy President, Soft9000.com On Sat, May 21, 2016 at 4:09 PM, Rajendra Shirhatti <rrshirhatti at gmail.com> wrote: > Hi, > We've a .Net Windows Service that uses SQLite 1.0.93.0 for database > operations. The SQLite package contains two binaries, > system.data.sqlite.dll and sqlite.interop.dll. > > The database is encrypted and the blob it contains is encrypted as well. > SQLite is intermittently throwing following exceptions while retrieving > data from the database. > > > - *SQL logic error or missing database no such table*. > > The code is trying to execute a simple query which looks something like > this: > SELECT x, y from [tablename] > > This exception is raised while executing SQLiteCommand.ExecuteReader(). The > stack trace points to > at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, > SQLiteStatement previous, UInt32 timeoutMS, String& strRemain) > at System.Data.SQLite.SQLiteCommand.BuildNextCommand() > at System.Data.SQLite.SQLiteDataReader.NextResult() > > > > * - Data Source cannot be empty. Use :memory: to open an in-memory > database- unable to open database file * > > These two exceptions are raised while trying to open the connection. > > > Any help or guidance would be appreciated. > > Thank you, > Raj > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
