<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8">
<title>libgdamm: Gnome::Gda::DataSelect Class Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css">
<link href="doxygen.css" rel="stylesheet" type="text/css">
</head><body>
<!-- Generated by Doxygen 1.5.8 -->
<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="modules.html"><span>Modules</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li class="current"><a href="annotated.html"><span>Classes</span></a></li>
</ul>
</div>
<div class="tabs">
<ul>
<li><a href="annotated.html"><span>Class List</span></a></li>
<li><a href="classes.html"><span>Class Index</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 class="navpath"><a class="el" href="namespaceGnome.html">Gnome</a>::<a class="el" href="namespaceGnome_1_1Gda.html">Gda</a>::<a class="el" href="classGnome_1_1Gda_1_1DataSelect.html">DataSelect</a>
</div>
</div>
<div class="contents">
<h1>Gnome::Gda::DataSelect Class Reference<br>
<small>
[<a class="el" href="group__DataModels.html">Data Models</a>]</small>
</h1><!-- doxytag: class="Gnome::Gda::DataSelect" --><!-- doxytag: inherits="Glib::Object,Gnome::Gda::DataModel" -->Data models returned by the execution of a SELECT statement. <a href="#_details">More...</a>
<p>
Inherits <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1Object.html">Glib::Object</a>, and <a class="el" href="classGnome_1_1Gda_1_1DataModel.html">Gnome::Gda::DataModel</a>.
<p>
<div class="dynheader">
Collaboration diagram for Gnome::Gda::DataSelect:</div>
<div class="dynsection">
<p><center><img src="classGnome_1_1Gda_1_1DataSelect__coll__graph.png" border="0" usemap="#Gnome_1_1Gda_1_1DataSelect__coll__map" alt="Collaboration graph"></center>
<map name="Gnome_1_1Gda_1_1DataSelect__coll__map">
<area shape="rect" href="../../../glibmm-2.4/reference/html/classGlib_1_1Object.html" title="Glib::Object" alt="" coords="5,229,96,256"><area shape="rect" href="../../../glibmm-2.4/reference/html/classGlib_1_1ObjectBase.html" title="Glib::ObjectBase" alt="" coords="51,80,171,107"><area shape="rect" href="../../../glibmm-2.4/reference/html/classGlib_1_1Interface.html" title="Glib::Interface" alt="" coords="135,155,239,181"><area shape="rect" href="../../../libsigc++-2.0/reference/html/structsigc_1_1trackable.html" title="sigc::trackable" alt="" coords="57,5,164,32"><area shape="rect" href="classGnome_1_1Gda_1_1DataModel.html" title="Abstract DataModel (Base class for all DataModels)." alt="" coords="120,229,285,256"></map>
<center><font size="2">[<a href="graph_legend.html">legend</a>]</font></center></div>
<p>
<a href="classGnome_1_1Gda_1_1DataSelect-members.html">List of all members.</a><table border="0" cellpadding="0" cellspacing="0">
<tr><td></td></tr>
<tr><td colspan="2"><br><h2>Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">virtual </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#5cb907ed60fa04c1e7545c97d4d3bfea">~DataSelect</a> ()</td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">GdaDataSelect* </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#8d70723ce447f90fcace10547d5a6fb5">gobj</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Provides access to the underlying C GObject. <a href="#8d70723ce447f90fcace10547d5a6fb5"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">const GdaDataSelect* </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#396e274cd7a052d0917b3b9f1f32edab">gobj</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Provides access to the underlying C GObject. <a href="#396e274cd7a052d0917b3b9f1f32edab"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">GdaDataSelect* </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#b691e94cdcac3012ac53084a72c5e2c6">gobj_copy</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Provides access to the underlying C instance. The caller is responsible for unrefing it. Use when directly setting fields in structs. <a href="#b691e94cdcac3012ac53084a72c5e2c6"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">bool </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#a21e27f04a4fa50237133a2d20166e74">set_row_selection_condition_sql</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& sql_where)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Specifies the SQL condition corresponding to the WHERE part of a SELECT statement which would return only 1 row (the expression of the primary key). <a href="#a21e27f04a4fa50237133a2d20166e74"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#d671c0a0830330a1e0f755610d561e87">compute_row_selection_condition</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Offers the same features as set_row_selection_condition() but the expression is computed from the meta data associated to the connection being used when <em>model</em> was created. <a href="#d671c0a0830330a1e0f755610d561e87"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#ff15ccf98acafb4667aec239d883b085">set_modification_statement</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> >& mod_stmt)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Informs <em>model</em> that it should allow modifications to the data in some columns and some rows using <em>mod_stmt</em> to propagate those modifications into the database. <a href="#ff15ccf98acafb4667aec239d883b085"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#54d07a9eddc071c9e0504bfc81d468b3">set_modification_statement_sql</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& sql)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Offers the same feature as <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#ff15ccf98acafb4667aec239d883b085" title="Informs model that it should allow modifications to the data in some columns and...">set_modification_statement()</a> but using an SQL statement. <a href="#54d07a9eddc071c9e0504bfc81d468b3"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#caea1daa30a57c6f21d299bdf634228c">compute_modification_statements</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Makes <em>model</em> try to compute INSERT, UPDATE and DELETE statements to be used when modifying <em>model's</em> contents. <a href="#caea1daa30a57c6f21d299bdf634228c"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#c246ecf72b15bc9ab930cf18cee9c59c">compute_columns_attributes</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Computes correct attributes for each of <em>model's</em> columns, which includes the "NOT <tt>0</tt>" attribute, the default value, the precision and scale for numeric values. <a href="#c246ecf72b15bc9ab930cf18cee9c59c"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Connection.html">Connection</a> > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#f2b82230273430f1b2914aab926a5cd4">get_connection</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Get a pointer to the <a class="el" href="classGnome_1_1Gda_1_1Connection.html" title="Manages a connection to a data source.">Gda::Connection</a> object which was used when <em>model</em> was created (and which may be used internally by <em>model</em>). <a href="#f2b82230273430f1b2914aab926a5cd4"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a>< bool > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#22f4ba3dc584cda540df019609c7b2a1">property_auto_reset</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Automatically re-run the SELECT statement if any parameter has chanegd since it was first executed. <a href="#22f4ba3dc584cda540df019609c7b2a1"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< bool > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#8af2d3917c90a341f0e0881c966caa87">property_auto_reset</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Automatically re-run the SELECT statement if any parameter has chanegd since it was first executed. <a href="#8af2d3917c90a341f0e0881c966caa87"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a>< bool > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#1bdf95aaa2d5b33ae1aa0d63a38b12ec">property_store_all_rows</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Tells if model has analysed all the rows. <a href="#1bdf95aaa2d5b33ae1aa0d63a38b12ec"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< bool > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#af3cead9fecbd443955260ea73930b4b">property_store_all_rows</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Tells if model has analysed all the rows. <a href="#af3cead9fecbd443955260ea73930b4b"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Connection.html">Connection</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#9354b80272577b0ed967815c88e8797d">property_connection</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight"><a class="el" href="classGnome_1_1Gda_1_1Connection.html" title="Manages a connection to a data source.">Connection</a> from which this data model is created. <a href="#9354b80272577b0ed967815c88e8797d"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#7fb77f3f6c6ce40495e44cc228997560">property_delete_stmt</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">DELETE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to remove data. <a href="#7fb77f3f6c6ce40495e44cc228997560"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#6de4d17c42404c599048a3c9d4a3000b">property_delete_stmt</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">DELETE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to remove data. <a href="#6de4d17c42404c599048a3c9d4a3000b"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#2f01e86f1d8144b605607bb651678efb">property_insert_stmt</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">INSERT <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to add data. <a href="#2f01e86f1d8144b605607bb651678efb"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#eea03548dc744929e66200a1c7198f89">property_insert_stmt</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">INSERT <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to add data. <a href="#eea03548dc744929e66200a1c7198f89"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#4baa856c879278ba17a52d0b92671a6e">property_prepared_stmt</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Associated prepared statement (for internal usage). <a href="#4baa856c879278ba17a52d0b92671a6e"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#a2592842afcdbcc94f29bdda207bef0e">property_prepared_stmt</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Associated prepared statement (for internal usage). <a href="#a2592842afcdbcc94f29bdda207bef0e"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#71190cb5fbcc944975d88048ed23d764">property_update_stmt</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">UPDATE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to update data. <a href="#71190cb5fbcc944975d88048ed23d764"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#92af09fc8a1f73324f4c0f5341461437">property_update_stmt</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">UPDATE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to update data. <a href="#92af09fc8a1f73324f4c0f5341461437"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Set.html">Set</a> > > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#bcaf9df0e7ac96d20aae9f98f71041e2">property_exec_params</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">GdaSet used when the SELECT statement was executed. <a href="#bcaf9df0e7ac96d20aae9f98f71041e2"></a><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><br class="typebreak">
< guint > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#1dccf163418f70ac8ca139e5e2408bcd">property_model_usage</a> () const </td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Determines how the data model may be used. <a href="#1dccf163418f70ac8ca139e5e2408bcd"></a><br></td></tr>
<tr><td colspan="2"><br><h2>Related Functions</h2></td></tr>
<tr><td colspan="2">(Note that these are not member functions.) <br><br></td></tr>
<tr><td class="memItemLeft" nowrap align="right" valign="top"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><br class="typebreak">
< <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html">Gnome::Gda::DataSelect</a> > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#3b12338131eb9a1c71cc4aa1d771dae2">wrap</a> (GdaDataSelect* object, bool take_copy=false)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">A <a class="elRef" href="../../../glibmm-2.4/reference/html/namespaceGlib.html#671306f4a3a0cae5ab4d7a9d54886592">Glib::wrap()</a> method for this object. <a href="#3b12338131eb9a1c71cc4aa1d771dae2"></a><br></td></tr>
</table>
<hr><a name="_details"></a><h2>Detailed Description</h2>
Data models returned by the execution of a SELECT statement. <p>
This data model implements the <a class="el" href="classGnome_1_1Gda_1_1DataModel.html" title="Abstract DataModel (Base class for all DataModels).">Gda::DataModel</a> interface and is the required base object when database providers implement a data model returned when a SELECT statement has been executed. As the GdaDataModel interface is implemented, consult the API to access and modify the data held in a GdaDataSelect object.<p>
The default behaviour however is to disallow modifications, and this section documents how to characterize a <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html" title="Data models returned by the execution of a SELECT statement.">Gda::DataSelect</a> to allow modifications. Once this is done, any modification done to the data model whill be propagated to the modified table in the database using INSERT, UPDATE or DELETE statements.<p>
After any modification, it is still possible to read values from the data model (even values for rows which have been modified or inserted). The data model might then execute some SELECT statement to fetch some actualized values. Note: there is a corner case where a modification made to a row would make the row not selected at first in the data model (for example is the original SELECT statement included a clause "WHERE id < 100" and the modification sets the "id" value to 110), then the row will still be in the data model even though it would not be if the SELECT statement which execution created the data model in the first place was re-run. <hr><h2>Constructor & Destructor Documentation</h2>
<a class="anchor" name="5cb907ed60fa04c1e7545c97d4d3bfea"></a><!-- doxytag: member="Gnome::Gda::DataSelect::~DataSelect" ref="5cb907ed60fa04c1e7545c97d4d3bfea" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">virtual Gnome::Gda::DataSelect::~DataSelect </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [virtual]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
</div>
</div><p>
<hr><h2>Member Function Documentation</h2>
<a class="anchor" name="c246ecf72b15bc9ab930cf18cee9c59c"></a><!-- doxytag: member="Gnome::Gda::DataSelect::compute_columns_attributes" ref="c246ecf72b15bc9ab930cf18cee9c59c" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Gnome::Gda::DataSelect::compute_columns_attributes </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Computes correct attributes for each of <em>model's</em> columns, which includes the "NOT <tt>0</tt>" attribute, the default value, the precision and scale for numeric values. <p>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><code>true</code> if no error occurred. </dd></dl>
</div>
</div><p>
<a class="anchor" name="caea1daa30a57c6f21d299bdf634228c"></a><!-- doxytag: member="Gnome::Gda::DataSelect::compute_modification_statements" ref="caea1daa30a57c6f21d299bdf634228c" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Gnome::Gda::DataSelect::compute_modification_statements </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Makes <em>model</em> try to compute INSERT, UPDATE and DELETE statements to be used when modifying <em>model's</em> contents. <p>
<dl class="note" compact><dt><b>Note:</b></dt><dd>any modification statement set using <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#ff15ccf98acafb4667aec239d883b085" title="Informs model that it should allow modifications to the data in some columns and...">set_modification_statement()</a> will first be unset </dd></dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><code>true</code> if no error occurred. If <code>false</code> is returned, then some modification statement may still have been computed. </dd></dl>
</div>
</div><p>
<a class="anchor" name="d671c0a0830330a1e0f755610d561e87"></a><!-- doxytag: member="Gnome::Gda::DataSelect::compute_row_selection_condition" ref="d671c0a0830330a1e0f755610d561e87" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Gnome::Gda::DataSelect::compute_row_selection_condition </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Offers the same features as set_row_selection_condition() but the expression is computed from the meta data associated to the connection being used when <em>model</em> was created. <p>
NOTE1: make sure the meta data associated to the connection is up to date before using this method, see <a class="el" href="classGnome_1_1Gda_1_1Connection.html#09020e66ecc8268caef2f9c9c352d9cf" title="Update the full meta store information.">Gda::Connection::update_meta_store()</a>.<p>
NOTE2: if the SELECT statement from which <em>model</em> has been created uses more than one table, or if the table used does not have any primary key, then this method will fail <dl class="return" compact><dt><b>Returns:</b></dt><dd><code>true</code> if no error occurred. </dd></dl>
</div>
</div><p>
<a class="anchor" name="f2b82230273430f1b2914aab926a5cd4"></a><!-- doxytag: member="Gnome::Gda::DataSelect::get_connection" ref="f2b82230273430f1b2914aab926a5cd4" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Connection.html">Connection</a>> Gnome::Gda::DataSelect::get_connection </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Get a pointer to the <a class="el" href="classGnome_1_1Gda_1_1Connection.html" title="Manages a connection to a data source.">Gda::Connection</a> object which was used when <em>model</em> was created (and which may be used internally by <em>model</em>). <p>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>A pointer to the <a class="el" href="classGnome_1_1Gda_1_1Connection.html" title="Manages a connection to a data source.">Gda::Connection</a>, or <code>0</code>. </dd></dl>
</div>
</div><p>
<a class="anchor" name="396e274cd7a052d0917b3b9f1f32edab"></a><!-- doxytag: member="Gnome::Gda::DataSelect::gobj" ref="396e274cd7a052d0917b3b9f1f32edab" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">const GdaDataSelect* Gnome::Gda::DataSelect::gobj </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const<code> [inline]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Provides access to the underlying C GObject. <p>
<p>Reimplemented from <a class="el" href="classGnome_1_1Gda_1_1DataModel.html#f06bc95c0e33adf8a3faca1870190a7f">Gnome::Gda::DataModel</a>.</p>
</div>
</div><p>
<a class="anchor" name="8d70723ce447f90fcace10547d5a6fb5"></a><!-- doxytag: member="Gnome::Gda::DataSelect::gobj" ref="8d70723ce447f90fcace10547d5a6fb5" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">GdaDataSelect* Gnome::Gda::DataSelect::gobj </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td><code> [inline]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Provides access to the underlying C GObject. <p>
<p>Reimplemented from <a class="el" href="classGnome_1_1Gda_1_1DataModel.html#63b551e8308d050dbd5ab8964b405e76">Gnome::Gda::DataModel</a>.</p>
</div>
</div><p>
<a class="anchor" name="b691e94cdcac3012ac53084a72c5e2c6"></a><!-- doxytag: member="Gnome::Gda::DataSelect::gobj_copy" ref="b691e94cdcac3012ac53084a72c5e2c6" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">GdaDataSelect* Gnome::Gda::DataSelect::gobj_copy </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Provides access to the underlying C instance. The caller is responsible for unrefing it. Use when directly setting fields in structs. <p>
</div>
</div><p>
<a class="anchor" name="8af2d3917c90a341f0e0881c966caa87"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_auto_reset" ref="8af2d3917c90a341f0e0881c966caa87" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><bool> Gnome::Gda::DataSelect::property_auto_reset </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Automatically re-run the SELECT statement if any parameter has chanegd since it was first executed. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="22f4ba3dc584cda540df019609c7b2a1"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_auto_reset" ref="22f4ba3dc584cda540df019609c7b2a1" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a><bool> Gnome::Gda::DataSelect::property_auto_reset </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Automatically re-run the SELECT statement if any parameter has chanegd since it was first executed. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="9354b80272577b0ed967815c88e8797d"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_connection" ref="9354b80272577b0ed967815c88e8797d" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Connection.html">Connection</a>> > Gnome::Gda::DataSelect::property_connection </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
<a class="el" href="classGnome_1_1Gda_1_1Connection.html" title="Manages a connection to a data source.">Connection</a> from which this data model is created. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="6de4d17c42404c599048a3c9d4a3000b"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_delete_stmt" ref="6de4d17c42404c599048a3c9d4a3000b" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_delete_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
DELETE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to remove data. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="7fb77f3f6c6ce40495e44cc228997560"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_delete_stmt" ref="7fb77f3f6c6ce40495e44cc228997560" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_delete_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
DELETE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to remove data. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="bcaf9df0e7ac96d20aae9f98f71041e2"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_exec_params" ref="bcaf9df0e7ac96d20aae9f98f71041e2" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Set.html">Set</a>> > Gnome::Gda::DataSelect::property_exec_params </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
GdaSet used when the SELECT statement was executed. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="eea03548dc744929e66200a1c7198f89"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_insert_stmt" ref="eea03548dc744929e66200a1c7198f89" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_insert_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
INSERT <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to add data. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="2f01e86f1d8144b605607bb651678efb"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_insert_stmt" ref="2f01e86f1d8144b605607bb651678efb" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_insert_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
INSERT <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to add data. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="1dccf163418f70ac8ca139e5e2408bcd"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_model_usage" ref="1dccf163418f70ac8ca139e5e2408bcd" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><guint> Gnome::Gda::DataSelect::property_model_usage </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Determines how the data model may be used. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="a2592842afcdbcc94f29bdda207bef0e"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_prepared_stmt" ref="a2592842afcdbcc94f29bdda207bef0e" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_prepared_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Associated prepared statement (for internal usage). <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="4baa856c879278ba17a52d0b92671a6e"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_prepared_stmt" ref="4baa856c879278ba17a52d0b92671a6e" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_prepared_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Associated prepared statement (for internal usage). <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="af3cead9fecbd443955260ea73930b4b"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_store_all_rows" ref="af3cead9fecbd443955260ea73930b4b" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a><bool> Gnome::Gda::DataSelect::property_store_all_rows </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Tells if model has analysed all the rows. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="1bdf95aaa2d5b33ae1aa0d63a38b12ec"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_store_all_rows" ref="1bdf95aaa2d5b33ae1aa0d63a38b12ec" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a><bool> Gnome::Gda::DataSelect::property_store_all_rows </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Tells if model has analysed all the rows. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="92af09fc8a1f73324f4c0f5341461437"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_update_stmt" ref="92af09fc8a1f73324f4c0f5341461437" args="() const " -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy__ReadOnly.html">Glib::PropertyProxy_ReadOnly</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_update_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td> const</td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
UPDATE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to update data. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="71190cb5fbcc944975d88048ed23d764"></a><!-- doxytag: member="Gnome::Gda::DataSelect::property_update_stmt" ref="71190cb5fbcc944975d88048ed23d764" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1PropertyProxy.html">Glib::PropertyProxy</a>< <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a>> > Gnome::Gda::DataSelect::property_update_stmt </td>
<td>(</td>
<td class="paramname"> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
UPDATE <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> to be executed to update data. <p>
You rarely need to use properties because there are get_ and set_ methods for almost all of them. <dl class="return" compact><dt><b>Returns:</b></dt><dd>A PropertyProxy that allows you to get or set the property of the value, or receive notification when the value of the property changes. </dd></dl>
</div>
</div><p>
<a class="anchor" name="ff15ccf98acafb4667aec239d883b085"></a><!-- doxytag: member="Gnome::Gda::DataSelect::set_modification_statement" ref="ff15ccf98acafb4667aec239d883b085" args="(const Glib::RefPtr< Statement > &mod_stmt)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Gnome::Gda::DataSelect::set_modification_statement </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1Statement.html">Statement</a> >& </td>
<td class="paramname"> <em>mod_stmt</em> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Informs <em>model</em> that it should allow modifications to the data in some columns and some rows using <em>mod_stmt</em> to propagate those modifications into the database. <p>
If <em>mod_stmt</em> is: <itemizedlist> <listitem>an UPDATE statement, then all the rows in <em>model</em> will be modifyable</listitem> <listitem>a DELETE statement, then it will be possible to delete rows in <em>model</listitem></em> <listitem>in INSERT statement, then it will be possible to add some rows to <em>model</listitem></em> <listitem>any other statement, then this method will return an error</listitem> </itemizedlist><p>
This method can be called several times to specify different types of modification.<p>
If <em>mod_stmt</em> is an UPDATE or DELETE statement then it should have a WHERE part which identifies a unique row in <em>model</em> (please note that this property can't be checked but may result in <em>model</em> behaving in an unpredictable way).<p>
NOTE1: However, if the set_row_selection_condition() or <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#a21e27f04a4fa50237133a2d20166e74" title="Specifies the SQL condition corresponding to the WHERE part of a SELECT statement...">set_row_selection_condition_sql()</a> have been successfully be called before, the WHERE part of <em>mod_stmt</em> <em>WILL</em> be modified to use the row selection condition specified through one of these methods (please not that it is then possible to avoid specifying a WHERE part in <em>mod_stmt</em> then).<p>
NOTE2: if set_row_selection_condition() or <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#a21e27f04a4fa50237133a2d20166e74" title="Specifies the SQL condition corresponding to the WHERE part of a SELECT statement...">set_row_selection_condition_sql()</a> have not yet been successfully be called before, then the WHERE part of <em>mod_stmt</em> will be used as if one of these functions had been called. <dl compact><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>mod_stmt</em> </td><td>A <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Gda::Statement</a> (INSERT, UPDATE or DELETE). </td></tr>
</table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><code>true</code> if no error occurred. </dd></dl>
</div>
</div><p>
<a class="anchor" name="54d07a9eddc071c9e0504bfc81d468b3"></a><!-- doxytag: member="Gnome::Gda::DataSelect::set_modification_statement_sql" ref="54d07a9eddc071c9e0504bfc81d468b3" args="(const Glib::ustring &sql)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">void Gnome::Gda::DataSelect::set_modification_statement_sql </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>sql</em> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Offers the same feature as <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#ff15ccf98acafb4667aec239d883b085" title="Informs model that it should allow modifications to the data in some columns and...">set_modification_statement()</a> but using an SQL statement. <p>
<dl compact><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>sql</em> </td><td>An SQL text. </td></tr>
</table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><code>true</code> if no error occurred. </dd></dl>
</div>
</div><p>
<a class="anchor" name="a21e27f04a4fa50237133a2d20166e74"></a><!-- doxytag: member="Gnome::Gda::DataSelect::set_row_selection_condition_sql" ref="a21e27f04a4fa50237133a2d20166e74" args="(const Glib::ustring &sql_where)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">bool Gnome::Gda::DataSelect::set_row_selection_condition_sql </td>
<td>(</td>
<td class="paramtype">const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a> & </td>
<td class="paramname"> <em>sql_where</em> </td>
<td> ) </td>
<td></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
Specifies the SQL condition corresponding to the WHERE part of a SELECT statement which would return only 1 row (the expression of the primary key). <p>
For example for a table created as <![CDATA["CREATE TABLE mytable (part1 int NOT <code>0</code>, part2 string NOT <code>0</code>, name string, PRIMARY KEY (part1, part2))"]]>, and if <em>pmodel</em> corresponds to the execution of the <![CDATA["SELECT name, part1, part2 FROM mytable"]]>, then the sensible value for <em>sql_where</em> would be <![CDATA["part1 = ##-1::int AND part2 = ##-2::string"]]> because the values of the 'part1' field are located in <em>pmodel's</em> column number 1 and the values of the 'part2' field are located in <em>pmodel's</em> column number 2 and the primary key is composed of (part1, part2).<p>
For more information about the syntax of the parameters (named <![CDATA["##-1::int"]]> for example), see the GdaSqlParser documentation, and <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html#ff15ccf98acafb4667aec239d883b085" title="Informs model that it should allow modifications to the data in some columns and...">set_modification_statement()</a>. <dl compact><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>sql_where</em> </td><td>An SQL condition (withouth the WHERE keyword). </td></tr>
</table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd><code>true</code> if no error occurred. </dd></dl>
</div>
</div><p>
<hr><h2>Friends And Related Function Documentation</h2>
<a class="anchor" name="3b12338131eb9a1c71cc4aa1d771dae2"></a><!-- doxytag: member="Gnome::Gda::DataSelect::wrap" ref="3b12338131eb9a1c71cc4aa1d771dae2" args="(GdaDataSelect *object, bool take_copy=false)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname"><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1DataSelect.html">Gnome::Gda::DataSelect</a> > wrap </td>
<td>(</td>
<td class="paramtype">GdaDataSelect * </td>
<td class="paramname"> <em>object</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">bool </td>
<td class="paramname"> <em>take_copy</em> = <code>false</code></td><td> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td></td><td><code> [related]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>
A <a class="elRef" href="../../../glibmm-2.4/reference/html/namespaceGlib.html#671306f4a3a0cae5ab4d7a9d54886592">Glib::wrap()</a> method for this object. <p>
<dl compact><dt><b>Parameters:</b></dt><dd>
<table border="0" cellspacing="2" cellpadding="0">
<tr><td valign="top"></td><td valign="top"><em>object</em> </td><td>The C instance. </td></tr>
<tr><td valign="top"></td><td valign="top"><em>take_copy</em> </td><td>False if the result should take ownership of the C instance. True if it should take a new copy or ref. </td></tr>
</table>
</dl>
<dl class="return" compact><dt><b>Returns:</b></dt><dd>A C++ instance that wraps this C instance. </dd></dl>
</div>
</div><p>
<hr>The documentation for this class was generated from the following file:<ul>
<li>libgdamm/dataselect.h</ul>
</div>
<hr size="1"><address style="text-align: right;"><small>Generated on Fri Aug 28 20:01:55 2009 for libgdamm by 
<a href="http://www.doxygen.org/index.html">
<img src="doxygen.png" alt="doxygen" align="middle" border="0"></a> 1.5.8 </small></address>
</body>
</html>
