Sql, dupicate connection

[spirit]

1) At the start up I create a connection (default)
2) If the user wants to open another archive I would open a new connection to that database and make it as default.

it is also not necessary to make connection default, you can pass needed database in ctors of sql classes.

[janus]

hi,

i am working with a code like this ...

QString path = QFileDialog::getOpenFileName(this,
	      tr("Path to DB"), qApp->applicationDirPath(), "SQLite (*.sqlite3)");
	if(!path.isEmpty()){
		QSqlDatabase::database().close();
		QSqlDatabase::database().removeDatabase(QSqlDatabase::database().connectionName());
		QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
		db.setDatabaseName(path);
		if(!db.open()){
			QMessageBox::critical(this, tr("Error"), tr("DB Error"));
		}

QString path = QFileDialog::getOpenFileName(this,
	      tr("Path to DB"), qApp->applicationDirPath(), "SQLite (*.sqlite3)");
	if(!path.isEmpty()){
		QSqlDatabase::database().close();
		QSqlDatabase::database().removeDatabase(QSqlDatabase::database().connectionName());
		QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
		db.setDatabaseName(path);
		if(!db.open()){
			QMessageBox::critical(this, tr("Error"), tr("DB Error"));
		}

To copy to clipboard, switch view to plain text mode 

But I always get the message that the database is still in use. AFAIR you cant get rid of this message with sqlite ... . But the new connection does work.

[giusepped]

I just came up with a method which imitates yours.
Every time I check the database connection, and if it is ok I open a connection with the name of the filename. More, I use a member variable to track the current database in action.
In this way, I can always remove the correct database and avoid duplicate connection.