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]
