<?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" />
<!-- qsql.qdoc -->
<title>Qt 4.8: QSql Namespace</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="namespaces.html">Namespaces</a></li>
<li>QSql Namespace</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="#types">Types</a></li>
<li class="level1"><a href="#details">Detailed Description</a></li>
</ul>
</div>
<h1 class="title">QSql Namespace</h1>
<!-- $$$QSql-brief -->
<p>The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library. <a href="#details">More...</a></p>
<!-- @@@QSql -->
<pre class="cpp"> <span class="preprocessor">#include <<a href="qtsql.html">QtSql</a>></span></pre><ul>
<li><a href="qsql-qt3.html">Qt 3 support members</a></li>
</ul>
<a name="types"></a>
<h2>Types</h2>
<table class="alignedsummary">
<tr><td class="memItemLeft rightAlign topAlign"> enum </td><td class="memItemRight bottomAlign"><b><a href="qsql.html#Location-enum">Location</a></b> { BeforeFirstRow, AfterLastRow }</td></tr>
<tr><td class="memItemLeft rightAlign topAlign"> enum </td><td class="memItemRight bottomAlign"><b><a href="qsql.html#NumericalPrecisionPolicy-enum">NumericalPrecisionPolicy</a></b> { LowPrecisionInt32, LowPrecisionInt64, LowPrecisionDouble, HighPrecision }</td></tr>
<tr><td class="memItemLeft rightAlign topAlign"> flags </td><td class="memItemRight bottomAlign"><b><a href="qsql.html#ParamTypeFlag-enum">ParamType</a></b></td></tr>
<tr><td class="memItemLeft rightAlign topAlign"> enum </td><td class="memItemRight bottomAlign"><b><a href="qsql.html#ParamTypeFlag-enum">ParamTypeFlag</a></b> { In, Out, InOut, Binary }</td></tr>
<tr><td class="memItemLeft rightAlign topAlign"> enum </td><td class="memItemRight bottomAlign"><b><a href="qsql.html#TableType-enum">TableType</a></b> { Tables, SystemTables, Views, AllTables }</td></tr>
</table>
<a name="details"></a>
<!-- $$$QSql-description -->
<div class="descr">
<h2>Detailed Description</h2>
<p>The QSql namespace contains miscellaneous identifiers used throughout the Qt SQL library.</p>
</div>
<p><b>See also </b><a href="qtsql.html">QtSql Module</a>.</p>
<!-- @@@QSql -->
<div class="types">
<h2>Type Documentation</h2>
<!-- $$$Location$$$BeforeFirstRow$$$AfterLastRow$$$BeforeFirst$$$AfterLast -->
<h3 class="fn"><a name="Location-enum"></a>enum QSql::<span class="name">Location</span></h3>
<p>This enum type describes special SQL navigation locations:</p>
<table class="valuelist"><tr valign="top" class="odd"><th class="tblConst">Constant</th><th class="tblval">Value</th><th class="tbldscr">Description</th></tr>
<tr><td class="topAlign"><tt>QSql::BeforeFirstRow</tt></td><td class="topAlign"><tt>-1</tt></td><td class="topAlign">Before the first record.</td></tr>
<tr><td class="topAlign"><tt>QSql::AfterLastRow</tt></td><td class="topAlign"><tt>-2</tt></td><td class="topAlign">After the last record.</td></tr>
</table>
<p><b>See also </b><a href="qsqlquery.html#at">QSqlQuery::at</a>().</p>
<!-- @@@Location -->
<!-- $$$NumericalPrecisionPolicy$$$LowPrecisionInt32$$$LowPrecisionInt64$$$LowPrecisionDouble$$$HighPrecision -->
<h3 class="fn"><a name="NumericalPrecisionPolicy-enum"></a>enum QSql::<span class="name">NumericalPrecisionPolicy</span></h3>
<p>Numerical values in a database can have precisions greater than their corresponding C++ types. This enum lists the policies for representing such values in the application.</p>
<table class="valuelist"><tr valign="top" class="odd"><th class="tblConst">Constant</th><th class="tblval">Value</th><th class="tbldscr">Description</th></tr>
<tr><td class="topAlign"><tt>QSql::LowPrecisionInt32</tt></td><td class="topAlign"><tt>0x01</tt></td><td class="topAlign">Force 32bit integer values. In case of floating point numbers, the fractional part is silently discarded.</td></tr>
<tr><td class="topAlign"><tt>QSql::LowPrecisionInt64</tt></td><td class="topAlign"><tt>0x02</tt></td><td class="topAlign">Force 64bit integer values. In case of floating point numbers, the fractional part is silently discarded.</td></tr>
<tr><td class="topAlign"><tt>QSql::LowPrecisionDouble</tt></td><td class="topAlign"><tt>0x04</tt></td><td class="topAlign">Force <tt>double</tt> values. This is the default policy.</td></tr>
<tr><td class="topAlign"><tt>QSql::HighPrecision</tt></td><td class="topAlign"><tt>0</tt></td><td class="topAlign">Strings will be used to preserve precision.</td></tr>
</table>
<p>Note: The actual behaviour if an overflow occurs is driver specific. The Oracle database just returns an error in this case.</p>
<!-- @@@NumericalPrecisionPolicy -->
<!-- $$$ParamTypeFlag$$$In$$$Out$$$InOut$$$Binary -->
<h3 class="flags"><a name="ParamTypeFlag-enum"></a>enum QSql::<span class="name">ParamTypeFlag</span><br/>flags QSql::<span class="name">ParamType</span></h3>
<p>This enum is used to specify the type of a bind parameter.</p>
<table class="valuelist"><tr valign="top" class="odd"><th class="tblConst">Constant</th><th class="tblval">Value</th><th class="tbldscr">Description</th></tr>
<tr><td class="topAlign"><tt>QSql::In</tt></td><td class="topAlign"><tt>0x00000001</tt></td><td class="topAlign">The bind parameter is used to put data into the database.</td></tr>
<tr><td class="topAlign"><tt>QSql::Out</tt></td><td class="topAlign"><tt>0x00000002</tt></td><td class="topAlign">The bind parameter is used to receive data from the database.</td></tr>
<tr><td class="topAlign"><tt>QSql::InOut</tt></td><td class="topAlign"><tt>In | Out</tt></td><td class="topAlign">The bind parameter is used to put data into the database; it will be overwritten with output data on executing a query.</td></tr>
<tr><td class="topAlign"><tt>QSql::Binary</tt></td><td class="topAlign"><tt>0x00000004</tt></td><td class="topAlign">This must be OR'd with one of the other flags if you want to indicate that the data being transferred is raw binary data.</td></tr>
</table>
<p>The ParamType type is a typedef for <a href="qflags.html">QFlags</a><ParamTypeFlag>. It stores an OR combination of ParamTypeFlag values.</p>
<!-- @@@ParamTypeFlag -->
<!-- $$$TableType$$$Tables$$$SystemTables$$$Views$$$AllTables -->
<h3 class="fn"><a name="TableType-enum"></a>enum QSql::<span class="name">TableType</span></h3>
<p>This enum type describes types of SQL tables.</p>
<table class="valuelist"><tr valign="top" class="odd"><th class="tblConst">Constant</th><th class="tblval">Value</th><th class="tbldscr">Description</th></tr>
<tr><td class="topAlign"><tt>QSql::Tables</tt></td><td class="topAlign"><tt>0x01</tt></td><td class="topAlign">All the tables visible to the user.</td></tr>
<tr><td class="topAlign"><tt>QSql::SystemTables</tt></td><td class="topAlign"><tt>0x02</tt></td><td class="topAlign">Internal tables used by the database.</td></tr>
<tr><td class="topAlign"><tt>QSql::Views</tt></td><td class="topAlign"><tt>0x04</tt></td><td class="topAlign">All the views visible to the user.</td></tr>
<tr><td class="topAlign"><tt>QSql::AllTables</tt></td><td class="topAlign"><tt>0xff</tt></td><td class="topAlign">All of the above.</td></tr>
</table>
<!-- @@@TableType -->
</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>
