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]
-----------------------------------------------------------------------------

Reply via email to