aboutsummaryrefslogtreecommitdiffstats
path: root/doc/codesnippets/doc/src/snippets/code/src_qt3support_sql_q3sqlcursor.cpp
diff options
context:
space:
mode:
Diffstat (limited to 'doc/codesnippets/doc/src/snippets/code/src_qt3support_sql_q3sqlcursor.cpp')
-rw-r--r--doc/codesnippets/doc/src/snippets/code/src_qt3support_sql_q3sqlcursor.cpp100
1 files changed, 0 insertions, 100 deletions
diff --git a/doc/codesnippets/doc/src/snippets/code/src_qt3support_sql_q3sqlcursor.cpp b/doc/codesnippets/doc/src/snippets/code/src_qt3support_sql_q3sqlcursor.cpp
deleted file mode 100644
index b3b643d96..000000000
--- a/doc/codesnippets/doc/src/snippets/code/src_qt3support_sql_q3sqlcursor.cpp
+++ /dev/null
@@ -1,100 +0,0 @@
-//! [0]
-Q3SqlCursor cur( "staff" ); // Specify the table/view name
-cur.select(); // We'll retrieve every record
-while ( cur.next() ) {
- qDebug( cur.value( "id" ).toString() + ": " +
- cur.value( "surname" ).toString() + ' ' +
- cur.value( "salary" ).toString() );
-}
-//! [0]
-
-
-//! [1]
-Q3SqlCursor cur( "prices" );
-cur.select( "id=202" );
-if ( cur.next() ) {
- QSqlRecord *buffer = cur.primeUpdate();
- double price = buffer->value( "price" ).toDouble();
- double newprice = price * 1.05;
- buffer->setValue( "price", newprice );
- cur.update();
-}
-//! [1]
-
-
-//! [2]
-Q3SqlCursor cur("Employee"); // Use the Employee table or view
-cur.select("deptno=10"); // select all records in department 10
-while(cur.next()) {
- ... // process data
-}
-...
-// select records in other departments, ordered by department number
-cur.select("deptno>10", cur.index("deptno"));
-...
-//! [2]
-
-
-//! [3]
-Q3SqlCursor cur("Employee");
-cur.select("deptno=10"); // select all records in department 10
-while(cur.next()) {
- ... // process data
-}
-...
-cur.select(); // re-selects all records in department 10
-...
-//! [3]
-
-
-//! [4]
-Q3SqlCursor cur("Employee");
-QSqlIndex pk = cur.primaryIndex();
-cur.setValue("id", 10);
-cur.select(pk, pk); // generates "SELECT ... FROM Employee WHERE id=10 ORDER BY id"
-...
-//! [4]
-
-
-//! [5]
-Q3SqlCursor cur("Employee");
-cur.setMode(Q3SqlCursor::Writable); // allow insert/update/delete
-...
-cur.setMode(Q3SqlCursor::Insert | Q3SqlCursor::Update); // allow inserts and updates only
-...
-cur.setMode(Q3SqlCursor::ReadOnly); // no inserts/updates/deletes allowed
-
-//! [5]
-
-
-//! [6]
-Q3SqlCursor cur("prices");
-QSqlRecord *buffer = cur.primeInsert();
-buffer->setValue("id", 53981);
-buffer->setValue("name", "Thingy");
-buffer->setValue("price", 105.75);
-cur.insert();
-//! [6]
-
-
-//! [7]
-Q3SqlCursor cur("prices");
-cur.select("id=202");
-if (cur.next()) {
- QSqlRecord *buffer = cur.primeUpdate();
- double price = buffer->value("price").toDouble();
- double newprice = price * 1.05;
- buffer->setValue("price", newprice);
- cur.update();
-}
-//! [7]
-
-
-//! [8]
-Q3SqlCursor cur("prices");
-cur.select("id=999");
-if (cur.next()) {
- cur.primeDelete();
- cur.del();
-}
-//! [8]