QDataBrowser and QSqlCursor

[ederbs]

Hello,

Is there anyway to use one QSqlCursor with more than one table?

For instance:

I am interested in displaying the query results obtained from ten tables.

Any suggestions would be welcome.

Ederson de Moura.

[jacek]

Use QSqlSelectCursor.

[ederbs]

Humm, to effect inserts using QDataBrowser and QSqlForm.

[jacek]

Humm, to effect inserts using QDataBrowser and QSqlForm.
Then maybe you could use a view? Does your database supports view updates?

[ederbs]

I cannot use view.

Form looks at mine, each QLineEdit is in different tables, the QComboBox is research.

http://200.193.29.195/qt/form.png

The Sql passed for the DBA.

http://200.193.29.195/qt/sql.html

some hope for this.

Ederson de Moura

[cristiano]

Hi,

I am with the same problem and not meeting the solution.

Cris.

[jacek]

You could create a separate QSqlForm for each table.

[ederbs]

I could also make this for transactions?

Something as:

QSqlDatabase::database()->transaction();
QSqlQuery query;

query.exec("INSERT INTO bairros (id_cidade, nm_bairro)"
"VALUES (" + Usuario + ", 8105) " );

QSqlDatabase::database()->commit();

Ederson de Moura

[jacek]

I could also make this for transactions?
You start transaction for the whole connection, so if every QSqlForm or QSqlCursor instance uses the same connection, it will operate within the same transaction.