Hi,
I've a problem with SQLITE :
My program use a Sqlite database which is set like this :
m_db.setDatabaseName( "base1.bdd" );
m_db = QSqlDatabase::addDatabase( "QSQLITE" );
m_db.setDatabaseName( "base1.bdd" );
To copy to clipboard, switch view to plain text mode
m_db is create like this in the header file :
private :
private :
QSqlDatabase m_db;
To copy to clipboard, switch view to plain text mode
Then in a second function (in the same class), i execute SQL request :
if ( m_db.open() )
s_req->data = m_db.exec( "SELECT * FROM tab1 ORDER BY nom COLLATE NOCASE;" );
if ( m_db.open() )
s_req->data = m_db.exec( "SELECT * FROM tab1 ORDER BY nom COLLATE NOCASE;" );
To copy to clipboard, switch view to plain text mode
Until here, i've no problem with Sqlite.
But in a third function, i want to load (and use) a new database (without restart program).
To do this, i do :
if ( m_db.isOpen() )
m_db.close();
m_db.setDatabaseName( "base2.bdd" );
if ( m_db.isOpen() )
m_db.close();
m_db.setDatabaseName( "base2.bdd" );
To copy to clipboard, switch view to plain text mode
But, here, if i launch program it closes immediately as soon i've come on the if instruction.
I don't know what is wrong.
Thank you for your answer.[/quote]
Bookmarks