diff options
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.cpp | 100 |
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] |