I guess I should've stepped through again. Since having the initial
problem, I added addition code, one of which caused the filename to be an
empty string just prior to calling the function. It's working now. Sorry
about that and thanks for the help.
On 8/21/07, PokerAce <[EMAIL PROTECTED]> wrote:
>
> I thought of that. I did a search of my harddrive and it resulted in no
> duplicate files. In my code, I check if the file exists before trying to
> open it. Also, I debugged the application stepping through it line by line
> and the directory path is fine. Is there a problem in SQLite 3.4.2 with
> long file names?
>
>
> On 8/21/07, John Stanton <[EMAIL PROTECTED]> wrote:
> >
> > PokerAce wrote:
> > > I'm using SQLite version 3.4.2 and for some reason, I cannot read from
> > any
> > > SQLite databases.
> > >
> > > When I create the database, all the create and insert statements
> > execute
> > > with no problems, and by using SQLite Database Browser, I can see that
> > the
> > > tables are there and that they are populated. However, whenever I try
> > to
> > > run a select statement, I get the error "no such table: <tablename>".
> > > Again, looking in the browser, the table is there, it's just not
> > visible to
> > > my application.
> > >
> > > I did some investigating and found that a "select * from
> > sqlite_master"
> > > returns 0 rows. However, doing that in the browser, once again,
> > returns all
> > > the information you'd expect. I've spent hours searching for the
> > solution
> > > to this, stepping through each line of code, but everything seems to
> > be in
> > > proper order. I've even tried connecting to SQLite databases created
> > by
> > > other applications and get the same result when selecting from the
> > > sqlite_master table.
> > >
> > > Here's my connection code:
> > >
> > > int sqlErr = sqlite3_open(filename, &m_conn);
> > > if( sqlErr != SQLITE_OK ) {
> > > return (false);
> > > }
> > >
> > >
> > > Here is my prepare code:
> > >
> > > sqlite3_stmt* sqlStmt;
> > > const char* sqlTail = 0;
> > >
> > > if( sqlite3_prepare(m_conn, query, queryLength, &sqlStmt, &sqlTail) !=
> >
> > > SQLITE_OK ) {
> > > return (false);
> > > }
> > >
> > > Here is my step code:
> > >
> > > bool loop = true;
> > > while(loop) {
> > > switch( sqlite3_step(rs) )
> > > {
> > > case SQLITE_DONE:
> > > loop = false;
> > > break;
> > >
> > > case SQLITE_ROW:
> > > // process row stuff here
> > > break;
> > >
> > > case SQLITE_ERROR:
> > > // handle...
> > > loop = false;
> > > break;
> > >
> > > case SQLITE_MISUSE:
> > > // handle...
> > > loop = false;
> > > break;
> > > }
> > > }
> > >
> > > I've cut some unnecessary code from the snippets, but that's the
> > important
> > > stuff. If anyone has any idea what is going on here, please let me
> > know.
> > >
> > > Josh
> > >
> > Your filename is not the correct pathname for your existing database and
> > your program is creating a new, empty database.
> >
> >
> > -----------------------------------------------------------------------------
> > To unsubscribe, send email to [EMAIL PROTECTED]
> > -----------------------------------------------------------------------------
> >
> >
> >
>
