Are the database files you're trying to open in the same directory as the executable? What happens if you path the full path and file name to sqlite3_open? What is the full command line used to start the sqlite3 command prompt?
The problem will turn out to be something very simple... Think small. :) -Tom > -----Original Message----- > From: Lee Crain [mailto:[EMAIL PROTECTED] > Sent: Monday, July 02, 2007 5:47 PM > To: [email protected] > Subject: [sqlite] Problem: Can't See Tables in Database > > I have 2 databases created and populated: > > > DBLee, my test database > > > MiniMain, a subset copy of one of our production databases > > > > From the sqlite3 command prompt, I can run queries against > both databases > and see the results. I can also enter the ".tables" command > and see the > correct list of tables in each database. > > > > DBLee > > sqlite> .tables > > tb12 tb22 > > sqlite> > > > > > > MiniMain > > sqlite> .tables > > Categories InstallerFiles Items RequiredItems > > ContentFiles ItemCategories RelatedItems > > sqlite> > > > > _________________________________________ > > > > I have written a small test program in C++ to perform proof > of concepts. > The code is failing to execute any query against the MiniMain database > with the error message "SQL error: no such table: > Categories". Categories > is one of 7 tables. The same failure results for all 7 tables > and for all > simple queries ("Select."). > > > > This is my source code: > > > > int main( ) > > { > > sqlite3 *db; > > char *zErrMsg = 0; > > int rc; > > > > // Test Open > > // rc = sqlite3_open( "DBLee", & db ); > > rc = sqlite3_open( "MiniMain", & 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 tb12", callback, > 0, &zErrMsg > ); > > rc = sqlite3_exec( db, "SELECT * from Categories", callback, 0, > &zErrMsg ); > > if( rc!=SQLITE_OK ) > > { > > assert( false ); > > fprintf( stderr, "SQL error: %s\n", zErrMsg ); > > Sleep( 15000 ); > > sqlite3_free( zErrMsg ); > > return( 1 ); > > } > > > > > > > > The commented out lines execute correctly. The "SELECT * FROM > Categories" > line always fails. > > > > What could be the problem? > > > > Thanks, > > > > Lee Crain > > Senior Software Engineer > > DAZ 3D Productions > > 801-495-1777, x759 > > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
