<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>VTK: vtkSQLQuery Class Reference</title>
<link href="doxygen.css" rel="stylesheet" type="text/css">
<link href="tabs.css" rel="stylesheet" type="text/css">
</head><body>
<!-- Generated by Doxygen 1.5.6 -->
<div class="navigation" id="top">
<div class="tabs">
<ul>
<li><a href="index.html"><span>Main Page</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li class="current"><a href="classes.html"><span>Classes</span></a></li>
<li><a href="files.html"><span>Files</span></a></li>
</ul>
</div>
<div class="tabs">
<ul>
<li><a href="classes.html"><span>Alphabetical List</span></a></li>
<li><a href="annotated.html"><span>Class List</span></a></li>
<li><a href="hierarchy.html"><span>Class Hierarchy</span></a></li>
<li><a href="functions.html"><span>Class Members</span></a></li>
</ul>
</div>
</div>
<div class="contents">
<h1>vtkSQLQuery Class Reference</h1><!-- doxytag: class="vtkSQLQuery" --><!-- doxytag: inherits="vtkRowQuery" --><code>#include <<a class="el" href="a04988.html">vtkSQLQuery.h</a>></code>
<p>
<div class="dynheader">
Inheritance diagram for vtkSQLQuery:</div>
<div class="dynsection">
<p><center><img src="a14703.png" border="0" usemap="#a14704" alt="Inheritance graph"></center>
<map name="a14704">
<area shape="rect" href="a01077.html" title="vtkSQLQuery implementation for MySQL databases" alt="" coords="5,304,128,331"><area shape="rect" href="a01094.html" title="vtkSQLQuery implementation for ODBC connections to databases" alt="" coords="152,304,267,331"><area shape="rect" href="a01290.html" title="vtkSQLQuery implementation for PostgreSQL databases" alt="" coords="291,304,443,331"><area shape="rect" href="a01599.html" title="vtkSQLQuery implementation for SQLite databases" alt="" coords="467,304,584,331"><area shape="rect" href="a01501.html" title="abstract interface for queries that return row-oriented results." alt="" coords="236,155,340,181"><area shape="rect" href="a01084.html" title="abstract base class for most VTK objects" alt="" coords="248,80,328,107"><area shape="rect" href="a01085.html" title="abstract base class for most VTK objects" alt="" coords="233,5,343,32"></map>
<center><font size="2">[<a href="graph_legend.html">legend</a>]</font></center></div>
<div class="dynheader">
Collaboration diagram for vtkSQLQuery:</div>
<div class="dynsection">
<p><center><img src="a14705.png" border="0" usemap="#a14706" alt="Collaboration graph"></center>
<map name="a14706">
<area shape="rect" href="a01501.html" title="abstract interface for queries that return row-oriented results." alt="" coords="32,173,136,200"><area shape="rect" href="a01084.html" title="abstract base class for most VTK objects" alt="" coords="87,96,167,123"><area shape="rect" href="a01593.html" title="maintain a connection to an sql database" alt="" coords="160,173,286,200"><area shape="rect" href="a01085.html" title="abstract base class for most VTK objects" alt="" coords="6,5,115,32"><area shape="rect" href="a01719.html" title="record modification and/or execution time" alt="" coords="139,5,248,32"></map>
<center><font size="2">[<a href="graph_legend.html">legend</a>]</font></center></div>
<p>
<a href="a14707.html">List of all members.</a><hr><a name="_details"></a><h2>Detailed Description</h2>
executes an sql query and retrieves results
<p>
The abstract superclass of SQL query classes. Instances of subclasses of <a class="el" href="a01600.html" title="executes an sql query and retrieves results">vtkSQLQuery</a> are created using the GetQueryInstance() function in <a class="el" href="a01593.html" title="maintain a connection to an sql database">vtkSQLDatabase</a>. To implement a query connection for a new database type, subclass both <a class="el" href="a01593.html" title="maintain a connection to an sql database">vtkSQLDatabase</a> and <a class="el" href="a01600.html" title="executes an sql query and retrieves results">vtkSQLQuery</a>, and implement the required functions. For the query class, this involves the following:<p>
<a class="el" href="a01600.html#acf882b154ebcb4a8c849ff0b244c824">Execute()</a> - Execute the query on the database. No results need to be retrieved at this point, unless you are performing caching.<p>
<a class="el" href="a01501.html#2e649f564b8022061bf048b97871c09f">GetNumberOfFields()</a> - After <a class="el" href="a01600.html#acf882b154ebcb4a8c849ff0b244c824">Execute()</a> is performed, returns the number of fields in the query results.<p>
<a class="el" href="a01501.html#6485ddb0ac5dae932f2150eaa118bd54">GetFieldName()</a> - The name of the field at an index.<p>
<a class="el" href="a01501.html#95f480d432048b4faccfe65bbcb49a75">GetFieldType()</a> - The data type of the field at an index.<p>
<a class="el" href="a01501.html#46bdd49f8333a1554c7e3bcc7fc9838b">NextRow()</a> - Advances the query results by one row, and returns whether there are more rows left in the query.<p>
<a class="el" href="a01501.html#45381c8cba3c83e915e96c24ef81982d">DataValue()</a> - Extract a single data value from the current row.<p>
Begin/Rollback/CommitTransaction() - These methods are optional but recommended if the database supports transactions.<p>
<dl class="user" compact><dt><b>Thanks:</b></dt><dd>Thanks to Andrew Wilson from Sandia National Laboratories for his work on the database classes.</dd></dl>
<dl class="see" compact><dt><b>See also:</b></dt><dd><a class="el" href="a01593.html" title="maintain a connection to an sql database">vtkSQLDatabase</a></dd></dl>
<dl class="user" compact><dt><b>Tests:</b></dt><dd><a class="el" href="c2_vtk_t_15.html#c2_vtk_t_vtkSQLQuery">vtkSQLQuery (Tests)</a> </dd></dl>
<p>Definition at line <a class="el" href="a04988.html#l00069">69</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
<table border="0" cellpadding="0" cellspacing="0">
<tr><td></td></tr>
<tr><td colspan="2"><br><h2>Public Types</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">typedef <a class="el" href="a01501.html">vtkRowQuery</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#463ba6c18eabb8bac337a20d40becf47">Superclass</a></td></tr>
<tr><td colspan="2"><br><h2>Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#057ad6e70d58dc7b96911d44b38c055f">GetClassName</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#63df5a6a1174f74914c7e6582d0b3dc0">IsA</a> (const char *type)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#ac1760bd9a271316101d40e36ddf8b53">PrintSelf</a> (ostream &os, <a class="el" href="a00869.html">vtkIndent</a> indent)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#5e3240eed58d3cce500553c3b236d40b">IsActive</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#acf882b154ebcb4a8c849ff0b244c824">Execute</a> ()=0</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#2885bbc0ceae7eb122ad4248e51ef7a3">BindParameter</a> (int index, unsigned char value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#e869e847728d21a6a8bf38adb07e61cc">BindParameter</a> (int index, unsigned short value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#e356e5ef69fb26441278bc8adf521eb4">BindParameter</a> (int index, unsigned int value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#579a4289665dec1726833c5944a2f90c">BindParameter</a> (int index, unsigned long value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#5ff157876e7192a0d5e2cb6ce9749c8f">BindParameter</a> (int index, signed char value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#a0a015f6371ebfb74694ed979c978431">BindParameter</a> (int index, short value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#55510d96a82492ac6512e6a1b7ed220a">BindParameter</a> (int index, int value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#4776664f47265f6109479968db9a671e">BindParameter</a> (int index, long value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#2e01bb15627ec03f87826514b1792964">BindParameter</a> (int index, vtkTypeUInt64 value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#d27dc7fbf73c3e03a22492e1d06f41d8">BindParameter</a> (int index, vtkTypeInt64 value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#301b395b8de505c50a5411570bcbe421">BindParameter</a> (int index, float value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#e60173cf157d6a02ad0c5a6c0b47b192">BindParameter</a> (int index, double value)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#d6b1ac047538b48082ac8891269793ce">BindParameter</a> (int index, const <a class="el" href="a01607.html">vtkStdString</a> &string)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#78f526e0c53acfb8543b5533eb9170f2">BindParameter</a> (int index, <a class="el" href="a01810.html">vtkVariant</a> var)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#948d8fb7c6f1b6f2733a2c93a53da3fc">EscapeString</a> (const char *src, bool addSurroundingQuotes)</td></tr>
<tr><td colspan="2"><div class="groupHeader"></div></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#deaeef015320802cea4ab41060d02aa7">SetQuery</a> (const char *query)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual const char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#3902511eabb70b3fd1564afcccaeb2a8">GetQuery</a> ()</td></tr>
<tr><td colspan="2"><div class="groupHeader"></div></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#4126f4402c301fad9a2e8f3c0bc3d327">BeginTransaction</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#313d1d9107da10d3b3f56922f761f0cc">CommitTransaction</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#d55429a7c25b716399d16387f90edaab">RollbackTransaction</a> ()</td></tr>
<tr><td colspan="2"><div class="groupHeader"></div></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual <a class="el" href="a01593.html">vtkSQLDatabase</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#5b7a5fbe9c41ea7e09387f7ce82efca3">GetDatabase</a> ()</td></tr>
<tr><td colspan="2"><div class="groupHeader"></div></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#a70fa32ebf93c6eb92687ca3ac798e77">BindParameter</a> (int index, const char *stringValue)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#2e3fe066a77dd69f275b60d38fd9764c">BindParameter</a> (int index, const char *stringValue, size_t length)</td></tr>
<tr><td colspan="2"><div class="groupHeader"></div></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#36b23602c14ce8df8b4d7ce0f998a7e4">BindParameter</a> (int index, const void *data, size_t length)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#b922b8db82ec2a90282a41283ef2554b">ClearParameterBindings</a> ()</td></tr>
<tr><td colspan="2"><div class="groupHeader"></div></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual <a class="el" href="a01607.html">vtkStdString</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#fde168634825c3dc579ecfb7e94792a7">EscapeString</a> (<a class="el" href="a01607.html">vtkStdString</a> s, bool addSurroundingQuotes=true)</td></tr>
<tr><td colspan="2"><br><h2>Static Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">static int </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#a946d75b48de97e083b36e8019e9faad">IsTypeOf</a> (const char *type)</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">static <a class="el" href="a01600.html">vtkSQLQuery</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#69276eb33ba612d2d2924169b23eb8ed">SafeDownCast</a> (<a class="el" href="a01084.html">vtkObject</a> *o)</td></tr>
<tr><td colspan="2"><br><h2>Protected Member Functions</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#a3fd7447f48d418044e8609de17cf93d">vtkSQLQuery</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#0a8fd97ae7b8d20bebdc5b83f7cabed7">~vtkSQLQuery</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#67957febc145a682439e4f33055a18c2">SetDatabase</a> (<a class="el" href="a01593.html">vtkSQLDatabase</a> *db)</td></tr>
<tr><td colspan="2"><br><h2>Protected Attributes</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">char * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#26110d3038fa066688709b1fa65b3ef1">Query</a></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="el" href="a01593.html">vtkSQLDatabase</a> * </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#d44f81a1c46f673fd0c3a64c2b1cdc05">Database</a></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="a01600.html#49bfd7fdb66092ab52d8b550d5f28672">Active</a></td></tr>
</table>
<hr><h2>Member Typedef Documentation</h2>
<a class="anchor" name="463ba6c18eabb8bac337a20d40becf47"></a><!-- doxytag: member="vtkSQLQuery::Superclass" ref="463ba6c18eabb8bac337a20d40becf47" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">typedef <a class="el" href="a01501.html">vtkRowQuery</a> <a class="el" href="a01501.html">vtkSQLQuery::Superclass</a> </td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented from <a class="el" href="a01501.html#5c0a1ff521d12f8351d95bd941d8c5c4">vtkRowQuery</a>.</p>
<p>Reimplemented in <a class="el" href="a01077.html#6d5a030c90dfceba605aa6f35e821cb5">vtkMySQLQuery</a>, <a class="el" href="a01094.html#a7100008a35414ff8080993fd75b3549">vtkODBCQuery</a>, <a class="el" href="a01290.html#7a7e21c72483dd05c703feb2d9742989">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#2661c3f79bc9be7432d2f84e9c4fce0c">vtkSQLiteQuery</a>.</p>
<p>Definition at line <a class="el" href="a04988.html#l00072">72</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<hr><h2>Constructor & Destructor Documentation</h2>
<a class="anchor" name="a3fd7447f48d418044e8609de17cf93d"></a><!-- doxytag: member="vtkSQLQuery::vtkSQLQuery" ref="a3fd7447f48d418044e8609de17cf93d" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">vtkSQLQuery::vtkSQLQuery </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
</div>
</div><p>
<a class="anchor" name="0a8fd97ae7b8d20bebdc5b83f7cabed7"></a><!-- doxytag: member="vtkSQLQuery::~vtkSQLQuery" ref="0a8fd97ae7b8d20bebdc5b83f7cabed7" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">vtkSQLQuery::~vtkSQLQuery </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
</div>
</div><p>
<hr><h2>Member Function Documentation</h2>
<a class="anchor" name="057ad6e70d58dc7b96911d44b38c055f"></a><!-- doxytag: member="vtkSQLQuery::GetClassName" ref="057ad6e70d58dc7b96911d44b38c055f" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual const char* vtkSQLQuery::GetClassName </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented from <a class="el" href="a01501.html#48b2172ebf421d764ee70833b1091876">vtkRowQuery</a>.</p>
<p>Reimplemented in <a class="el" href="a01077.html#caf8cd21bbbde334a70a48718b89f1bd">vtkMySQLQuery</a>, <a class="el" href="a01094.html#b76ce31c05e952f43359b1ac53c6e964">vtkODBCQuery</a>, <a class="el" href="a01290.html#8b3a8c616ff124765c5f0ee251d193fb">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#185dc5422aad9f12fd3e60bc4973f5c6">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="a946d75b48de97e083b36e8019e9faad"></a><!-- doxytag: member="vtkSQLQuery::IsTypeOf" ref="a946d75b48de97e083b36e8019e9faad" args="(const char *type)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static int vtkSQLQuery::IsTypeOf </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>name</em> </td>
<td> ) </td>
<td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Return 1 if this class type is the same type of (or a subclass of) the named class. Returns 0 otherwise. This method works in combination with vtkTypeRevisionMacro found in vtkSetGet.h.
<p>Reimplemented from <a class="el" href="a01501.html#646150654be158f0067de43241828ec7">vtkRowQuery</a>.</p>
<p>Reimplemented in <a class="el" href="a01077.html#cda1bb03eee1a064ec2609912a2ea78a">vtkMySQLQuery</a>, <a class="el" href="a01094.html#562499ec5269801bb7014f4f132e7401">vtkODBCQuery</a>, <a class="el" href="a01290.html#fd0abb56ebb4f56d9893700eebee1a44">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#a0c8b3b31b9fed470ec18515ed580ff3">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="63df5a6a1174f74914c7e6582d0b3dc0"></a><!-- doxytag: member="vtkSQLQuery::IsA" ref="63df5a6a1174f74914c7e6582d0b3dc0" args="(const char *type)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual int vtkSQLQuery::IsA </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>name</em> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Return 1 if this class is the same type of (or a subclass of) the named class. Returns 0 otherwise. This method works in combination with vtkTypeRevisionMacro found in vtkSetGet.h.
<p>Reimplemented from <a class="el" href="a01501.html#0ae30239cc9adee1756ab29537e3ddcc">vtkRowQuery</a>.</p>
<p>Reimplemented in <a class="el" href="a01077.html#d1205ebb8c9320e94528ae86f5bb25d0">vtkMySQLQuery</a>, <a class="el" href="a01094.html#a7e726cc16b6791caa3304bdfa0bf521">vtkODBCQuery</a>, <a class="el" href="a01290.html#41b970565c6cdaa7b89c3b1fc5232174">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#f2bb8421515cac719544086c3e5e7e51">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="69276eb33ba612d2d2924169b23eb8ed"></a><!-- doxytag: member="vtkSQLQuery::SafeDownCast" ref="69276eb33ba612d2d2924169b23eb8ed" args="(vtkObject *o)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static <a class="el" href="a01600.html">vtkSQLQuery</a>* vtkSQLQuery::SafeDownCast </td>
<td>(</td>
<td class="paramtype"><a class="el" href="a01084.html">vtkObject</a> * </td>
<td class="paramname"> <em>o</em> </td>
<td> ) </td>
<td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented from <a class="el" href="a01501.html#5a5842bfb09a1d75a571d1d3122b4a9d">vtkRowQuery</a>.</p>
<p>Reimplemented in <a class="el" href="a01077.html#3b767588d2271cc01713a3458aac8dfa">vtkMySQLQuery</a>, <a class="el" href="a01094.html#290beed5ac7eb92db4c1a2caf43e25a2">vtkODBCQuery</a>, <a class="el" href="a01290.html#3981039ebfb167c84e85606763fc5f69">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#51aa24d7314aa0e37a4795506955145a">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="ac1760bd9a271316101d40e36ddf8b53"></a><!-- doxytag: member="vtkSQLQuery::PrintSelf" ref="ac1760bd9a271316101d40e36ddf8b53" args="(ostream &os, vtkIndent indent)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void vtkSQLQuery::PrintSelf </td>
<td>(</td>
<td class="paramtype">ostream & </td>
<td class="paramname"> <em>os</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="a00869.html">vtkIndent</a> </td>
<td class="paramname"> <em>indent</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Methods invoked by print to print information about the object including superclasses. Typically not called by the user (use <a class="el" href="a01085.html#edadf6378465fd81c2592ef64262e2a5">Print()</a> instead) but used in the hierarchical print process to combine the output of several classes.
<p>Reimplemented from <a class="el" href="a01501.html#8a9740b30c89bf69e50103f940ec209b">vtkRowQuery</a>.</p>
<p>Reimplemented in <a class="el" href="a01077.html#2e7d2715572e9b25df62c0588eed6d79">vtkMySQLQuery</a>, <a class="el" href="a01094.html#127d899e04382115cbd2e438343b61f7">vtkODBCQuery</a>, <a class="el" href="a01290.html#cecece21000d14b33102b4e6d1af5be4">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#468c5eb5e6e6b51b3f96950eab639da9">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="deaeef015320802cea4ab41060d02aa7"></a><!-- doxytag: member="vtkSQLQuery::SetQuery" ref="deaeef015320802cea4ab41060d02aa7" args="(const char *query)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::SetQuery </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>query</em> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
The query string to be executed. Since some databases will process the query string as soon as it's set, this method returns a boolean to indicate success or failure.
<p>Reimplemented in <a class="el" href="a01077.html#202b414fe2601f765a2778a7a4378a5a">vtkMySQLQuery</a>, <a class="el" href="a01094.html#29730fb2d82f38b44797cc0850886cde">vtkODBCQuery</a>, and <a class="el" href="a01599.html#7f3e8c15cdc6561a818be781b81d3f3f">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="3902511eabb70b3fd1564afcccaeb2a8"></a><!-- doxytag: member="vtkSQLQuery::GetQuery" ref="3902511eabb70b3fd1564afcccaeb2a8" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual const char* vtkSQLQuery::GetQuery </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
The query string to be executed. Since some databases will process the query string as soon as it's set, this method returns a boolean to indicate success or failure.
<p>Reimplemented in <a class="el" href="a01094.html#9e17e2c05589320c694918881481ae80">vtkODBCQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="5e3240eed58d3cce500553c3b236d40b"></a><!-- doxytag: member="vtkSQLQuery::IsActive" ref="5e3240eed58d3cce500553c3b236d40b" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool vtkSQLQuery::IsActive </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [inline, virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Return true if the query is active (i.e. execution was successful and results are ready to be fetched). Returns false on error or inactive query.
<p>Implements <a class="el" href="a01501.html#768983b8ab8cf7a66b5ce56ad8506956">vtkRowQuery</a>.</p>
<p>Definition at line <a class="el" href="a04988.html#l00086">86</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<a class="anchor" name="acf882b154ebcb4a8c849ff0b244c824"></a><!-- doxytag: member="vtkSQLQuery::Execute" ref="acf882b154ebcb4a8c849ff0b244c824" args="()=0" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::Execute </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [pure virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Execute the query. This must be performed before any field name or data access functions are used.
<p>Implements <a class="el" href="a01501.html#b0ba19b40366f0f884b28d04e5434d4d">vtkRowQuery</a>.</p>
<p>Implemented in <a class="el" href="a01077.html#92e8a890f519fc1b206cbfecd8efbcec">vtkMySQLQuery</a>, <a class="el" href="a01094.html#13429810219b36ccc12c7cf9ddfc1860">vtkODBCQuery</a>, <a class="el" href="a01290.html#94132078e6c3f08ec202ae4f625611e5">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#6bd8611a4543637ac7a1ae231d3a69b3">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="4126f4402c301fad9a2e8f3c0bc3d327"></a><!-- doxytag: member="vtkSQLQuery::BeginTransaction" ref="4126f4402c301fad9a2e8f3c0bc3d327" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BeginTransaction </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [inline, virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Begin, commit, or roll back a transaction. If the underlying database does not support transactions these calls will do nothing.
<p>Reimplemented in <a class="el" href="a01094.html#0e10f2e9f291f6c293fdff1a1d904007">vtkODBCQuery</a>, <a class="el" href="a01290.html#9486790dfa013af7fee2038b7a2f2888">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#7e2c187892f16fbac3456ea4a378346b">vtkSQLiteQuery</a>.</p>
<p>Definition at line <a class="el" href="a04988.html#l00095">95</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<a class="anchor" name="313d1d9107da10d3b3f56922f761f0cc"></a><!-- doxytag: member="vtkSQLQuery::CommitTransaction" ref="313d1d9107da10d3b3f56922f761f0cc" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::CommitTransaction </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [inline, virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Begin, commit, or roll back a transaction. If the underlying database does not support transactions these calls will do nothing.
<p>Reimplemented in <a class="el" href="a01094.html#86eb0ef8a4d6cc9c7872ae293441daff">vtkODBCQuery</a>, <a class="el" href="a01290.html#680da9dbd903c549c341f0a1d6f6627f">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#767eb15429cd419b26be1a7372bf9000">vtkSQLiteQuery</a>.</p>
<p>Definition at line <a class="el" href="a04988.html#l00096">96</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<a class="anchor" name="d55429a7c25b716399d16387f90edaab"></a><!-- doxytag: member="vtkSQLQuery::RollbackTransaction" ref="d55429a7c25b716399d16387f90edaab" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::RollbackTransaction </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [inline, virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Begin, commit, or roll back a transaction. If the underlying database does not support transactions these calls will do nothing.
<p>Reimplemented in <a class="el" href="a01094.html#a0be7d3bf1ad1929c8b2f6fb0d190ce9">vtkODBCQuery</a>, <a class="el" href="a01290.html#b0c984e2774e27b5f1236cd3505eedde">vtkPostgreSQLQuery</a>, and <a class="el" href="a01599.html#b8154af1545e7cb1acdf48328374b106">vtkSQLiteQuery</a>.</p>
<p>Definition at line <a class="el" href="a04988.html#l00097">97</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<a class="anchor" name="5b7a5fbe9c41ea7e09387f7ce82efca3"></a><!-- doxytag: member="vtkSQLQuery::GetDatabase" ref="5b7a5fbe9c41ea7e09387f7ce82efca3" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual <a class="el" href="a01593.html">vtkSQLDatabase</a>* vtkSQLQuery::GetDatabase </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Return the database associated with the query.
</div>
</div><p>
<a class="anchor" name="2885bbc0ceae7eb122ad4248e51ef7a3"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="2885bbc0ceae7eb122ad4248e51ef7a3" args="(int index, unsigned char value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">unsigned char </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Bind a parameter to a placeholder in a query. A full discussion of this feature is beyond the scope of this header file, but in short, here's how it works: Instead of saying "SELECT foo FROM mytable WHERE myfield = 12345" you can say "SELECT foo FROM mytable WHERE myfield = ?". The ? character is a placeholder for a parameter that must then be bound. Call BindParameter(0, 12345) to bind the integer value 12345 to that field. Placeholders are indexed starting at 0. You are responsible for making sure that the types match when you call BindParameter. You don't have to get it precisely correct: in general, the SQL driver is smart enough to do things like cast a short to a long or a float to a double. Bound parameters were introduced in ANSI SQL 92. Please see that standard for more information. Most of these methods are excluded from wrapping because the Java wrapper treats all integer types from char up through 64-bit long as 'int'. This is incorrect behavior but what else am I going to do? Finally, the default implementation for <a class="el" href="a01600.html#78f526e0c53acfb8543b5533eb9170f2">BindParameter(int, vtkVariant)</a> dispatches to one of the more type-specific versions. It should be OK to use in database drivers without modification.
<p>Reimplemented in <a class="el" href="a01077.html#48c18ee93211c9a4ce07429ad90e63a9">vtkMySQLQuery</a>, <a class="el" href="a01094.html#70b7e2a17400705f2a5eb6254086e044">vtkODBCQuery</a>, and <a class="el" href="a01599.html#69b31e0abf7a18ab004b5f5bf443aa45">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="e869e847728d21a6a8bf38adb07e61cc"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="e869e847728d21a6a8bf38adb07e61cc" args="(int index, unsigned short value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">unsigned short </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#871c5cb52e61fba2ae2e61f5c216eb3e">vtkMySQLQuery</a>, <a class="el" href="a01094.html#27cd1bb4f97676f6ab05e2f18713375c">vtkODBCQuery</a>, and <a class="el" href="a01599.html#d542f796a2e4745c429c0a21b3578530">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="e356e5ef69fb26441278bc8adf521eb4"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="e356e5ef69fb26441278bc8adf521eb4" args="(int index, unsigned int value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">unsigned int </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#6a5949f0023f68e3ca846717b457dc68">vtkMySQLQuery</a>, <a class="el" href="a01094.html#9bbe6bce4dfb5826bd309aeacab90e10">vtkODBCQuery</a>, and <a class="el" href="a01599.html#0286f4d1b781059524efb52f85b695a1">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="579a4289665dec1726833c5944a2f90c"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="579a4289665dec1726833c5944a2f90c" args="(int index, unsigned long value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">unsigned long </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#77e62d94b9226a9744cf1cc7d0488f6e">vtkMySQLQuery</a>, <a class="el" href="a01094.html#2acdbf895d8ef9dca875e91c22f13148">vtkODBCQuery</a>, and <a class="el" href="a01599.html#6b1c1079df6e4cf91f85c87a5a306821">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="5ff157876e7192a0d5e2cb6ce9749c8f"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="5ff157876e7192a0d5e2cb6ce9749c8f" args="(int index, signed char value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">signed char </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#cdf305b04c6dbf629b774c89c46b783c">vtkMySQLQuery</a>, <a class="el" href="a01094.html#f101e566ebe4cef83f2cb738cf05bcf4">vtkODBCQuery</a>, and <a class="el" href="a01599.html#903675fa51c98ae80f279afc1dabbc5a">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="a0a015f6371ebfb74694ed979c978431"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="a0a015f6371ebfb74694ed979c978431" args="(int index, short value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">short </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01599.html#971f8c437ea908612cb84e72b9578fe8">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="55510d96a82492ac6512e6a1b7ed220a"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="55510d96a82492ac6512e6a1b7ed220a" args="(int index, int value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">int </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#be76afc92cc19d63ecc793675c42728f">vtkMySQLQuery</a>, <a class="el" href="a01094.html#05e7df0876928d6d12a69ab4021622ee">vtkODBCQuery</a>, and <a class="el" href="a01599.html#418ca5691051ba89ce606560a99090fe">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="4776664f47265f6109479968db9a671e"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="4776664f47265f6109479968db9a671e" args="(int index, long value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">long </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01599.html#24284c30f4977ec7ba5e83cca7abbb98">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="2e01bb15627ec03f87826514b1792964"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="2e01bb15627ec03f87826514b1792964" args="(int index, vtkTypeUInt64 value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">vtkTypeUInt64 </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#c689073093a92a1487db1f63e3daaa41">vtkMySQLQuery</a>, <a class="el" href="a01094.html#9b8f6cd61b1a75e72a59c74ac9e94fcd">vtkODBCQuery</a>, and <a class="el" href="a01599.html#bef6733489971b484fca87306ef34f27">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="d27dc7fbf73c3e03a22492e1d06f41d8"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="d27dc7fbf73c3e03a22492e1d06f41d8" args="(int index, vtkTypeInt64 value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">vtkTypeInt64 </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#656075f1667d393f585e6b220c096d85">vtkMySQLQuery</a>, <a class="el" href="a01094.html#c073ed1288942f2ae3623dcb048199fc">vtkODBCQuery</a>, and <a class="el" href="a01599.html#586950c8f654b84de71b27e877f26d48">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="301b395b8de505c50a5411570bcbe421"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="301b395b8de505c50a5411570bcbe421" args="(int index, float value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">float </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#00376075ee39956dc296c4735d853e7b">vtkMySQLQuery</a>, <a class="el" href="a01094.html#060afcf7248f34ac510521de87957535">vtkODBCQuery</a>, and <a class="el" href="a01599.html#117537f32ecf2ab9d32bc3a8dba4ba34">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="e60173cf157d6a02ad0c5a6c0b47b192"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="e60173cf157d6a02ad0c5a6c0b47b192" args="(int index, double value)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">double </td>
<td class="paramname"> <em>value</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#0b07e8f85b40990f0494f82b765664c9">vtkMySQLQuery</a>, <a class="el" href="a01094.html#0f60e714609d512e997d4d2a64d1b784">vtkODBCQuery</a>, and <a class="el" href="a01599.html#9d47324dce67b483f51cebd1d88b6c94">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="a70fa32ebf93c6eb92687ca3ac798e77"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="a70fa32ebf93c6eb92687ca3ac798e77" args="(int index, const char *stringValue)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>stringValue</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Bind a string value -- string must be null-terminated
<p>Reimplemented in <a class="el" href="a01077.html#c036d8375d04588812bc22e0f4a980ed">vtkMySQLQuery</a>, <a class="el" href="a01094.html#03eb39807be90cdb7d81e044ec009655">vtkODBCQuery</a>, and <a class="el" href="a01599.html#8932ee73c56176bea66dde5aeb9985ba">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="2e3fe066a77dd69f275b60d38fd9764c"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="2e3fe066a77dd69f275b60d38fd9764c" args="(int index, const char *stringValue, size_t length)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>stringValue</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">size_t </td>
<td class="paramname"> <em>length</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Bind a string value -- string must be null-terminated
<p>Reimplemented in <a class="el" href="a01077.html#a19e33fd36e66f6ac656fc35c290d8e1">vtkMySQLQuery</a>, <a class="el" href="a01094.html#dcfbce8e6db77102a220bf2de6cd9de2">vtkODBCQuery</a>, and <a class="el" href="a01599.html#d87eafe13bf060bca2f9941cbfb0c408">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="d6b1ac047538b48082ac8891269793ce"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="d6b1ac047538b48082ac8891269793ce" args="(int index, const vtkStdString &string)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const <a class="el" href="a01607.html">vtkStdString</a> & </td>
<td class="paramname"> <em>string</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01077.html#06f74af44423317f5d8b1c1ef78b6594">vtkMySQLQuery</a>, <a class="el" href="a01094.html#34a9cc2b2baafb3604414443e416decf">vtkODBCQuery</a>, and <a class="el" href="a01599.html#f77ba92397b1a420eb76a5f9b9118d92">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="78f526e0c53acfb8543b5533eb9170f2"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="78f526e0c53acfb8543b5533eb9170f2" args="(int index, vtkVariant var)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype"><a class="el" href="a01810.html">vtkVariant</a> </td>
<td class="paramname"> <em>var</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Reimplemented in <a class="el" href="a01599.html#97be56b0ea99c992d504aff456ef7206">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="36b23602c14ce8df8b4d7ce0f998a7e4"></a><!-- doxytag: member="vtkSQLQuery::BindParameter" ref="36b23602c14ce8df8b4d7ce0f998a7e4" args="(int index, const void *data, size_t length)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::BindParameter </td>
<td>(</td>
<td class="paramtype">int </td>
<td class="paramname"> <em>index</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">const void * </td>
<td class="paramname"> <em>data</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">size_t </td>
<td class="paramname"> <em>length</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Bind a blob value. Not all databases support blobs as a data type. Check vtkSQLDatabase::IsSupported(VTK_SQL_FEATURE_BLOB) to make sure.
<p>Reimplemented in <a class="el" href="a01077.html#bfee89c5da931af9b51b6b98c9d4a958">vtkMySQLQuery</a>, <a class="el" href="a01094.html#f330ce9b7d5e75d180653202e3d5d87a">vtkODBCQuery</a>, and <a class="el" href="a01599.html#08daf666afa439c524c1e7ecd099b7a4">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="b922b8db82ec2a90282a41283ef2554b"></a><!-- doxytag: member="vtkSQLQuery::ClearParameterBindings" ref="b922b8db82ec2a90282a41283ef2554b" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual bool vtkSQLQuery::ClearParameterBindings </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Bind a blob value. Not all databases support blobs as a data type. Check vtkSQLDatabase::IsSupported(VTK_SQL_FEATURE_BLOB) to make sure.
<p>Reimplemented in <a class="el" href="a01077.html#576238eae2a8ee0fd9a0f321b023c71e">vtkMySQLQuery</a>, <a class="el" href="a01094.html#26b55ef8f1ef43fd9386a5a44abddcd1">vtkODBCQuery</a>, and <a class="el" href="a01599.html#3493b80056114cfd18419d992bf2c4f1">vtkSQLiteQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="fde168634825c3dc579ecfb7e94792a7"></a><!-- doxytag: member="vtkSQLQuery::EscapeString" ref="fde168634825c3dc579ecfb7e94792a7" args="(vtkStdString s, bool addSurroundingQuotes=true)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual <a class="el" href="a01607.html">vtkStdString</a> vtkSQLQuery::EscapeString </td>
<td>(</td>
<td class="paramtype"><a class="el" href="a01607.html">vtkStdString</a> </td>
<td class="paramname"> <em>s</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bool </td>
<td class="paramname"> <em>addSurroundingQuotes</em> = <code>true</code></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Escape a string for inclusion into an SQL query. If <em>addSurroundingQuotes</em> is true, then quotation marks appropriate to the backend database will be added to enclose the escaped string. This argument defaults to true. A default, simple-minded implementation is provided for database backends that do not provde a way to escape strings for use inside queries.
<p>Reimplemented in <a class="el" href="a01077.html#b1b6842da38ce125f9abbb4654868c64">vtkMySQLQuery</a>, and <a class="el" href="a01290.html#535e7f97d4ec6fd52399670759a5679a">vtkPostgreSQLQuery</a>.</p>
</div>
</div><p>
<a class="anchor" name="948d8fb7c6f1b6f2733a2c93a53da3fc"></a><!-- doxytag: member="vtkSQLQuery::EscapeString" ref="948d8fb7c6f1b6f2733a2c93a53da3fc" args="(const char *src, bool addSurroundingQuotes)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">char* vtkSQLQuery::EscapeString </td>
<td>(</td>
<td class="paramtype">const char * </td>
<td class="paramname"> <em>src</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bool </td>
<td class="paramname"> <em>addSurroundingQuotes</em></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Escape a string for inclusion into an SQL query. This method exists to provide a wrappable version of the method that takes and returns <a class="el" href="a01607.html" title="Wrapper around vtkstd::string to keep symbols short.">vtkStdString</a> objects. You are responsible for calling delete [] on the character array returned by this method. This method simply calls the <a class="el" href="a01607.html" title="Wrapper around vtkstd::string to keep symbols short.">vtkStdString</a> variant and thus need not be re-implemented by subclasses.
</div>
</div><p>
<a class="anchor" name="67957febc145a682439e4f33055a18c2"></a><!-- doxytag: member="vtkSQLQuery::SetDatabase" ref="67957febc145a682439e4f33055a18c2" args="(vtkSQLDatabase *db)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void vtkSQLQuery::SetDatabase </td>
<td>(</td>
<td class="paramtype"><a class="el" href="a01593.html">vtkSQLDatabase</a> * </td>
<td class="paramname"> <em>db</em> </td>
<td> ) </td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Set the database associated with the query. This is only to be called by the corresponding database class on creation of the query in GetQueryInstance().
</div>
</div><p>
<hr><h2>Member Data Documentation</h2>
<a class="anchor" name="26110d3038fa066688709b1fa65b3ef1"></a><!-- doxytag: member="vtkSQLQuery::Query" ref="26110d3038fa066688709b1fa65b3ef1" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">char* <a class="el" href="a01600.html#26110d3038fa066688709b1fa65b3ef1">vtkSQLQuery::Query</a><code> [protected]</code> </td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Definition at line <a class="el" href="a04988.html#l00193">193</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<a class="anchor" name="d44f81a1c46f673fd0c3a64c2b1cdc05"></a><!-- doxytag: member="vtkSQLQuery::Database" ref="d44f81a1c46f673fd0c3a64c2b1cdc05" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="el" href="a01593.html">vtkSQLDatabase</a>* <a class="el" href="a01600.html#d44f81a1c46f673fd0c3a64c2b1cdc05">vtkSQLQuery::Database</a><code> [protected]</code> </td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Definition at line <a class="el" href="a04988.html#l00194">194</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<a class="anchor" name="49bfd7fdb66092ab52d8b550d5f28672"></a><!-- doxytag: member="vtkSQLQuery::Active" ref="49bfd7fdb66092ab52d8b550d5f28672" args="" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool <a class="el" href="a01600.html#49bfd7fdb66092ab52d8b550d5f28672">vtkSQLQuery::Active</a><code> [protected]</code> </td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<p>Definition at line <a class="el" href="a04988.html#l00195">195</a> of file <a class="el" href="a04988.html">vtkSQLQuery.h</a>.</p>
</div>
</div><p>
<hr>The documentation for this class was generated from the following file:<ul>
<li>dox/IO/<a class="el" href="a04988.html">vtkSQLQuery.h</a></ul>
</div>
<hr size="1"><address style="text-align: right;"><small>Generated on Wed Jun 3 19:36:14 2009 for VTK by
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.6 </small></address>
</body>
</html>
distrib
>
Mandriva
>
2010.0
>
i586
>
media
>
contrib-release
>
by-pkgid
>
60f1dc962abad0f3b492991a4fbef9be
>
files
>
1603
