<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en_US" lang="en_US">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!-- q3sqlselectcursor.cpp -->
<title>Qt 4.8: Q3SqlSelectCursor Class Reference</title>
<link rel="stylesheet" type="text/css" href="style/style.css" />
<script src="scripts/jquery.js" type="text/javascript"></script>
<script src="scripts/functions.js" type="text/javascript"></script>
<link rel="stylesheet" type="text/css" href="style/superfish.css" />
<link rel="stylesheet" type="text/css" href="style/narrow.css" />
<!--[if IE]>
<meta name="MSSmartTagsPreventParsing" content="true">
<meta http-equiv="imagetoolbar" content="no">
<![endif]-->
<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="style/style_ie6.css">
<![endif]-->
<!--[if IE 7]>
<link rel="stylesheet" type="text/css" href="style/style_ie7.css">
<![endif]-->
<!--[if IE 8]>
<link rel="stylesheet" type="text/css" href="style/style_ie8.css">
<![endif]-->
<script src="scripts/superfish.js" type="text/javascript"></script>
<script src="scripts/narrow.js" type="text/javascript"></script>
</head>
<body class="" onload="CheckEmptyAndLoadList();">
<div class="header" id="qtdocheader">
<div class="content">
<div id="nav-logo">
<a href="index.html">Home</a></div>
<a href="index.html" class="qtref"><span>Qt Reference Documentation</span></a>
<div id="narrowsearch"></div>
<div id="nav-topright">
<ul>
<li class="nav-topright-home"><a href="http://qt.digia.com/">Qt HOME</a></li>
<li class="nav-topright-dev"><a href="http://qt-project.org/">DEV</a></li>
<li class="nav-topright-doc nav-topright-doc-active"><a href="http://qt-project.org/doc/">
DOC</a></li>
<li class="nav-topright-blog"><a href="http://blog.qt.digia.com/">BLOG</a></li>
</ul>
</div>
<div id="shortCut">
<ul>
<li class="shortCut-topleft-inactive"><span><a href="index.html">Qt 4.8</a></span></li>
<li class="shortCut-topleft-active"><a href="http://qt-project.org/doc/">ALL VERSIONS </a></li>
</ul>
</div>
<ul class="sf-menu" id="narrowmenu">
<li><a href="#">API Lookup</a>
<ul>
<li><a href="classes.html">Class index</a></li>
<li><a href="functions.html">Function index</a></li>
<li><a href="modules.html">Modules</a></li>
<li><a href="namespaces.html">Namespaces</a></li>
<li><a href="qtglobal.html">Global Declarations</a></li>
<li><a href="qdeclarativeelements.html">QML elements</a></li>
</ul>
</li>
<li><a href="#">Qt Topics</a>
<ul>
<li><a href="qt-basic-concepts.html">Programming with Qt</a></li>
<li><a href="qtquick.html">Device UIs & Qt Quick</a></li>
<li><a href="qt-gui-concepts.html">UI Design with Qt</a></li>
<li><a href="supported-platforms.html">Supported Platforms</a></li>
<li><a href="technology-apis.html">Qt and Key Technologies</a></li>
<li><a href="best-practices.html">How-To's and Best Practices</a></li>
</ul>
</li>
<li><a href="#">Examples</a>
<ul>
<li><a href="all-examples.html">Examples</a></li>
<li><a href="tutorials.html">Tutorials</a></li>
<li><a href="demos.html">Demos</a></li>
<li><a href="qdeclarativeexamples.html">QML Examples</a></li>
</ul>
</li>
</ul>
</div>
</div>
<div class="wrapper">
<div class="hd">
<span></span>
</div>
<div class="bd group">
<div class="sidebar">
<div class="searchlabel">
Search index:</div>
<div class="search" id="sidebarsearch">
<form id="qtdocsearch" action="" onsubmit="return false;">
<fieldset>
<input type="text" name="searchstring" id="pageType" value="" />
<div id="resultdialog">
<a href="#" id="resultclose">Close</a>
<p id="resultlinks" class="all"><a href="#" id="showallresults">All</a> | <a href="#" id="showapiresults">API</a> | <a href="#" id="showarticleresults">Articles</a> | <a href="#" id="showexampleresults">Examples</a></p>
<p id="searchcount" class="all"><span id="resultcount"></span><span id="apicount"></span><span id="articlecount"></span><span id="examplecount"></span> results:</p>
<ul id="resultlist" class="all">
</ul>
</div>
</fieldset>
</form>
</div>
<div class="box first bottombar" id="lookup">
<h2 title="API Lookup"><span></span>
API Lookup</h2>
<div id="list001" class="list">
<ul id="ul001" >
<li class="defaultLink"><a href="classes.html">Class index</a></li>
<li class="defaultLink"><a href="functions.html">Function index</a></li>
<li class="defaultLink"><a href="modules.html">Modules</a></li>
<li class="defaultLink"><a href="namespaces.html">Namespaces</a></li>
<li class="defaultLink"><a href="qtglobal.html">Global Declarations</a></li>
<li class="defaultLink"><a href="qdeclarativeelements.html">QML elements</a></li>
</ul>
</div>
</div>
<div class="box bottombar" id="topics">
<h2 title="Qt Topics"><span></span>
Qt Topics</h2>
<div id="list002" class="list">
<ul id="ul002" >
<li class="defaultLink"><a href="qt-basic-concepts.html">Programming with Qt</a></li>
<li class="defaultLink"><a href="qtquick.html">Device UIs & Qt Quick</a></li>
<li class="defaultLink"><a href="qt-gui-concepts.html">UI Design with Qt</a></li>
<li class="defaultLink"><a href="supported-platforms.html">Supported Platforms</a></li>
<li class="defaultLink"><a href="technology-apis.html">Qt and Key Technologies</a></li>
<li class="defaultLink"><a href="best-practices.html">How-To's and Best Practices</a></li>
</ul>
</div>
</div>
<div class="box" id="examples">
<h2 title="Examples"><span></span>
Examples</h2>
<div id="list003" class="list">
<ul id="ul003">
<li class="defaultLink"><a href="all-examples.html">Examples</a></li>
<li class="defaultLink"><a href="tutorials.html">Tutorials</a></li>
<li class="defaultLink"><a href="demos.html">Demos</a></li>
<li class="defaultLink"><a href="qdeclarativeexamples.html">QML Examples</a></li>
</ul>
</div>
</div>
</div>
<div class="wrap">
<div class="toolbar">
<div class="breadcrumb toolblock">
<ul>
<li class="first"><a href="index.html">Home</a></li>
<!-- Breadcrumbs go here -->
<li><a href="modules.html">Modules</a></li>
<li><a href="qt3support.html">Qt3Support</a></li>
<li>Q3SqlSelectCursor</li>
</ul>
</div>
<div class="toolbuttons toolblock">
<ul>
<li id="smallA" class="t_button">A</li>
<li id="medA" class="t_button active">A</li>
<li id="bigA" class="t_button">A</li>
<li id="print" class="t_button"><a href="javascript:this.print();">
<span>Print</span></a></li>
</ul>
</div>
</div>
<div class="content mainContent">
<div class="toc">
<h3><a name="toc">Contents</a></h3>
<ul>
<li class="level1"><a href="#public-functions">Public Functions</a></li>
<li class="level1"><a href="#protected-functions">Protected Functions</a></li>
<li class="level1"><a href="#details">Detailed Description</a></li>
</ul>
</div>
<h1 class="title">Q3SqlSelectCursor Class Reference</h1>
<!-- $$$Q3SqlSelectCursor-brief -->
<p>The Q3SqlSelectCursor class provides browsing of general SQL SELECT statements. <a href="#details">More...</a></p>
<!-- @@@Q3SqlSelectCursor -->
<pre class="cpp"> <span class="preprocessor">#include <Q3SqlSelectCursor></span></pre><p><b>This class is part of the Qt 3 support library.</b> It is provided to keep old source code working. We strongly advise against using it in new code. See <a href="porting4.html#qsqlselectcursor">Porting to Qt 4</a> for more information.</p>
<p><b>Inherits: </b><a href="q3sqlcursor.html">Q3SqlCursor</a>.</p>
<ul>
<li><a href="q3sqlselectcursor-members.html">List of all members, including inherited members</a></li>
</ul>
<a name="public-functions"></a>
<h2>Public Functions</h2>
<table class="alignedsummary">
<tr><td class="memItemLeft rightAlign topAlign"> </td><td class="memItemRight bottomAlign"><b><a href="q3sqlselectcursor.html#Q3SqlSelectCursor">Q3SqlSelectCursor</a></b> ( const QString & <i>query</i> = QString(), QSqlDatabase <i>db</i> = QSqlDatabase() )</td></tr>
<tr><td class="memItemLeft rightAlign topAlign"> </td><td class="memItemRight bottomAlign"><b><a href="q3sqlselectcursor.html#Q3SqlSelectCursor-2">Q3SqlSelectCursor</a></b> ( const Q3SqlSelectCursor & <i>other</i> )</td></tr>
<tr><td class="memItemLeft rightAlign topAlign"> </td><td class="memItemRight bottomAlign"><b><a href="q3sqlselectcursor.html#dtor.Q3SqlSelectCursor">~Q3SqlSelectCursor</a></b> ()</td></tr>
</table>
<ul>
<li class="fn">43 public functions inherited from <a href="q3sqlcursor.html#public-functions">Q3SqlCursor</a></li>
<li class="fn">28 public functions inherited from <a href="qsqlrecord.html#public-functions">QSqlRecord</a></li>
<li class="fn">38 public functions inherited from <a href="qsqlquery.html#public-functions">QSqlQuery</a></li>
</ul>
<a name="reimplemented-protected-functions"></a>
<h2>Reimplemented Protected Functions</h2>
<table class="alignedsummary">
<tr><td class="memItemLeft rightAlign topAlign"> virtual int </td><td class="memItemRight bottomAlign"><b><a href="q3sqlselectcursor.html#update">update</a></b> ( const QString & <i>filter</i>, bool <i>invalidate</i> = true )</td></tr>
</table>
<ul>
<li class="fn">7 protected functions inherited from <a href="q3sqlcursor.html#protected-functions">Q3SqlCursor</a></li>
</ul>
<a name="details"></a>
<!-- $$$Q3SqlSelectCursor-description -->
<div class="descr">
<h2>Detailed Description</h2>
<p>The Q3SqlSelectCursor class provides browsing of general SQL SELECT statements.</p>
<p>Q3SqlSelectCursor is a convenience class that makes it possible to display result sets from general SQL <tt>SELECT</tt> statements in data-aware Qt widgets. Q3SqlSelectCursor is read-only and does not support <tt>INSERT</tt>, <tt>UPDATE</tt> or <tt>DELETE</tt> operations.</p>
<p>Pass the query in at construction time, or use the <a href="q3sqlcursor.html#exec">Q3SqlSelectCursor::exec</a>() function.</p>
<p>Example:</p>
<pre class="cpp"> <span class="operator">.</span><span class="operator">.</span><span class="operator">.</span>
<span class="type">Q3SqlSelectCursor</span><span class="operator">*</span> cur <span class="operator">=</span> <span class="keyword">new</span> <span class="type">Q3SqlSelectCursor</span>(<span class="string">"SELECT id, firstname, lastname FROM author"</span>);
<span class="type"><a href="q3datatable.html">Q3DataTable</a></span><span class="operator">*</span> table <span class="operator">=</span> <span class="keyword">new</span> <span class="type"><a href="q3datatable.html">Q3DataTable</a></span>(<span class="keyword">this</span>);
table<span class="operator">-</span><span class="operator">></span>setSqlCursor(cur<span class="operator">,</span> <span class="keyword">true</span><span class="operator">,</span> <span class="keyword">true</span>);
table<span class="operator">-</span><span class="operator">></span>refresh();
<span class="operator">.</span><span class="operator">.</span><span class="operator">.</span>
cur<span class="operator">-</span><span class="operator">></span><a href="q3sqlcursor.html#exec">exec</a>(<span class="string">"SELECT * FROM books"</span>);
table<span class="operator">-</span><span class="operator">></span>refresh();
<span class="operator">.</span><span class="operator">.</span><span class="operator">.</span></pre>
</div>
<!-- @@@Q3SqlSelectCursor -->
<div class="func">
<h2>Member Function Documentation</h2>
<!-- $$$Q3SqlSelectCursor[overload1]$$$Q3SqlSelectCursorconstQString&QSqlDatabase -->
<h3 class="fn"><a name="Q3SqlSelectCursor"></a>Q3SqlSelectCursor::<span class="name">Q3SqlSelectCursor</span> ( const <span class="type"><a href="qstring.html">QString</a></span> & <i>query</i> = QString(), <span class="type"><a href="qsqldatabase.html">QSqlDatabase</a></span> <i>db</i> = QSqlDatabase() )</h3>
<p>Constructs a read only cursor on database <i>db</i> using the query <i>query</i>.</p>
<!-- @@@Q3SqlSelectCursor -->
<!-- $$$Q3SqlSelectCursor$$$Q3SqlSelectCursorconstQ3SqlSelectCursor& -->
<h3 class="fn"><a name="Q3SqlSelectCursor-2"></a>Q3SqlSelectCursor::<span class="name">Q3SqlSelectCursor</span> ( const <span class="type">Q3SqlSelectCursor</span> & <i>other</i> )</h3>
<p>Constructs a copy of <i>other</i></p>
<!-- @@@Q3SqlSelectCursor -->
<!-- $$$~Q3SqlSelectCursor[overload1]$$$~Q3SqlSelectCursor -->
<h3 class="fn"><a name="dtor.Q3SqlSelectCursor"></a>Q3SqlSelectCursor::<span class="name">~Q3SqlSelectCursor</span> ()</h3>
<p>Destroys the object and frees any allocated resources</p>
<!-- @@@~Q3SqlSelectCursor -->
<!-- $$$update[overload1]$$$updateconstQString&bool -->
<h3 class="fn"><a name="update"></a><span class="type">int</span> Q3SqlSelectCursor::<span class="name">update</span> ( const <span class="type"><a href="qstring.html">QString</a></span> & <i>filter</i>, <span class="type">bool</span> <i>invalidate</i> = true )<tt> [virtual protected]</tt></h3>
<p>Reimplemented from <a href="q3sqlcursor.html#update-2">Q3SqlCursor::update</a>().</p>
<p>This is an overloaded function.</p>
<p>Updates the database with the current contents of the cursor edit buffer using the specified <i>filter</i>. Returns the number of records which were updated. For error information, use <a href="qsqlquery.html#lastError">lastError</a>().</p>
<p>Only records which meet the filter criteria are updated, otherwise all records in the table are updated.</p>
<p>If <i>invalidate</i> is true (the default), the cursor can no longer be navigated. A new select() call must be made before you can move to a valid record.</p>
<p><b>See also </b><a href="q3sqlcursor.html#update">Q3SqlCursor::update</a>(), <a href="q3sqlcursor.html#primeUpdate">primeUpdate</a>(), <a href="q3sqlcursor.html#setMode">setMode</a>(), and <a href="qsqlquery.html#lastError">lastError</a>().</p>
<!-- @@@update -->
</div>
</div>
</div>
</div>
<div class="ft">
<span></span>
</div>
</div>
<div class="footer">
<p>
<acronym title="Copyright">©</acronym> 2015 The Qt Company Ltd.
Documentation contributions included herein are the copyrights of
their respective owners.</p>
<br />
<p>
The documentation provided herein is licensed under the terms of the
<a href="http://www.gnu.org/licenses/fdl.html">GNU Free Documentation
License version 1.3</a> as published by the Free Software Foundation.</p>
<p>
Documentation sources may be obtained from <a href="http://www.qt-project.org">
www.qt-project.org</a>.</p>
<br />
<p>
Qt and respective logos are trademarks of The Qt Company Ltd
in Finland and/or other countries worldwide. All other trademarks are property
of their respective owners. <a title="Privacy Policy"
href="http://en.gitorious.org/privacy_policy/">Privacy Policy</a></p>
</div>
<script src="scripts/functions.js" type="text/javascript"></script>
</body>
</html>
