<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> <meta http-equiv="X-UA-Compatible" content="IE=9"/> <meta name="generator" content="Doxygen 1.8.3.1"/> <title>libgdamm: Gnome::Gda::SqlBuilder Class Reference</title> <link href="tabs.css" rel="stylesheet" type="text/css"/> <script type="text/javascript" src="jquery.js"></script> <script type="text/javascript" src="dynsections.js"></script> <link href="doxygen.css" rel="stylesheet" type="text/css" /> </head> <body> <div id="top"><!-- do not remove this div, it is closed by doxygen! --> <div id="titlearea"> <table cellspacing="0" cellpadding="0"> <tbody> <tr style="height: 56px;"> <td style="padding-left: 0.5em;"> <div id="projectname">libgdamm  <span id="projectnumber">4.99.7</span> </div> </td> </tr> </tbody> </table> </div> <!-- end header part --> <!-- Generated by Doxygen 1.8.3.1 --> <div id="navrow1" class="tabs"> <ul class="tablist"> <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 id="navrow2" class="tabs2"> <ul class="tablist"> <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="inherits.html"><span>Class Hierarchy</span></a></li> <li><a href="functions.html"><span>Class Members</span></a></li> </ul> </div> <div id="nav-path" class="navpath"> <ul> <li class="navelem"><a class="el" href="namespaceGnome.html">Gnome</a></li><li class="navelem"><a class="el" href="namespaceGnome_1_1Gda.html">Gda</a></li><li class="navelem"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html">SqlBuilder</a></li> </ul> </div> </div><!-- top --> <div class="header"> <div class="summary"> <a href="#pub-types">Public Types</a> | <a href="#pub-methods">Public Member Functions</a> | <a href="#pub-static-methods">Static Public Member Functions</a> | <a href="#pro-methods">Protected Member Functions</a> | <a href="#related">Related Functions</a> | <a href="classGnome_1_1Gda_1_1SqlBuilder-members.html">List of all members</a> </div> <div class="headertitle"> <div class="title">Gnome::Gda::SqlBuilder Class Reference</div> </div> </div><!--header--> <div class="contents"> <p><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html" title="SqlBuilder can be used to build a Statement from its structural description, much in the same way a S...">SqlBuilder</a> can be used to build a <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> from its structural description, much in the same way a <a class="el" href="classGnome_1_1Gda_1_1SqlParser.html" title="SQL parser.">SqlParser</a> can be used to build a <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> from a SQL string. <a href="classGnome_1_1Gda_1_1SqlBuilder.html#details">More...</a></p> <div class="dynheader"> Inheritance diagram for Gnome::Gda::SqlBuilder:</div> <div class="dyncontent"> <div class="center"><img src="classGnome_1_1Gda_1_1SqlBuilder__inherit__graph.png" border="0" usemap="#Gnome_1_1Gda_1_1SqlBuilder_inherit__map" alt="Inheritance graph"/></div> <map name="Gnome_1_1Gda_1_1SqlBuilder_inherit__map" id="Gnome_1_1Gda_1_1SqlBuilder_inherit__map"> </map> <center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div> <div class="dynheader"> Collaboration diagram for Gnome::Gda::SqlBuilder:</div> <div class="dyncontent"> <div class="center"><img src="classGnome_1_1Gda_1_1SqlBuilder__coll__graph.png" border="0" usemap="#Gnome_1_1Gda_1_1SqlBuilder_coll__map" alt="Collaboration graph"/></div> <map name="Gnome_1_1Gda_1_1SqlBuilder_coll__map" id="Gnome_1_1Gda_1_1SqlBuilder_coll__map"> </map> <center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div> <table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-types"></a> Public Types</h2></td></tr> <tr class="memitem:ab7e7f17fa01e488ba2cc558e18f5ac2c"><td class="memItemLeft" align="right" valign="top">typedef guint </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a></td></tr> <tr class="separator:ab7e7f17fa01e488ba2cc558e18f5ac2c"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a> Public Member Functions</h2></td></tr> <tr class="memitem:ae8148cf7efba4bdd05e66ee1437cfefa"><td class="memItemLeft" align="right" valign="top">virtual </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ae8148cf7efba4bdd05e66ee1437cfefa">~SqlBuilder</a> ()</td></tr> <tr class="separator:ae8148cf7efba4bdd05e66ee1437cfefa"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a0941410e8750343ef81c5723aa0413ed"><td class="memItemLeft" align="right" valign="top">GdaSqlBuilder* </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a0941410e8750343ef81c5723aa0413ed">gobj</a> ()</td></tr> <tr class="memdesc:a0941410e8750343ef81c5723aa0413ed"><td class="mdescLeft"> </td><td class="mdescRight">Provides access to the underlying C GObject. <a href="#a0941410e8750343ef81c5723aa0413ed">More...</a><br/></td></tr> <tr class="separator:a0941410e8750343ef81c5723aa0413ed"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a82622d83c9160437c90562131a62e445"><td class="memItemLeft" align="right" valign="top">const GdaSqlBuilder* </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a82622d83c9160437c90562131a62e445">gobj</a> () const </td></tr> <tr class="memdesc:a82622d83c9160437c90562131a62e445"><td class="mdescLeft"> </td><td class="mdescRight">Provides access to the underlying C GObject. <a href="#a82622d83c9160437c90562131a62e445">More...</a><br/></td></tr> <tr class="separator:a82622d83c9160437c90562131a62e445"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a1a3162272a5b71c34f25c65a9e8f015f"><td class="memItemLeft" align="right" valign="top">GdaSqlBuilder* </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a1a3162272a5b71c34f25c65a9e8f015f">gobj_copy</a> ()</td></tr> <tr class="memdesc:a1a3162272a5b71c34f25c65a9e8f015f"><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="#a1a3162272a5b71c34f25c65a9e8f015f">More...</a><br/></td></tr> <tr class="separator:a1a3162272a5b71c34f25c65a9e8f015f"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a791685038abb1492ad7366fd1d188b56"><td class="memItemLeft" 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_1Statement.html">Statement</a> > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a791685038abb1492ad7366fd1d188b56">get_statement</a> () const </td></tr> <tr class="memdesc:a791685038abb1492ad7366fd1d188b56"><td class="mdescLeft"> </td><td class="mdescRight">Creates a new <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Gda::Statement</a> statement from <em>builder's</em> contents. <a href="#a791685038abb1492ad7366fd1d188b56">More...</a><br/></td></tr> <tr class="separator:a791685038abb1492ad7366fd1d188b56"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:aa12c40b1f38dfcfd84afd361c454122b"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html">SqlStatement</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#aa12c40b1f38dfcfd84afd361c454122b">get_sql_statement</a> () const </td></tr> <tr class="memdesc:aa12c40b1f38dfcfd84afd361c454122b"><td class="mdescLeft"> </td><td class="mdescRight">Creates a new <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html" title="Every SQL statement can be decomposed in the SqlStatement tree structure.">Gda::SqlStatement</a> structure from <em>builder's</em> contents. <a href="#aa12c40b1f38dfcfd84afd361c454122b">More...</a><br/></td></tr> <tr class="separator:aa12c40b1f38dfcfd84afd361c454122b"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a6d5a21a49cec727f46d6f4bb88b433fa"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a6d5a21a49cec727f46d6f4bb88b433fa">add_id</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& string)</td></tr> <tr class="memdesc:a6d5a21a49cec727f46d6f4bb88b433fa"><td class="mdescLeft"> </td><td class="mdescRight">Defines an expression representing an identifier in <em>builder</em>, which may be reused to build other parts of a statement, for instance as a parameter to <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab240594831b1567ed86fbf503fe9b9e2" title="Builds a new expression which reprenents a condition (or operation).">add_cond()</a> or <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#afdfd53d73ddcea4a38003a69e8f6ef40" title="Valid only for: INSERT, UPDATE, SELECT statements.">add_field_value_id()</a>. <a href="#a6d5a21a49cec727f46d6f4bb88b433fa">More...</a><br/></td></tr> <tr class="separator:a6d5a21a49cec727f46d6f4bb88b433fa"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a7af5c7f975e03545ef64e6126e8e6bb1"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7af5c7f975e03545ef64e6126e8e6bb1">add_field_id</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name=<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>())</td></tr> <tr class="memdesc:a7af5c7f975e03545ef64e6126e8e6bb1"><td class="mdescLeft"> </td><td class="mdescRight">Defines an expression representing a field in <em>builder</em>, which may be reused to build other parts of a statement, for instance as a parameter to <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab240594831b1567ed86fbf503fe9b9e2" title="Builds a new expression which reprenents a condition (or operation).">add_cond()</a> or <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#afdfd53d73ddcea4a38003a69e8f6ef40" title="Valid only for: INSERT, UPDATE, SELECT statements.">add_field_value_id()</a>. <a href="#a7af5c7f975e03545ef64e6126e8e6bb1">More...</a><br/></td></tr> <tr class="separator:a7af5c7f975e03545ef64e6126e8e6bb1"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ab0dd5badb21f63df60d29990e91aee99"><td class="memTemplParams" colspan="2">template<class ValueType > </td></tr> <tr class="memitem:ab0dd5badb21f63df60d29990e91aee99"><td class="memTemplItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memTemplItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab0dd5badb21f63df60d29990e91aee99">add_expr</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_1DataHandler.html">DataHandler</a> >& dh, const ValueType& value)</td></tr> <tr class="memdesc:ab0dd5badb21f63df60d29990e91aee99"><td class="mdescLeft"> </td><td class="mdescRight">Defines an expression in Builder which may be reused to build other parts of a statement. <a href="#ab0dd5badb21f63df60d29990e91aee99">More...</a><br/></td></tr> <tr class="separator:ab0dd5badb21f63df60d29990e91aee99"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a90be662a0174c811cf051721c710f670"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a90be662a0174c811cf051721c710f670">add_expr_as_value</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_1DataHandler.html">DataHandler</a> >& dh, const <a class="el" href="classGnome_1_1Gda_1_1Value.html">Value</a>& value)</td></tr> <tr class="memdesc:a90be662a0174c811cf051721c710f670"><td class="mdescLeft"> </td><td class="mdescRight">Defines an expression in Builder which may be reused to build other parts of a statement. <a href="#a90be662a0174c811cf051721c710f670">More...</a><br/></td></tr> <tr class="separator:a90be662a0174c811cf051721c710f670"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a776335700c50574a7cd699542176cd4a"><td class="memTemplParams" colspan="2">template<class ValueType > </td></tr> <tr class="memitem:a776335700c50574a7cd699542176cd4a"><td class="memTemplItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memTemplItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a776335700c50574a7cd699542176cd4a">add_expr</a> (const ValueType& value)</td></tr> <tr class="memdesc:a776335700c50574a7cd699542176cd4a"><td class="mdescLeft"> </td><td class="mdescRight">Defines an expression in Builder which may be reused to build other parts of a statement. <a href="#a776335700c50574a7cd699542176cd4a">More...</a><br/></td></tr> <tr class="separator:a776335700c50574a7cd699542176cd4a"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:abdb5312ae234890e5a8233754bbf2ebf"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#abdb5312ae234890e5a8233754bbf2ebf">add_expr_as_value</a> (const <a class="el" href="classGnome_1_1Gda_1_1Value.html">Value</a>& value)</td></tr> <tr class="memdesc:abdb5312ae234890e5a8233754bbf2ebf"><td class="mdescLeft"> </td><td class="mdescRight">Defines an expression in Builder which may be reused to build other parts of a statement. <a href="#abdb5312ae234890e5a8233754bbf2ebf">More...</a><br/></td></tr> <tr class="separator:abdb5312ae234890e5a8233754bbf2ebf"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a8a1e247d4d0192499d10c4193b0c7959"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a8a1e247d4d0192499d10c4193b0c7959">add_param</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& param_name, GType type, bool nullok=false)</td></tr> <tr class="memdesc:a8a1e247d4d0192499d10c4193b0c7959"><td class="mdescLeft"> </td><td class="mdescRight">Defines a parameter which may be reused to build other parts of a statement. <a href="#a8a1e247d4d0192499d10c4193b0c7959">More...</a><br/></td></tr> <tr class="separator:a8a1e247d4d0192499d10c4193b0c7959"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ab240594831b1567ed86fbf503fe9b9e2"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab240594831b1567ed86fbf503fe9b9e2">add_cond</a> (<a class="el" href="group__libgdammEnums.html#gaf8803444b14fd065222d758fdf6c64bc">SqlOperatorType</a> op, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> op1, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> op2=0, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> op3=0)</td></tr> <tr class="memdesc:ab240594831b1567ed86fbf503fe9b9e2"><td class="mdescLeft"> </td><td class="mdescRight">Builds a new expression which reprenents a condition (or operation). <a href="#ab240594831b1567ed86fbf503fe9b9e2">More...</a><br/></td></tr> <tr class="separator:ab240594831b1567ed86fbf503fe9b9e2"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a72e3fb3779e1161e8e82b77ce3ba9f72"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a72e3fb3779e1161e8e82b77ce3ba9f72">add_cond</a> (<a class="el" href="group__libgdammEnums.html#gaf8803444b14fd065222d758fdf6c64bc">SqlOperatorType</a> op, const std::vector< <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> >& op_ids)</td></tr> <tr class="memdesc:a72e3fb3779e1161e8e82b77ce3ba9f72"><td class="mdescLeft"> </td><td class="mdescRight">Builds a new expression which reprenents a condition (or operation). <a href="#a72e3fb3779e1161e8e82b77ce3ba9f72">More...</a><br/></td></tr> <tr class="separator:a72e3fb3779e1161e8e82b77ce3ba9f72"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a7fbc2be6ff12f82fb4e44764f1ae8b47"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7fbc2be6ff12f82fb4e44764f1ae8b47">add_function</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& function_name, const std::vector< <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> >& args)</td></tr> <tr class="memdesc:a7fbc2be6ff12f82fb4e44764f1ae8b47"><td class="mdescLeft"> </td><td class="mdescRight">Builds a new expression which represents a function applied to some arguments. <a href="#a7fbc2be6ff12f82fb4e44764f1ae8b47">More...</a><br/></td></tr> <tr class="separator:a7fbc2be6ff12f82fb4e44764f1ae8b47"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ae759a1c552af7a8dd1aa01549750e6ab"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ae759a1c552af7a8dd1aa01549750e6ab">add_function</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& function_name, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> <a class="elRef" href="http://gcc.gnu.org/onlinedocs/libstdc++/latest-doxygen/a00400.html#ga74f16f7323b3dd29cd367c3217b53e73">arg</a>)</td></tr> <tr class="memdesc:ae759a1c552af7a8dd1aa01549750e6ab"><td class="mdescLeft"> </td><td class="mdescRight">Builds a new expression which represents a function applied to an argument. <a href="#ae759a1c552af7a8dd1aa01549750e6ab">More...</a><br/></td></tr> <tr class="separator:ae759a1c552af7a8dd1aa01549750e6ab"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a11469a14832a1c0f069ad71449369b32"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a11469a14832a1c0f069ad71449369b32">add_sub_select</a> (const <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html">SqlStatement</a>& sqlst)</td></tr> <tr class="memdesc:a11469a14832a1c0f069ad71449369b32"><td class="mdescLeft"> </td><td class="mdescRight">Adds an expression which is a subselect. <a href="#a11469a14832a1c0f069ad71449369b32">More...</a><br/></td></tr> <tr class="separator:a11469a14832a1c0f069ad71449369b32"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a44a9747d5e1411fd7445e691e315dba5"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a44a9747d5e1411fd7445e691e315dba5">select_add_field</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& alias=<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>())</td></tr> <tr class="memdesc:a44a9747d5e1411fd7445e691e315dba5"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: SELECT statements. <a href="#a44a9747d5e1411fd7445e691e315dba5">More...</a><br/></td></tr> <tr class="separator:a44a9747d5e1411fd7445e691e315dba5"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:adccdb915c6fc2ca08d24007f94c7ee07"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#adccdb915c6fc2ca08d24007f94c7ee07">select_add_target</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& alias=<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>())</td></tr> <tr class="memdesc:adccdb915c6fc2ca08d24007f94c7ee07"><td class="mdescLeft"> </td><td class="mdescRight">Adds a new target to a SELECT statement. <a href="#adccdb915c6fc2ca08d24007f94c7ee07">More...</a><br/></td></tr> <tr class="separator:adccdb915c6fc2ca08d24007f94c7ee07"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a01aa36111b5e98e561f9b432c2e87b38"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a01aa36111b5e98e561f9b432c2e87b38">select_add_target_id</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> table_id, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& alias=<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>())</td></tr> <tr class="memdesc:a01aa36111b5e98e561f9b432c2e87b38"><td class="mdescLeft"> </td><td class="mdescRight">Adds a new target to a SELECT statement. <a href="#a01aa36111b5e98e561f9b432c2e87b38">More...</a><br/></td></tr> <tr class="separator:a01aa36111b5e98e561f9b432c2e87b38"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a8679b9f200abe6fed56d3888977d559a"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a8679b9f200abe6fed56d3888977d559a">select_join_targets</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> left_target_id, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> right_target_id, <a class="el" href="group__libgdammEnums.html#ga188d553e4e7c13460eab4ba9a8d75a12">SqlSelectJoinType</a> join_type, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> join_expr=0)</td></tr> <tr class="memdesc:a8679b9f200abe6fed56d3888977d559a"><td class="mdescLeft"> </td><td class="mdescRight">Joins two targets in a SELECT statement. <a href="#a8679b9f200abe6fed56d3888977d559a">More...</a><br/></td></tr> <tr class="separator:a8679b9f200abe6fed56d3888977d559a"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:aed815e1ac30bce96f553eca2b132b177"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#aed815e1ac30bce96f553eca2b132b177">join_add_field</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> join_id, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name)</td></tr> <tr class="memdesc:aed815e1ac30bce96f553eca2b132b177"><td class="mdescLeft"> </td><td class="mdescRight">Alter a join in a SELECT statement to make its condition use equal field values in the fields named <em>field_name</em> in both tables, via the USING keyword. <a href="#aed815e1ac30bce96f553eca2b132b177">More...</a><br/></td></tr> <tr class="separator:aed815e1ac30bce96f553eca2b132b177"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a0598f8512da2ef2c21bda0716b04f0aa"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a0598f8512da2ef2c21bda0716b04f0aa">select_order_by</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> expr_id, bool asc=true, const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& collation_name=<a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>())</td></tr> <tr class="memdesc:a0598f8512da2ef2c21bda0716b04f0aa"><td class="mdescLeft"> </td><td class="mdescRight">Adds a new ORDER BY expression to a SELECT statement. <a href="#a0598f8512da2ef2c21bda0716b04f0aa">More...</a><br/></td></tr> <tr class="separator:a0598f8512da2ef2c21bda0716b04f0aa"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ad73e5601e2ad5e245d1b4989c785e4cc"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ad73e5601e2ad5e245d1b4989c785e4cc">select_set_distinct</a> (bool distinct=true)</td></tr> <tr class="memdesc:ad73e5601e2ad5e245d1b4989c785e4cc"><td class="mdescLeft"> </td><td class="mdescRight">Adds or removes a DISTINCT clause for a SELECT statement. <a href="#ad73e5601e2ad5e245d1b4989c785e4cc">More...</a><br/></td></tr> <tr class="separator:ad73e5601e2ad5e245d1b4989c785e4cc"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a613824dd529f5e3f0712a05e925bd7e0"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a613824dd529f5e3f0712a05e925bd7e0">select_set_distinct</a> (bool distinct, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> expr_id)</td></tr> <tr class="memdesc:a613824dd529f5e3f0712a05e925bd7e0"><td class="mdescLeft"> </td><td class="mdescRight">Defines (if <em>distinct</em> is <code>true</code>) or removes (if <em>distinct</em> is <code>false</code>) a DISTINCT clause for a SELECT statement. <a href="#a613824dd529f5e3f0712a05e925bd7e0">More...</a><br/></td></tr> <tr class="separator:a613824dd529f5e3f0712a05e925bd7e0"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a15a4c2ce37c66020101be01caba3c3ae"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a15a4c2ce37c66020101be01caba3c3ae">select_set_limit</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> limit_count, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> offset=0)</td></tr> <tr class="memdesc:a15a4c2ce37c66020101be01caba3c3ae"><td class="mdescLeft"> </td><td class="mdescRight">Defines the maximum number of rows in the <a class="el" href="classGnome_1_1Gda_1_1DataModel.html" title="Abstract DataModel (Base class for all DataModels).">DataModel</a> resulting from the execution of the built statement. <a href="#a15a4c2ce37c66020101be01caba3c3ae">More...</a><br/></td></tr> <tr class="separator:a15a4c2ce37c66020101be01caba3c3ae"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a77d9f993a15e495f201a60415728b53e"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a77d9f993a15e495f201a60415728b53e">select_set_limit_id</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> limit_count_expr_id, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> limit_offest_expr_id=0)</td></tr> <tr class="memdesc:a77d9f993a15e495f201a60415728b53e"><td class="mdescLeft"> </td><td class="mdescRight">If <em>limit_count_expr_id</em> is not %0, defines the maximum number of rows in the <a class="el" href="classGnome_1_1Gda_1_1DataModel.html" title="Abstract DataModel (Base class for all DataModels).">Gda::DataModel</a> resulting from the execution of the built statement. <a href="#a77d9f993a15e495f201a60415728b53e">More...</a><br/></td></tr> <tr class="separator:a77d9f993a15e495f201a60415728b53e"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ac928cbb7b507cc06e480703068c49f44"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ac928cbb7b507cc06e480703068c49f44">select_set_having</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> cond_id)</td></tr> <tr class="memdesc:ac928cbb7b507cc06e480703068c49f44"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: SELECT statements. <a href="#ac928cbb7b507cc06e480703068c49f44">More...</a><br/></td></tr> <tr class="separator:ac928cbb7b507cc06e480703068c49f44"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:ac6d756cc86ecf8fcc9c814d291ddeaaa"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ac6d756cc86ecf8fcc9c814d291ddeaaa">select_group_by</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> expr_id)</td></tr> <tr class="memdesc:ac6d756cc86ecf8fcc9c814d291ddeaaa"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: SELECT statements. <a href="#ac6d756cc86ecf8fcc9c814d291ddeaaa">More...</a><br/></td></tr> <tr class="separator:ac6d756cc86ecf8fcc9c814d291ddeaaa"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a86e3f10099ed1ae72923436830f37a86"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a86e3f10099ed1ae72923436830f37a86">set_table</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& table_name)</td></tr> <tr class="memdesc:a86e3f10099ed1ae72923436830f37a86"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: INSERT, UPDATE, DELETE statements. <a href="#a86e3f10099ed1ae72923436830f37a86">More...</a><br/></td></tr> <tr class="separator:a86e3f10099ed1ae72923436830f37a86"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a9d2ee2cc23937753279ab956f4093aa8"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a9d2ee2cc23937753279ab956f4093aa8">set_where</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> cond_id)</td></tr> <tr class="memdesc:a9d2ee2cc23937753279ab956f4093aa8"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: UPDATE, DELETE, SELECT statements. <a href="#a9d2ee2cc23937753279ab956f4093aa8">More...</a><br/></td></tr> <tr class="separator:a9d2ee2cc23937753279ab956f4093aa8"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:afdfd53d73ddcea4a38003a69e8f6ef40"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#afdfd53d73ddcea4a38003a69e8f6ef40">add_field_value_id</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> field_id, <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> value_id=0)</td></tr> <tr class="memdesc:afdfd53d73ddcea4a38003a69e8f6ef40"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: INSERT, UPDATE, SELECT statements. <a href="#afdfd53d73ddcea4a38003a69e8f6ef40">More...</a><br/></td></tr> <tr class="separator:afdfd53d73ddcea4a38003a69e8f6ef40"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a7436b3d2941d4279186a428386849f09"><td class="memTemplParams" colspan="2">template<class ValueType > </td></tr> <tr class="memitem:a7436b3d2941d4279186a428386849f09"><td class="memTemplItemLeft" align="right" valign="top">void </td><td class="memTemplItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7436b3d2941d4279186a428386849f09">add_field_value</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name, const ValueType& value)</td></tr> <tr class="memdesc:a7436b3d2941d4279186a428386849f09"><td class="mdescLeft"> </td><td class="mdescRight">Specifies that the field represented by <em>field_name</em> will be set to the <em>value</em>. <a href="#a7436b3d2941d4279186a428386849f09">More...</a><br/></td></tr> <tr class="separator:a7436b3d2941d4279186a428386849f09"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a5c3192c1bf4536985d7270b6967a79fc"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a5c3192c1bf4536985d7270b6967a79fc">add_field_value_as_value</a> (const <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>& field_name, const <a class="el" href="classGnome_1_1Gda_1_1Value.html">Value</a>& value)</td></tr> <tr class="memdesc:a5c3192c1bf4536985d7270b6967a79fc"><td class="mdescLeft"> </td><td class="mdescRight">Valid only for: INSERT, UPDATE statements. <a href="#a5c3192c1bf4536985d7270b6967a79fc">More...</a><br/></td></tr> <tr class="separator:a5c3192c1bf4536985d7270b6967a79fc"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a01090bc2225e99333745dcaac8e5d548"><td class="memItemLeft" align="right" valign="top">void </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a01090bc2225e99333745dcaac8e5d548">compound_add_sub_select</a> (const <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html">SqlStatement</a>& sqlst)</td></tr> <tr class="memdesc:a01090bc2225e99333745dcaac8e5d548"><td class="mdescLeft"> </td><td class="mdescRight">Add a sub select to a COMPOUND statement. <a href="#a01090bc2225e99333745dcaac8e5d548">More...</a><br/></td></tr> <tr class="separator:a01090bc2225e99333745dcaac8e5d548"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a76b7b55e3d5422c7c17642659ad43c07"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html">SqlExpr</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a76b7b55e3d5422c7c17642659ad43c07">export_expression</a> (<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> id) const </td></tr> <tr class="memdesc:a76b7b55e3d5422c7c17642659ad43c07"><td class="mdescLeft"> </td><td class="mdescRight">Exports a part managed by <em>builder</em> as a new <a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html" title="This contains any expression, either as a value, a variable, or as other types of expressions...">Gda::SqlExpr</a>, which can represent any expression in a statement. <a href="#a76b7b55e3d5422c7c17642659ad43c07">More...</a><br/></td></tr> <tr class="separator:a76b7b55e3d5422c7c17642659ad43c07"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:a6949af6a314fa9e47001e386a24fe87d"><td class="memItemLeft" align="right" valign="top"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a6949af6a314fa9e47001e386a24fe87d">import_expression</a> (const <a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html">SqlExpr</a>& expr)</td></tr> <tr class="memdesc:a6949af6a314fa9e47001e386a24fe87d"><td class="mdescLeft"> </td><td class="mdescRight">Imports the expression. <a href="#a6949af6a314fa9e47001e386a24fe87d">More...</a><br/></td></tr> <tr class="separator:a6949af6a314fa9e47001e386a24fe87d"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-static-methods"></a> Static Public Member Functions</h2></td></tr> <tr class="memitem:a1fa9ce91f5024b693a8947623a73e344"><td class="memItemLeft" align="right" valign="top">static GType </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a1fa9ce91f5024b693a8947623a73e344">get_type</a> ()</td></tr> <tr class="memdesc:a1fa9ce91f5024b693a8947623a73e344"><td class="mdescLeft"> </td><td class="mdescRight">Get the GType for this class, for use with the underlying GObject type system. <a href="#a1fa9ce91f5024b693a8947623a73e344">More...</a><br/></td></tr> <tr class="separator:a1fa9ce91f5024b693a8947623a73e344"><td class="memSeparator" colspan="2"> </td></tr> <tr class="memitem:af81b21287d19666042763bfe3409ae20"><td class="memItemLeft" align="right" valign="top">static <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a>< <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html">SqlBuilder</a> > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#af81b21287d19666042763bfe3409ae20">create</a> (<a class="el" href="group__libgdammEnums.html#ga6486682ec362b106fb5ad2807a68b155">SqlStatementType</a> type)</td></tr> <tr class="separator:af81b21287d19666042763bfe3409ae20"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-methods"></a> Protected Member Functions</h2></td></tr> <tr class="memitem:a4df518f33d8d2dd1580c218d48e54fc0"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a4df518f33d8d2dd1580c218d48e54fc0">SqlBuilder</a> (<a class="el" href="group__libgdammEnums.html#ga6486682ec362b106fb5ad2807a68b155">SqlStatementType</a> type)</td></tr> <tr class="separator:a4df518f33d8d2dd1580c218d48e54fc0"><td class="memSeparator" colspan="2"> </td></tr> </table><table class="memberdecls"> <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="related"></a> Related Functions</h2></td></tr> <tr><td class="ititle" colspan="2"><p>(Note that these are not member functions.) </p> </td></tr> <tr class="memitem:a64c27d59eec590c15946e4ea31cf4296"><td class="memItemLeft" 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_1SqlBuilder.html">Gnome::Gda::SqlBuilder</a> > </td><td class="memItemRight" valign="bottom"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a64c27d59eec590c15946e4ea31cf4296">wrap</a> (GdaSqlBuilder* object, bool take_copy=false)</td></tr> <tr class="memdesc:a64c27d59eec590c15946e4ea31cf4296"><td class="mdescLeft"> </td><td class="mdescRight">A <a class="elRef" href="../../../glibmm-2.4/reference/html/namespaceGlib.html#a671306f4a3a0cae5ab4d7a9d54886592">Glib::wrap()</a> method for this object. <a href="#a64c27d59eec590c15946e4ea31cf4296">More...</a><br/></td></tr> <tr class="separator:a64c27d59eec590c15946e4ea31cf4296"><td class="memSeparator" colspan="2"> </td></tr> </table> <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> <div class="textblock"><p><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html" title="SqlBuilder can be used to build a Statement from its structural description, much in the same way a S...">SqlBuilder</a> can be used to build a <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> from its structural description, much in the same way a <a class="el" href="classGnome_1_1Gda_1_1SqlParser.html" title="SQL parser.">SqlParser</a> can be used to build a <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Statement</a> from a SQL string. </p> <p>You may, for instance, pass the <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html" title="SqlBuilder can be used to build a Statement from its structural description, much in the same way a S...">SqlBuilder</a> directly to <a class="el" href="classGnome_1_1Gda_1_1Connection.html#ad7aee0fae667d413c7ccc88f84e06f9b">Connection::statement_execute_select_builder()</a> or <a class="el" href="classGnome_1_1Gda_1_1Connection.html#a6a32a0568c3be8cc5dfeabecca51eb88">Connection::statement_execute_non_select_builder()</a>. Or you may instead call <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a791685038abb1492ad7366fd1d188b56" title="Creates a new Gda::Statement statement from builder's contents.">get_statement()</a> and use the resulting <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html" title="Every SQL statement can be decomposed in the SqlStatement tree structure.">SqlStatement</a>.</p> <p>During the building process, some pieces of the statement are constructed and assembled into the final statement. Each of these pieces can be reused anytime in the same <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html" title="SqlBuilder can be used to build a Statement from its structural description, much in the same way a S...">SqlBuilder</a> object, and each is identified using a single ID. That ID is dynamically allocated by the object.</p> <p>This simple example builds the equivalent of this SQL query: "SELECT employees.name_first, employees.name_last FROM employees WHERE employees.employee_id = 123".</p> <div class="fragment"><div class="line"><a class="codeRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr<Gnome::Gda::SqlBuilder></a> builder =</div> <div class="line"> <a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#af81b21287d19666042763bfe3409ae20">Gnome::Gda::SqlBuilder::create</a>(<a class="code" href="group__libgdammEnums.html#gga6486682ec362b106fb5ad2807a68b155afcee8d0ffcd34bb438da13578d45aff8">Gnome::Gda::SQL_STATEMENT_SELECT</a>);</div> <div class="line">builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#a44a9747d5e1411fd7445e691e315dba5" title="Valid only for: SELECT statements.">select_add_field</a>(<span class="stringliteral">"name_fist"</span>, <span class="stringliteral">"employees"</span>);</div> <div class="line">builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#a44a9747d5e1411fd7445e691e315dba5" title="Valid only for: SELECT statements.">select_add_field</a>(<span class="stringliteral">"name_last"</span>, <span class="stringliteral">"employees"</span>);</div> <div class="line">builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#adccdb915c6fc2ca08d24007f94c7ee07" title="Adds a new target to a SELECT statement.">select_add_target</a>(<span class="stringliteral">"employees"</span>);</div> <div class="line">builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#a9d2ee2cc23937753279ab956f4093aa8" title="Valid only for: UPDATE, DELETE, SELECT statements.">set_where</a>(</div> <div class="line"> builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab240594831b1567ed86fbf503fe9b9e2" title="Builds a new expression which reprenents a condition (or operation).">add_cond</a>(<a class="code" href="group__libgdammEnums.html#ggaf8803444b14fd065222d758fdf6c64bca8815d41adfb6424279cfc8e450f6462f">Gnome::Gda::SQL_OPERATOR_TYPE_EQ</a>,</div> <div class="line"> builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7af5c7f975e03545ef64e6126e8e6bb1" title="Defines an expression representing a field in builder, which may be reused to build other parts of a ...">add_field_id</a>(<span class="stringliteral">"employee_id"</span>, <span class="stringliteral">"employees"</span>),</div> <div class="line"> builder-><a class="code" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab0dd5badb21f63df60d29990e91aee99" title="Defines an expression in Builder which may be reused to build other parts of a statement.">add_expr</a>(123)));</div> </div><!-- fragment --><p>Note that, in this simple example, it's not necessary to specify the extra "employees" table name parameter to <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a44a9747d5e1411fd7445e691e315dba5" title="Valid only for: SELECT statements.">select_add_field()</a> and <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7af5c7f975e03545ef64e6126e8e6bb1" title="Defines an expression representing a field in builder, which may be reused to build other parts of a ...">add_field_id()</a>, though it's often a good idea to avoid ambiguity in larger queries. </p> </div><h2 class="groupheader">Member Typedef Documentation</h2> <a class="anchor" id="ab7e7f17fa01e488ba2cc558e18f5ac2c"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">typedef guint <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Gnome::Gda::SqlBuilder::Id</a></td> </tr> </table> </div><div class="memdoc"> </div> </div> <h2 class="groupheader">Constructor & Destructor Documentation</h2> <a class="anchor" id="ae8148cf7efba4bdd05e66ee1437cfefa"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">virtual Gnome::Gda::SqlBuilder::~SqlBuilder </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">virtual</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <a class="anchor" id="a4df518f33d8d2dd1580c218d48e54fc0"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">Gnome::Gda::SqlBuilder::SqlBuilder </td> <td>(</td> <td class="paramtype"><a class="el" href="group__libgdammEnums.html#ga6486682ec362b106fb5ad2807a68b155">SqlStatementType</a> </td> <td class="paramname"><em>type</em></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">protected</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <h2 class="groupheader">Member Function Documentation</h2> <a class="anchor" id="ab240594831b1567ed86fbf503fe9b9e2"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_cond </td> <td>(</td> <td class="paramtype"><a class="el" href="group__libgdammEnums.html#gaf8803444b14fd065222d758fdf6c64bc">SqlOperatorType</a> </td> <td class="paramname"><em>op</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>op1</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>op2</em> = <code>0</code>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>op3</em> = <code>0</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Builds a new expression which reprenents a condition (or operation). </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">op</td><td>Type of condition </td></tr> <tr><td class="paramname">op1</td><td>The ID of the 1st argument (not 0) </td></tr> <tr><td class="paramname">op2</td><td>The ID of the 2st argument (maybe 0 if op only requires one argument) </td></tr> <tr><td class="paramname">op3</td><td>The ID of the 3st argument (maybe 0 if op only requires one or two arguments)</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a72e3fb3779e1161e8e82b77ce3ba9f72"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_cond </td> <td>(</td> <td class="paramtype"><a class="el" href="group__libgdammEnums.html#gaf8803444b14fd065222d758fdf6c64bc">SqlOperatorType</a> </td> <td class="paramname"><em>op</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::vector< <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> >& </td> <td class="paramname"><em>op_ids</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Builds a new expression which reprenents a condition (or operation). </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">op</td><td>Type of condition </td></tr> <tr><td class="paramname">op_ids,:</td><td>list of IDs of the operands of the condition</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="ab0dd5badb21f63df60d29990e91aee99"></a> <div class="memitem"> <div class="memproto"> <div class="memtemplate"> template <class ValueType > </div> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_expr </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_1DataHandler.html">DataHandler</a> >& </td> <td class="paramname"><em>dh</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const ValueType & </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Defines an expression in Builder which may be reused to build other parts of a statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">dh</td><td>The datahandler to use </td></tr> <tr><td class="paramname">value,:</td><td>value to set the expression to</td></tr> </table> </dd> </dl> <p>See expr() except that no custom datahandler is given</p> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a776335700c50574a7cd699542176cd4a"></a> <div class="memitem"> <div class="memproto"> <div class="memtemplate"> template <class ValueType > </div> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_expr </td> <td>(</td> <td class="paramtype">const ValueType & </td> <td class="paramname"><em>value</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Defines an expression in Builder which may be reused to build other parts of a statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">value,:</td><td>value to set the expression to</td></tr> </table> </dd> </dl> <p>See expr() except that no custom datahandler is given</p> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a90be662a0174c811cf051721c710f670"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_expr_as_value </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_1DataHandler.html">DataHandler</a> >& </td> <td class="paramname"><em>dh</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const <a class="el" href="classGnome_1_1Gda_1_1Value.html">Value</a>& </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Defines an expression in Builder which may be reused to build other parts of a statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">dh</td><td>The datahandler to use </td></tr> <tr><td class="paramname">value,:</td><td>value to set the expression to</td></tr> </table> </dd> </dl> <p>See expr() except that no custom datahandler is given</p> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="abdb5312ae234890e5a8233754bbf2ebf"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_expr_as_value </td> <td>(</td> <td class="paramtype">const <a class="el" href="classGnome_1_1Gda_1_1Value.html">Value</a>& </td> <td class="paramname"><em>value</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Defines an expression in Builder which may be reused to build other parts of a statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">value,:</td><td>value to set the expression to</td></tr> </table> </dd> </dl> <p>See expr() except that no custom datahandler is given</p> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a7af5c7f975e03545ef64e6126e8e6bb1"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_field_id </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>field_name</em>, </td> </tr> <tr> <td class="paramkey"></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>table_name</em> = <code><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>()</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Defines an expression representing a field in <em>builder</em>, which may be reused to build other parts of a statement, for instance as a parameter to <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab240594831b1567ed86fbf503fe9b9e2" title="Builds a new expression which reprenents a condition (or operation).">add_cond()</a> or <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#afdfd53d73ddcea4a38003a69e8f6ef40" title="Valid only for: INSERT, UPDATE, SELECT statements.">add_field_value_id()</a>. </p> <p>Calling this with a <code>0</code> <em>table_name</em> is equivalent to calling <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a6d5a21a49cec727f46d6f4bb88b433fa" title="Defines an expression representing an identifier in builder, which may be reused to build other parts...">add_id()</a>.</p> <p>For SELECT queries, see <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a44a9747d5e1411fd7445e691e315dba5" title="Valid only for: SELECT statements.">select_add_field()</a>.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000009">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">field_name</td><td>A field name. </td></tr> <tr><td class="paramname">table_name</td><td>A table name, or <code>0</code>. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or %0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a7436b3d2941d4279186a428386849f09"></a> <div class="memitem"> <div class="memproto"> <div class="memtemplate"> template <class ValueType > </div> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::add_field_value </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>field_name</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const ValueType & </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Specifies that the field represented by <em>field_name</em> will be set to the <em>value</em>. </p> <p>See gadd_expr() for more information. This is valid only for INSERT and UPDATE statements.</p> <p>field_name A field name. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">value</td><td>The value to set the field to. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a5c3192c1bf4536985d7270b6967a79fc"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::add_field_value_as_value </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>field_name</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const <a class="el" href="classGnome_1_1Gda_1_1Value.html">Value</a>& </td> <td class="paramname"><em>value</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: INSERT, UPDATE statements. </p> <p>Specifies that the field represented by <em>field_name</em> will be set to the value identified by <em>value</em> </p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000021">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">field_name</td><td>A field name. </td></tr> <tr><td class="paramname">value</td><td><a class="el" href="classGnome_1_1Gda_1_1Value.html" title="Use value_type() to identify the value type at runtime.">Value</a> to set the field to, or <code>0</code> or a GDA_TYPE_<code>0</code> value to represent an SQL <code>0</code>. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="afdfd53d73ddcea4a38003a69e8f6ef40"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::add_field_value_id </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>field_id</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>value_id</em> = <code>0</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: INSERT, UPDATE, SELECT statements. </p> <ul> <li>For UPDATE: specifies that the field represented by <em>field_id</em> will be set to the value identified by <em>value_id</em>.</li> <li>For SELECT: add a selected item to the statement, and if <em>value_id</em> is not %0, then use it as an alias</li> <li>For INSERT: if <em>field_id</em> represents an SQL identifier (obtained using <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a6d5a21a49cec727f46d6f4bb88b433fa" title="Defines an expression representing an identifier in builder, which may be reused to build other parts...">add_id()</a>): then if <em>value_id</em> is not %0 then specifies that the field represented by <em>field_id</em> will be set to the value identified by <em>value_id</em>, otherwise just specifies a named field to be given a value. If <em>field_id</em> represents a sub SELECT (obtained using <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a11469a14832a1c0f069ad71449369b32" title="Adds an expression which is a subselect.">add_sub_select()</a>), then this method call defines the sub SELECT from which values to insert are taken.</li> </ul> <p>See also <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7436b3d2941d4279186a428386849f09" title="Specifies that the field represented by field_name will be set to the value.">add_field_value()</a> and add_field_value_as_gvalue().</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000020">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">field_id</td><td>The ID of the field's name or definition. </td></tr> <tr><td class="paramname">value_id</td><td>The ID of the value to set the field to, or %0. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a7fbc2be6ff12f82fb4e44764f1ae8b47"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_function </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>function_name</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">const std::vector< <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> >& </td> <td class="paramname"><em>args</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Builds a new expression which represents a function applied to some arguments. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">function_name</td><td>The name of the function to embed (e.g. MAX, MIN, ...) </td></tr> <tr><td class="paramname">args,:</td><td>list of ids of the arguments to the function</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new target, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="ae759a1c552af7a8dd1aa01549750e6ab"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_function </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>function_name</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>arg</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Builds a new expression which represents a function applied to an argument. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">function_name</td><td>The name of the function to embed (e.g. MAX, MIN, ...) </td></tr> <tr><td class="paramname">arg,:</td><td>The ids of the argument to the function</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new target, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a6d5a21a49cec727f46d6f4bb88b433fa"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_id </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>string</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Defines an expression representing an identifier in <em>builder</em>, which may be reused to build other parts of a statement, for instance as a parameter to <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab240594831b1567ed86fbf503fe9b9e2" title="Builds a new expression which reprenents a condition (or operation).">add_cond()</a> or <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#afdfd53d73ddcea4a38003a69e8f6ef40" title="Valid only for: INSERT, UPDATE, SELECT statements.">add_field_value_id()</a>. </p> <p>The new expression will contain the <em>string</em> literal. For example:</p> <p>gda_sql_builder_add_id (b, "name") gda_sql_builder_add_id (b, "date")</p> <p>will be rendered as SQL as:</p> <p>name "date"</p> <p>because "date" is an SQL reserved keyword.</p> <p>For fields, see <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7af5c7f975e03545ef64e6126e8e6bb1" title="Defines an expression representing a field in builder, which may be reused to build other parts of a ...">add_field_id()</a>.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000008">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">string</td><td>A string. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or %0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a8a1e247d4d0192499d10c4193b0c7959"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_param </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>param_name</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">GType </td> <td class="paramname"><em>type</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">bool </td> <td class="paramname"><em>nullok</em> = <code>false</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Defines a parameter which may be reused to build other parts of a statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname"></td><td>param_name: name of the parameter : GType of the parameter True if the parameter can be set to NULL</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a11469a14832a1c0f069ad71449369b32"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::add_sub_select </td> <td>(</td> <td class="paramtype">const <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html">SqlStatement</a>& </td> <td class="paramname"><em>sqlst</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Adds an expression which is a subselect. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">sqlst</td><td>A <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html" title="Every SQL statement can be decomposed in the SqlStatement tree structure.">SqlStatement</a>, which must be a SELECT or compound SELECT. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a01090bc2225e99333745dcaac8e5d548"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::compound_add_sub_select </td> <td>(</td> <td class="paramtype">const <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html">SqlStatement</a>& </td> <td class="paramname"><em>sqlst</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Add a sub select to a COMPOUND statement. </p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000022">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">sqlst</td><td>A pointer to a <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html" title="Every SQL statement can be decomposed in the SqlStatement tree structure.">Gda::SqlStatement</a>, which has to be a SELECT or compound SELECT. This will be copied. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="af81b21287d19666042763bfe3409ae20"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">static <a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1RefPtr.html">Glib::RefPtr</a><<a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html">SqlBuilder</a>> Gnome::Gda::SqlBuilder::create </td> <td>(</td> <td class="paramtype"><a class="el" href="group__libgdammEnums.html#ga6486682ec362b106fb5ad2807a68b155">SqlStatementType</a> </td> <td class="paramname"><em>type</em></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">static</span></span> </td> </tr> </table> </div><div class="memdoc"> </div> </div> <a class="anchor" id="a76b7b55e3d5422c7c17642659ad43c07"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html">SqlExpr</a> Gnome::Gda::SqlBuilder::export_expression </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>id</em></td><td>)</td> <td> const</td> </tr> </table> </div><div class="memdoc"> <p>Exports a part managed by <em>builder</em> as a new <a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html" title="This contains any expression, either as a value, a variable, or as other types of expressions...">Gda::SqlExpr</a>, which can represent any expression in a statement. </p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000023">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">id</td><td>The ID of the expression to be exported, (must be a valid ID in <em>builder</em>, not %0). </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>A pointer to a new <a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html" title="This contains any expression, either as a value, a variable, or as other types of expressions...">Gda::SqlExpr</a> structure, free using gda_sql_expr_free() when not needed anymore. If the part with <em>id</em> as ID cannot be found, the returned value is <code>0</code>. </dd></dl> </div> </div> <a class="anchor" id="aa12c40b1f38dfcfd84afd361c454122b"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html">SqlStatement</a> Gnome::Gda::SqlBuilder::get_sql_statement </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const</td> </tr> </table> </div><div class="memdoc"> <p>Creates a new <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html" title="Every SQL statement can be decomposed in the SqlStatement tree structure.">Gda::SqlStatement</a> structure from <em>builder's</em> contents. </p> <p>The returned pointer belongs to <em>builder's</em> internal representation. Use gda_sql_statement_copy() if you need to keep it.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000007">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="section return"><dt>Returns</dt><dd>A <a class="el" href="classGnome_1_1Gda_1_1SqlStatement.html" title="Every SQL statement can be decomposed in the SqlStatement tree structure.">Gda::SqlStatement</a> pointer. </dd></dl> </div> </div> <a class="anchor" id="a791685038abb1492ad7366fd1d188b56"></a> <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_1Statement.html">Statement</a>> Gnome::Gda::SqlBuilder::get_statement </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const</td> </tr> </table> </div><div class="memdoc"> <p>Creates a new <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Gda::Statement</a> statement from <em>builder's</em> contents. </p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000006">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="section return"><dt>Returns</dt><dd>A new <a class="el" href="classGnome_1_1Gda_1_1Statement.html" title="Single SQL statement.">Gda::Statement</a> object, or <code>0</code> if an error occurred. </dd></dl> </div> </div> <a class="anchor" id="a1fa9ce91f5024b693a8947623a73e344"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">static GType Gnome::Gda::SqlBuilder::get_type </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">static</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Get the GType for this class, for use with the underlying GObject type system. </p> </div> </div> <a class="anchor" id="a0941410e8750343ef81c5723aa0413ed"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">GdaSqlBuilder* Gnome::Gda::SqlBuilder::gobj </td> <td>(</td> <td class="paramname"></td><td>)</td> <td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">inline</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Provides access to the underlying C GObject. </p> </div> </div> <a class="anchor" id="a82622d83c9160437c90562131a62e445"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <table class="memname"> <tr> <td class="memname">const GdaSqlBuilder* Gnome::Gda::SqlBuilder::gobj </td> <td>(</td> <td class="paramname"></td><td>)</td> <td> const</td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">inline</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>Provides access to the underlying C GObject. </p> </div> </div> <a class="anchor" id="a1a3162272a5b71c34f25c65a9e8f015f"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">GdaSqlBuilder* Gnome::Gda::SqlBuilder::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> <a class="anchor" id="a6949af6a314fa9e47001e386a24fe87d"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::import_expression </td> <td>(</td> <td class="paramtype">const <a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html">SqlExpr</a>& </td> <td class="paramname"><em>expr</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Imports the expression. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">expr</td><td>A <a class="el" href="classGnome_1_1Gda_1_1SqlExpr.html" title="This contains any expression, either as a value, a variable, or as other types of expressions...">SqlExpr</a> obtained using <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a76b7b55e3d5422c7c17642659ad43c07" title="Exports a part managed by builder as a new Gda::SqlExpr, which can represent any expression in a stat...">export_expression()</a>. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new expression, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="aed815e1ac30bce96f553eca2b132b177"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::join_add_field </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>join_id</em>, </td> </tr> <tr> <td class="paramkey"></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>field_name</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Alter a join in a SELECT statement to make its condition use equal field values in the fields named <em>field_name</em> in both tables, via the USING keyword. </p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000012">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">join_id</td><td>The ID of the join to modify (not %0). </td></tr> <tr><td class="paramname">field_name</td><td>The name of the field to use in the join condition (not <code>0</code>). </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new join, or %0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a44a9747d5e1411fd7445e691e315dba5"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::select_add_field </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>field_name</em>, </td> </tr> <tr> <td class="paramkey"></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>table_name</em>, </td> </tr> <tr> <td class="paramkey"></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>alias</em> = <code><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>()</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: SELECT statements. </p> <p>Add a selected selected item to the SELECT statement.</p> <p>For non-SELECT statements, see <a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#a7af5c7f975e03545ef64e6126e8e6bb1" title="Defines an expression representing a field in builder, which may be reused to build other parts of a ...">add_field_id()</a>.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000010">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">field_name</td><td>A field name. </td></tr> <tr><td class="paramname">table_name</td><td>A table name, or <code>0</code>. </td></tr> <tr><td class="paramname">alias</td><td>An alias (eg. for the "AS" clause), or <code>0</code>. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the added field, or %0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="adccdb915c6fc2ca08d24007f94c7ee07"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::select_add_target </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>table_name</em>, </td> </tr> <tr> <td class="paramkey"></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>alias</em> = <code><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>()</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Adds a new target to a SELECT statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">table_id</td><td>The ID of the expression holding a table reference. </td></tr> <tr><td class="paramname">alias</td><td>The alias to give to the target.</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new target, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a01aa36111b5e98e561f9b432c2e87b38"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::select_add_target_id </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>table_id</em>, </td> </tr> <tr> <td class="paramkey"></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>alias</em> = <code><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>()</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Adds a new target to a SELECT statement. </p> <p>If there already exists a target representing the same table and the same alias (or with the same absence of alias) then the same target ID is returned instead of the ID of a new target.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000011">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">table_id</td><td>The ID of the expression holding a table reference (not %0). </td></tr> <tr><td class="paramname">alias</td><td>The alias to give to the target, or <code>0</code>. </td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new (or existing) target, or %0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="ac6d756cc86ecf8fcc9c814d291ddeaaa"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_group_by </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>expr_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: SELECT statements. </p> <p>Adds the <em>expr_id</em> expression to the GROUP BY clause's expressions list</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000017">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">expr_id</td><td>The ID of the expression to set use in the GROUP BY clause, or 0 to unset any previous GROUP BY clause. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a8679b9f200abe6fed56d3888977d559a"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> Gnome::Gda::SqlBuilder::select_join_targets </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>left_target_id</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>right_target_id</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="group__libgdammEnums.html#ga188d553e4e7c13460eab4ba9a8d75a12">SqlSelectJoinType</a> </td> <td class="paramname"><em>join_type</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>join_expr</em> = <code>0</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Joins two targets in a SELECT statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">left_target_id</td><td>The ID of the left target to use (not %0) </td></tr> <tr><td class="paramname">right_target_id</td><td>The ID of the right target to use (not %0) </td></tr> <tr><td class="paramname">join_type</td><td>The type of join </td></tr> <tr><td class="paramname">join_expr</td><td>Joining expression's ID, or %0</td></tr> </table> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>The ID of the new join, or 0 if there was an error. </dd></dl> </div> </div> <a class="anchor" id="a0598f8512da2ef2c21bda0716b04f0aa"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_order_by </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>expr_id</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype">bool </td> <td class="paramname"><em>asc</em> = <code>true</code>, </td> </tr> <tr> <td class="paramkey"></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>collation_name</em> = <code><a class="elRef" href="../../../glibmm-2.4/reference/html/classGlib_1_1ustring.html">Glib::ustring</a>()</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Adds a new ORDER BY expression to a SELECT statement. </p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000013">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">expr_id</td><td>The ID of the expression to use during sorting (not %0). </td></tr> <tr><td class="paramname">asc</td><td><code>true</code> for an ascending sorting. </td></tr> <tr><td class="paramname">collation_name</td><td>Name of the collation to use when sorting, or <code>0</code>. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="ad73e5601e2ad5e245d1b4989c785e4cc"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_set_distinct </td> <td>(</td> <td class="paramtype">bool </td> <td class="paramname"><em>distinct</em> = <code>true</code></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Adds or removes a DISTINCT clause for a SELECT statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">distinct</td><td>Whether a DISTINCT clause should be in the SELECT statement. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a613824dd529f5e3f0712a05e925bd7e0"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_set_distinct </td> <td>(</td> <td class="paramtype">bool </td> <td class="paramname"><em>distinct</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>expr_id</em> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Defines (if <em>distinct</em> is <code>true</code>) or removes (if <em>distinct</em> is <code>false</code>) a DISTINCT clause for a SELECT statement. </p> <p>If <em>distinct</em> is <code>true</code>, then the ID of an expression can be specified as the <em>expr_id</em> argument: if not %0, this is the expression used to apply the DISTINCT clause on (the resuting SQL will then usually be "... DISTINCT ON <expression>...").</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000014">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">distinct</td><td><a class="el" href="classGnome_1_1Gda_1_1Set.html" title="Container for several values.">Set</a> to <code>true</code> to have the DISTINCT requirement. </td></tr> <tr><td class="paramname">expr_id</td><td>The ID of the DISTINCT ON expression, or %0 if no expression is to be used. It is ignored if <em>distinct</em> is <code>false</code>. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="ac928cbb7b507cc06e480703068c49f44"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_set_having </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>cond_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: SELECT statements. </p> <p>Sets the HAVING condition of the statement</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000016">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">cond_id</td><td>The ID of the expression to set as HAVING condition, or 0 to unset any previous HAVING condition. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a15a4c2ce37c66020101be01caba3c3ae"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_set_limit </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>limit_count</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>offset</em> = <code>0</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>Defines the maximum number of rows in the <a class="el" href="classGnome_1_1Gda_1_1DataModel.html" title="Abstract DataModel (Base class for all DataModels).">DataModel</a> resulting from the execution of the built statement. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">limit_count</td><td>The number of rows that should be returned. </td></tr> <tr><td class="paramname">The</td><td>offset of the first row that should appear in the result. (note that this feature may not be supported by all the database providers.) </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a77d9f993a15e495f201a60415728b53e"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::select_set_limit_id </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>limit_count_expr_id</em>, </td> </tr> <tr> <td class="paramkey"></td> <td></td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>limit_offest_expr_id</em> = <code>0</code> </td> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </div><div class="memdoc"> <p>If <em>limit_count_expr_id</em> is not %0, defines the maximum number of rows in the <a class="el" href="classGnome_1_1Gda_1_1DataModel.html" title="Abstract DataModel (Base class for all DataModels).">Gda::DataModel</a> resulting from the execution of the built statement. </p> <p>In this case, the offset from which the rows must be collected can be defined by the <em>limit_offset_expr_id</em> expression if not %0 (note that this feature may not be supported by all the database providers).</p> <p>If <em>limit_count_expr_id</em> is %0, then removes any LIMIT which may have been imposed by a previous call to this method.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000015">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">limit_count_expr_id</td><td>The ID of the LIMIT expression, or %0. </td></tr> <tr><td class="paramname">limit_offset_expr_id</td><td>The ID of the OFFSET expression, or %0. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a86e3f10099ed1ae72923436830f37a86"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::set_table </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>table_name</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: INSERT, UPDATE, DELETE statements. </p> <p>Sets the name of the table on which the built statement operates.</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000018">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">table_name</td><td>A table name. </td></tr> </table> </dd> </dl> </div> </div> <a class="anchor" id="a9d2ee2cc23937753279ab956f4093aa8"></a> <div class="memitem"> <div class="memproto"> <table class="memname"> <tr> <td class="memname">void Gnome::Gda::SqlBuilder::set_where </td> <td>(</td> <td class="paramtype"><a class="el" href="classGnome_1_1Gda_1_1SqlBuilder.html#ab7e7f17fa01e488ba2cc558e18f5ac2c">Id</a> </td> <td class="paramname"><em>cond_id</em></td><td>)</td> <td></td> </tr> </table> </div><div class="memdoc"> <p>Valid only for: UPDATE, DELETE, SELECT statements. </p> <p>Sets the WHERE condition of the statement</p> <dl class="since_4_2"><dt><b><a class="el" href="since_4_2.html#_since_4_2000019">Since libgdamm 4.2:</a></b></dt><dd></dd></dl> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">cond_id</td><td>The ID of the expression to set as WHERE condition, or 0 to unset any previous WHERE condition. </td></tr> </table> </dd> </dl> </div> </div> <h2 class="groupheader">Friends And Related Function Documentation</h2> <a class="anchor" id="a64c27d59eec590c15946e4ea31cf4296"></a> <div class="memitem"> <div class="memproto"> <table class="mlabels"> <tr> <td class="mlabels-left"> <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_1SqlBuilder.html">Gnome::Gda::SqlBuilder</a> > wrap </td> <td>(</td> <td class="paramtype">GdaSqlBuilder * </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> </tr> <tr> <td></td> <td>)</td> <td></td><td></td> </tr> </table> </td> <td class="mlabels-right"> <span class="mlabels"><span class="mlabel">related</span></span> </td> </tr> </table> </div><div class="memdoc"> <p>A <a class="elRef" href="../../../glibmm-2.4/reference/html/namespaceGlib.html#a671306f4a3a0cae5ab4d7a9d54886592">Glib::wrap()</a> method for this object. </p> <dl class="params"><dt>Parameters</dt><dd> <table class="params"> <tr><td class="paramname">object</td><td>The C instance. </td></tr> <tr><td class="paramname">take_copy</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> </dd> </dl> <dl class="section return"><dt>Returns</dt><dd>A C++ instance that wraps this C instance. </dd></dl> </div> </div> <hr/>The documentation for this class was generated from the following file:<ul> <li>libgdamm/sqlbuilder.h</li> </ul> </div><!-- contents --> <!-- start footer part --> <hr class="footer"/><address class="footer"><small> Generated on Wed Apr 24 2013 11:43:48 for libgdamm by  <a href="http://www.doxygen.org/index.html"> <img class="footer" src="doxygen.png" alt="doxygen"/> </a> 1.8.3.1 </small></address> </body> </html>