aboutsummaryrefslogtreecommitdiffstats
path: root/doc/codesnippets/doc/src/snippets/code/src_sql_kernel_qsqlresult.cpp
diff options
context:
space:
mode:
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.cpp38
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]