QDataBrowser and QSqlCursor

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.

Use QSqlSelectCursor.

Humm, to effect inserts using QDataBrowser and QSqlForm.

Quote:

---

Originally Posted by ederbs

Humm, to effect inserts using QDataBrowser and QSqlForm.

---

Then maybe you could use a view? Does your database supports view updates?

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

Hi,

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

Cris.

You could create a separate QSqlForm for each table.

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

Quote:

---

Originally Posted by ederbs

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.