Combobox Delegate 25.000 records

[aekilic]

Hello everybody,

I have connected 2 database for the program,

db = QSqlDatabase::addDatabase("QPSQL");
 		db.setHostName("10.0.0.11");
 		db.setPort(5432);
		db.setDatabaseName(comboDonem->currentText());
		db.setUserName(lineKullanici->text());
		db.setPassword(lineSifre->text());

db = QSqlDatabase::addDatabase("QPSQL");
 		db.setHostName("10.0.0.11");
 		db.setPort(5432);
		db.setDatabaseName(comboDonem->currentText());
		db.setUserName(lineKullanici->text());
		db.setPassword(lineSifre->text());

To copy to clipboard, switch view to plain text mode 

and the other one is

QSqlDatabase::database("in_mem_db", false).close();
	QSqlDatabase::removeDatabase("in_mem_db");
	cachedb = QSqlDatabase::addDatabase("QSQLITE", "in_mem_db");
	cachedb.setDatabaseName(":memory:");
	if (!cachedb.open())
	{
		QMessageBox::warning(this, tr("Unable to open database"), tr("An error occured while opening the connection: ") + cachedb.lastError().text());
		return false;
	}

QSqlDatabase::database("in_mem_db", false).close();
	QSqlDatabase::removeDatabase("in_mem_db");
	cachedb = QSqlDatabase::addDatabase("QSQLITE", "in_mem_db");
	cachedb.setDatabaseName(":memory:");
	if (!cachedb.open())
	{
		QMessageBox::warning(this, tr("Unable to open database"), tr("An error occured while opening the connection: ") + cachedb.lastError().text());
		return false;
	}

To copy to clipboard, switch view to plain text mode 

I could load the cache and select from cache. But the problem I have is when I go to another page(another .h file), I could not connect to cache. I could only connect db. (PQSQL)

I want to know How could I connect the cache and select from there.

[patrik08]

simple point your cache connecion on query

QSqlQuery query("",cachedb);

like sql example

connect / query to first db is
QSqlQuery query();
connect / query to sqlite memory
QSqlQuery query("",cachedb);

you can now query to all db listed on
QStringList QSqlDatabase::connectionNames () [static]

if you not like to save db pointer:

QSqlDatabase QSqlDatabase::database ( const QString & connectionName = QLatin1String( defaultConnection ), bool open = true ) [static]

[aekilic]

Dear Patric

Thank you for your reply again, but it didnt solve my problem actually.

Should I have to connect to cachedb on main.cpp?

Because what I do is on main cpp starts a entrance .ui which you log on the postgresql. In which i also connect to cachedb. After that you go to the mainpage.h. The problem I have is I could not connect to cache in the mainpage.h

[aekilic]

Dear Patric,

I am trying mybest. But when I close the form that I created cachedb, and open another form, I lost connectiong to the cachedb. But default db connection(PQSQL) stays. Please help me...