📄 group__easy.html
字号:
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html;charset=iso-8859-1"><title>libsqlora8: The easy interface</title><link href="doxygen.css" rel="stylesheet" type="text/css"></head><body><!-- Generated by Doxygen 1.3.6 --><div class="qindex"><a class="qindex" href="index.html">Main Page</a> | <a class="qindex" href="modules.html">Modules</a> | <a class="qindex" href="annotated.html">Data Structures</a> | <a class="qindex" href="files.html">File List</a> | <a class="qindex" href="functions.html">Data Fields</a> | <a class="qindex" href="globals.html">Globals</a> | <a class="qindex" href="pages.html">Related Pages</a> | <a class="qindex" href="examples.html">Examples</a></div><h1>The easy interface</h1>Functions in this group use basically bind variables passed as strings in an argv. <a href="#_details">More...</a><table border=0 cellpadding=0 cellspacing=0><tr><td></td></tr><tr><td colspan=2><br><h2>Functions</h2></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga0">sqlo_exists</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Tests if a value exists in a table. <a href="#ga0"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga1">sqlo_count</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *table, const char *colname, const char *colval, const char *where)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Counts the number of items in the table. <a href="#ga1"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga2">sqlo_run</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Run a simple sql statements with parameters. <a href="#ga2"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top><a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga3">sqlo_open</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Open a new cursor. <a href="#ga3"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga4">sqlo_open2</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> *sthp, <a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Open a new cursor. <a href="#ga4"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga5">sqlo_reopen</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int argc, const char **argv)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Reopens a already used cursor. <a href="#ga5"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga6">sqlo_fetch</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, unsigned int nrows)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Fetches the data from an open cursor. <a href="#ga6"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char ** </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga7">sqlo_values</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num, int dostrip)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get one dataset. <a href="#ga7"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const unsigned short * </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga8">sqlo_value_lens</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the length of the returned values. <a href="#ga8"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char ** </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga9">sqlo_ocol_names</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the select list columns. <a href="#ga9"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga10">sqlo_ocol_names2</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num, const char ***ocol_names)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the select list columns. <a href="#ga10"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const int * </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga11">sqlo_ocol_name_lens</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int *num)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the select list columns name lengths. <a href="#ga11"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga12">sqlo_ncols</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth, int in)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Get the number of bind/select-list variables. <a href="#ga12"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>const char * </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga13">sqlo_command</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the sql command. <a href="#ga13"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga14">sqlo_close</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Close the cursor. <a href="#ga14"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga15">sqlo_exec</a> (<a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> dbh, const char *stmt)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Execute a simple sql statement. <a href="#ga15"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga16">sqlo_isopen</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Test if a cursor is open. <a href="#ga16"></a><br><br></td></tr><tr><td class="memItemLeft" nowrap align=right valign=top>int </td><td class="memItemRight" valign=bottom><a class="el" href="group__easy.html#ga17">sqlo_prows</a> (<a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> sth)</td></tr><tr><td class="mdescLeft"> </td><td class="mdescRight">Return the number of processed rows by this statement. <a href="#ga17"></a><br><br></td></tr></table><hr><a name="_details"></a><h2>Detailed Description</h2>Functions in this group use basically bind variables passed as strings in an argv. <p>The query results are also converted to strings. <hr><h2>Function Documentation</h2><a class="anchor" name="ga14" doxytag="sqlora.h::sqlo_close" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top"> int sqlo_close </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> </td> <td class="mdname1" valign="top" nowrap> <em>sth</em> </td> <td class="md" valign="top"> ) </td> <td class="md" nowrap></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Close the cursor. <p>Closes the cursor and releases the Oracle statement handle.<p><dl compact><dt><b>Returns:</b></dt><dd><ul><li>SQLO_SUCCESS </li><li>< 0 on error </li></ul></dd></dl><dl compact><dt><b>See also:</b></dt><dd><a class="el" href="group__easy.html#ga3">sqlo_open</a>. </dd></dl><p>Definition at line <a class="el" href="sqlora_8c-source.html#l05656">5656</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.<p>References <a class="el" href="sqlora_8c-source.html#l01830">_bindpv_reset()</a>, <a class="el" href="sqlora_8c-source.html#l01496">_get_stmt_string()</a>, <a class="el" href="sqlora_8c-source.html#l04319">_get_trace_fp()</a>, <a class="el" href="sqlora_8c-source.html#l02805">_is_opened()</a>, <a class="el" href="sqlora_8c-source.html#l02785">_is_prepared()</a>, <a class="el" href="sqlora_8c.html#a48">_max_long_size</a>, <a class="el" href="sqlora_8c-source.html#l01740">_stmt_release()</a>, <a class="el" href="sqlora_8c-source.html#l00416">CHECK_OCI_STATUS_RETURN</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="sqlora_8c-source.html#l00565">_sqlo_stmt_struct::dbp</a>, <a class="el" href="sqlora_8c-source.html#l00588">_sqlo_stmt_struct::defnpv</a>, <a class="el" href="sqlora_8c-source.html#l00590">_sqlo_stmt_struct::num_defnpv</a>, <a class="el" href="sqlora_8c-source.html#l00597">_sqlo_stmt_struct::outv</a>, <a class="el" href="sqlora_8c-source.html#l00601">_sqlo_stmt_struct::outv_size</a>, <a class="el" href="sqlora_8c.html#a30">sqlo_db_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga4a36">SQLO_INVALID_STMT_HANDLE</a>, <a class="el" href="sqlora_8h-source.html#l00318">sqlo_stmt_handle_t</a>, <a class="el" href="sqlora_8c.html#a35">sqlo_stmt_struct_ptr_t</a>, <a class="el" href="group__constants.html#gga3a25">SQLO_SUCCESS</a>, <a class="el" href="sqlora_8c-source.html#l00493">_sqlo_db_struct::status</a>, <a class="el" href="sqlora_8c-source.html#l00562">_sqlo_stmt_struct::sth</a>, <a class="el" href="sqlora_8c-source.html#l00567">_sqlo_stmt_struct::stmthp</a>, and <a class="el" href="sqlora_8c-source.html#l00238">TRACE</a>.<p>Referenced by <a class="el" href="sqlora_8c-source.html#l04231">_close_all_db_cursors()</a>, <a class="el" href="sqlora_8c-source.html#l04207">_close_all_executing_cursors()</a>, <a class="el" href="sqlora_8c-source.html#l04464">_sqlo_reopen()</a>, <a class="el" href="sqlora_8c-source.html#l04902">sqlo_count()</a>, <a class="el" href="sqlora_8c-source.html#l04822">sqlo_exists()</a>, <a class="el" href="sqlora_8c-source.html#l05152">sqlo_open()</a>, <a class="el" href="sqlora_8c-source.html#l05238">sqlo_open2()</a>, and <a class="el" href="sqlora_8c-source.html#l04991">sqlo_run()</a>. </td> </tr></table><p>Here is the call graph for this function:<p><center><img src="group__easy_ga14_cgraph.png" border="0" usemap="#group__easy_ga14_cgraph_map" alt=""></center><map name="group__easy_ga14_cgraph_map"><area href="sqlora_8c.html#a104" shape="rect" coords="145,5,244,24" alt=""><area href="sqlora_8c.html#a120" shape="rect" coords="140,48,249,67" alt=""><area href="sqlora_8c.html#a128" shape="rect" coords="147,91,243,109" alt=""><area href="sqlora_8c.html#a110" shape="rect" coords="153,133,236,152" alt=""><area href="sqlora_8c.html#a109" shape="rect" coords="148,176,241,195" alt=""><area href="sqlora_8c.html#a103" shape="rect" coords="147,219,243,237" alt=""></map><a class="anchor" name="ga13" doxytag="sqlora.h::sqlo_command" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top"> const char* sqlo_command </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga1">sqlo_stmt_handle_t</a> </td> <td class="mdname1" valign="top" nowrap> <em>sth</em> </td> <td class="md" valign="top"> ) </td> <td class="md" nowrap></td> </tr> </table> </td> </tr></table><table cellspacing=5 cellpadding=0 border=0> <tr> <td> </td> <td><p>Return the sql command. <p><dl compact><dt><b>Returns:</b></dt><dd>The active sql statement of the sth.</dd></dl><dl compact><dt><b>Parameters:</b></dt><dd> <table border="0" cellspacing="2" cellpadding="0"> <tr><td valign=top><em>sth</em> </td><td>I - A statement handle </td></tr> </table></dl><p>Definition at line <a class="el" href="sqlora_8c-source.html#l05641">5641</a> of file <a class="el" href="sqlora_8c-source.html">sqlora.c</a>.<p>References <a class="el" href="sqlora_8c-source.html#l01496">_get_stmt_string()</a>, <a class="el" href="sqlora_8c-source.html#l00367">CHECK_STHANDLE</a>, <a class="el" href="sqlora_8h-source.html#l00318">sqlo_stmt_handle_t</a>, and <a class="el" href="sqlora_8c.html#a35">sqlo_stmt_struct_ptr_t</a>. </td> </tr></table><p>Here is the call graph for this function:<p><center><img src="group__easy_ga13_cgraph.png" border="0" usemap="#group__easy_ga13_cgraph_map" alt=""></center><map name="group__easy_ga13_cgraph_map"><area href="sqlora_8c.html#a120" shape="rect" coords="169,5,279,23" alt=""></map><a class="anchor" name="ga1" doxytag="sqlora.h::sqlo_count" ></a><p><table class="mdTable" width="100%" cellpadding="2" cellspacing="0"> <tr> <td class="mdRow"> <table cellpadding="0" cellspacing="0" border="0"> <tr> <td class="md" nowrap valign="top"> int sqlo_count </td> <td class="md" valign="top">( </td> <td class="md" nowrap valign="top"><a class="el" href="group__typedefs.html#ga0">sqlo_db_handle_t</a> </td> <td class="mdname" nowrap> <em>dbh</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>const char * </td> <td class="mdname" nowrap> <em>table</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>const char * </td> <td class="mdname" nowrap> <em>colname</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>const char * </td> <td class="mdname" nowrap> <em>colval</em>, </td> </tr> <tr> <td class="md" nowrap align="right"></td> <td></td> <td class="md" nowrap>const char * </td> <td class="mdname" nowrap> <em>where</em></td> </tr> <tr> <td></td> <td class="md">) </td> <td class="md" colspan="2"></td> </tr>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -