diff options
Diffstat (limited to 'doc/codesnippets/doc/src/snippets/code/src_sql_kernel_qsqlresult.cpp')
-rw-r--r-- | doc/codesnippets/doc/src/snippets/code/src_sql_kernel_qsqlresult.cpp | 38 |
1 files changed, 38 insertions, 0 deletions
diff --git a/doc/codesnippets/doc/src/snippets/code/src_sql_kernel_qsqlresult.cpp b/doc/codesnippets/doc/src/snippets/code/src_sql_kernel_qsqlresult.cpp new file mode 100644 index 000000000..81d665641 --- /dev/null +++ b/doc/codesnippets/doc/src/snippets/code/src_sql_kernel_qsqlresult.cpp @@ -0,0 +1,38 @@ +//! [0] +q = QSqlQuery() +q.prepare("insert into test (i1, i2, s) values (?, ?, ?)") + +col1 = QVariant([1, 3]) +col2 = QVariant([2, 4]) +col3 = QVariant(["hello", "world"]) + +q.bindValue(0, col1) +q.bindValue(1, col2) +q.bindValue(2, col3) + +if not q.execBatch(): + print q.lastError() +//! [0] + + +//! [1] +query = QSqlQuery ... +v = query.result().handle() +if v.isValid() and (v.typeName() == "sqlite3_stmt*"): + # v.data() returns a pointer to the handle + handle = v.data() + if handle != 0: # check that it is not NULL + ... +//! [1] + + +//! [2] +if v.typeName() == "PGresult*": + handle = v.data() + if handle != 0 ... + +if v.typeName() == "MYSQL_STMT*": + handle = v.data() + if handle != 0 ... +} +//! [2] |