<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<!-- q3sqlselectcursor.cpp -->
<head>
<title>Qt 4.6: Q3SqlSelectCursor Class Reference</title>
<link href="classic.css" rel="stylesheet" type="text/css" />
</head>
<body>
<a name="//apple_ref/cpp/cl//Q3SqlSelectCursor"></a>
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td align="left" valign="top" width="32"><a href="http://qt.nokia.com/"><img src="images/qt-logo.png" align="left" border="0" /></a></td>
<td width="1"> </td><td class="postheader" valign="center"><a href="index.html"><font color="#004faf">Home</font></a> · <a href="classes.html"><font color="#004faf">All Classes</font></a> · <a href="functions.html"><font color="#004faf">All Functions</font></a> · <a href="overviews.html"><font color="#004faf">Overviews</font></a></td></tr></table><h1 class="title">Q3SqlSelectCursor Class Reference<br /><span class="small-subtitle">[<a href="qt3support.html">Qt3Support</a> module]</span>
</h1>
<p>The Q3SqlSelectCursor class provides browsing of general SQL SELECT statements. <a href="#details">More...</a></p>
<pre> #include <Q3SqlSelectCursor></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>This class is not part of the Qt GUI Framework Edition.</b></p>
<p>Inherits <a href="q3sqlcursor.html">Q3SqlCursor</a>.</p>
<ul>
<li><a href="q3sqlselectcursor-members.html">List of all members, including inherited members</a></li>
</ul>
<hr />
<a name="public-functions"></a>
<h2>Public Functions</h2>
<table class="alignedsummary" border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td class="memItemLeft" align="right" valign="top"></td><td class="memItemRight" valign="bottom"><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" align="right" valign="top"></td><td class="memItemRight" valign="bottom"><b><a href="q3sqlselectcursor.html#Q3SqlSelectCursor-2">Q3SqlSelectCursor</a></b> ( const Q3SqlSelectCursor & <i>other</i> )</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"></td><td class="memItemRight" valign="bottom"><b><a href="q3sqlselectcursor.html#dtor.Q3SqlSelectCursor">~Q3SqlSelectCursor</a></b> ()</td></tr>
</table>
<ul>
<li><div bar="2" class="fn"></div>43 public functions inherited from <a href="q3sqlcursor.html#public-functions">Q3SqlCursor</a></li>
<li><div bar="2" class="fn"></div>28 public functions inherited from <a href="qsqlrecord.html#public-functions">QSqlRecord</a></li>
<li><div bar="2" class="fn"></div>38 public functions inherited from <a href="qsqlquery.html#public-functions">QSqlQuery</a></li>
</ul>
<hr />
<a name="reimplemented-protected-functions"></a>
<h2>Reimplemented Protected Functions</h2>
<table class="alignedsummary" border="0" cellpadding="0" cellspacing="0" width="100%">
<tr><td class="memItemLeft" align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><b><a href="q3sqlselectcursor.html#update">update</a></b> ( const QString & <i>filter</i>, bool <i>invalidate</i> = true )</td></tr>
</table>
<ul>
<li><div bar="2" class="fn"></div>7 protected functions inherited from <a href="q3sqlcursor.html#protected-functions">Q3SqlCursor</a></li>
</ul>
<a name="details"></a>
<hr />
<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> ...
Q3SqlSelectCursor* cur = new Q3SqlSelectCursor("SELECT id, firstname, lastname FROM author");
Q3DataTable* table = new Q3DataTable(this);
table->setSqlCursor(cur, true, true);
table->refresh();
...
cur->exec("SELECT * FROM books");
table->refresh();
...</pre>
<hr />
<h2>Member Function Documentation</h2>
<a name="//apple_ref/cpp/instm/Q3SqlSelectCursor/Q3SqlSelectCursor"></a>
<h3 class="fn"><a name="Q3SqlSelectCursor"></a>Q3SqlSelectCursor::Q3SqlSelectCursor ( const <a href="qstring.html">QString</a> & <i>query</i> = QString(), <a href="qsqldatabase.html">QSqlDatabase</a> <i>db</i> = QSqlDatabase() )</h3>
<p>Constructs a read only cursor on database <i>db</i> using the query <i>query</i>.</p>
<h3 class="fn"><a name="Q3SqlSelectCursor-2"></a>Q3SqlSelectCursor::Q3SqlSelectCursor ( const Q3SqlSelectCursor & <i>other</i> )</h3>
<p>Constructs a copy of <i>other</i></p>
<a name="//apple_ref/cpp/instm/Q3SqlSelectCursor/~Q3SqlSelectCursor"></a>
<h3 class="fn"><a name="dtor.Q3SqlSelectCursor"></a>Q3SqlSelectCursor::~Q3SqlSelectCursor ()</h3>
<p>Destroys the object and frees any allocated resources</p>
<a name="//apple_ref/cpp/instm/Q3SqlSelectCursor/update"></a>
<h3 class="fn"><a name="update"></a>int Q3SqlSelectCursor::update ( const <a href="qstring.html">QString</a> & <i>filter</i>, bool <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>See also <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>
<p /><address><hr /><div align="center">
<table width="100%" cellspacing="0" border="0"><tr class="address">
<td width="40%" align="left">Copyright © 2010 Nokia Corporation and/or its subsidiary(-ies)</td>
<td width="20%" align="center"><a href="trademarks.html">Trademarks</a></td>
<td width="40%" align="right"><div align="right">Qt 4.6.3</div></td>
</tr></table></div></address></body>
</html>
distrib
>
Mandriva
>
current
>
i586
>
media
>
main-updates
>
by-pkgid
>
8e6051afcdb111a0317a58fb64c2abf5
>
files
>
3509
