Are you linking SQLite dynamically or statically? If dynamically, check that it's actually loading the correct version of the shared library - there may be an older/different version of SQLite installed on your system that is getting loaded at run-time.
-Tom > -----Original Message----- > From: Lee Crain [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 03, 2007 12:25 PM > To: sqlite-users@sqlite.org > Cc: [EMAIL PROTECTED] > Subject: RE: [sqlite] Problem: Can't See Tables in Database > > Tom Briggs, > > > > Thank you for your response. I attempted to send you a > response complete > with screenshots to eliminate any ambiguity but it was returned unsent > because it was too large for your mail daemon. > > > > I have taken care to make certain that the "sqlite3.exe" > executable, all > databases (highlighted in red), and my import files (*.txt) > are all in the > same directory to avoid path issues. Please see the screenshot below: > > > > > > DELETED > > > > > > ------------------------------ > > > > I've created a very simple database named "DBm" with one > table "t" and 2 > fields, a varchar(10) and a smallint. Please see the screenshot below: > > > > DELETED - the screenshot showed the following: > > > > D:\DATA\SQLite>sqlite3 DBm > > SQLite version 3.3.17 > > Enter ".help" for instructions > > sqlite> .tables > > t > > sqlite> .schema > > CREATE TABLE t( one varchar( 10 ), two smallint ); > > sqlite> > > > > > > ------------------------------ > > > > > > Then, using the examples in the SQLite documentation, I ran > the example > code: > > > > > > > > int main( ) > > { > > sqlite3 *db; > > char *zErrMsg = 0; > > int rc; > > > > // Test Open > > rc = sqlite3_open( "DBm", & db ); > > if( rc ) > > { > > assert( false ); > > fprintf( stderr, "Can't open database: %s\n", > sqlite3_errmsg( > db ); > > sqlite3_close( db ); > > Sleep( 5000 ); > > return( 1 ); > > } > > > > // Test SELECT > > rc = sqlite3_exec( db, "SELECT * from t", callback, 0, > &zErrMsg ); > > if( rc!=SQLITE_OK ) > > { > > fprintf( stderr, "SQL error: %s\n", zErrMsg ); > > Sleep( 15000 ); > > sqlite3_free( zErrMsg ); > > return( 1 ); > > } > > > > > > > > The failure occurs on the sqlite3_exec( ) call. > > > > > > ------------------------------ > > > > > > And I receive this message (see screenshot): > > > > > > DELETED > > > > "SQL error: no such table: t" > > > > > > ------------------------------ > > > > What I'm attempting to do is about as vanilla an application as I can > think of. > > > > I am open to any other suggestions as to what the problem > might be. I hope > you are correct that the problem will turn out to be > something very small. > > > > Sincerely, > > > > Lee Crain > > Senior Software Engineer > > DAZ 3D Productions > > 801-495-1777, x759 > > [EMAIL PROTECTED] > > > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------