QSqlTableModel with SQLITE on multiple databases

HKraft

Hello,

I'm using SQLITE with multiple databases so to reference a table usually [databasename].[tablename] is to be used. When using sqlite3 I additionally need to use ' characters to enclose the table names, e.g. 'testdb.users'. While trying to do:

QSqlTableModel model = new QSqlTableModel (this, myDatabase);
model->setTable ("testdb.users");
model->setEditStrategy (QSqlTableModel::OnManualSubmit);
if (model->select ())

the select call returns false. I also tried:
model->setTable "'testdb.users'"
with the same result.

SGaist

Hi and welcome to devnet,

How are you creating these databases ?

HKraft

Hi,
thanks for reply. All databases are created by programm using QSqlQuery. At first the primary database and then the ones to attach, also using QSqlQuery to attach.

SGaist

Can you provide a minimal code sample that shows how you initialise your database ?

HKraft

Hi,
I don't see much from that but here is a very shortened exampe:

// attach different database
if (dbName.compare (currentDbName) != 0)
{
QString qs = QString ("attach database '%1' as '%1').arg
(dbName);
QSqlQuery q (qs);
// Error procressing

}

// create a table
QString qs = QString ("create table if not exist '%1' (id int "
"primary ke, name varchar(256))")
.arg (getTableName (dbname, tableName));
// getTable name delivers a QString like "myDatabase.maTable".
QSqlQuer q (qs);
// Error processing

// insert values
QString qs = QString ("insert into '%1' (%2) values (%3)")
.arg (getTableName (dbName, tableName))
.arg (headers.join (", "))
arg (values.join (", "));
// headers and values are QStringLists of equal size taht contain // the table headers to be filled with values
// error processing

MrShawn

Where are you getting the db name from? From what I see, SQLite does not support multiple databases within a .db file. You basically specify which db by which file you connect to.

Try just:

model->setTable("users");

HKraft

Please reread the original posting. I never stated that multiple databases reside in a single file but in different ones.
If you don't have any experiance with that matter why do you replay?

jsulm

@HKraft Please be more kind! If somebody is trying to help you you should not react like this even if the post wasn't helpull...