classdbcursor.html

FastDb是高效的内存数据库系统

  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>number of selected records </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a23" doxytag="dbCursor::select" ></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 dbAnyCursor::select </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">char const *&nbsp;</td>
          <td class="mdname" nowrap> <em>condition</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>dbCursorType&nbsp;</td>
          <td class="mdname" nowrap> <em>aType</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>void *&nbsp;</td>
          <td class="mdname" nowrap> <em>paramStruct</em> = NULL</td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"><code> [inline, inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Execute query. <dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>condition</em>&nbsp;</td><td>selection criteria </td></tr>
    <tr><td valign=top><em>aType</em>&nbsp;</td><td>cursor type: <code>dbCursorForUpdate, dbCursorViewOnly</code> </td></tr>
    <tr><td valign=top><em>paramStruct</em>&nbsp;</td><td>pointer to structure with parameters. </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>number of selected records </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a22" doxytag="dbCursor::select" ></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 dbAnyCursor::select </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="classdbQuery.html">dbQuery</a> &amp;&nbsp;</td>
          <td class="mdname" nowrap> <em>query</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>void *&nbsp;</td>
          <td class="mdname" nowrap> <em>paramStruct</em> = NULL</td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"><code> [inline, inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Execute query with default cursor type. <dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>query</em>&nbsp;</td><td>selection criteria </td></tr>
    <tr><td valign=top><em>paramStruct</em>&nbsp;</td><td>pointer to structure with parameters. </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>number of selected records </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a21" doxytag="dbCursor::select" ></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 dbAnyCursor::select </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top"><a class="el" href="classdbQuery.html">dbQuery</a> &amp;&nbsp;</td>
          <td class="mdname" nowrap> <em>query</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>dbCursorType&nbsp;</td>
          <td class="mdname" nowrap> <em>aType</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>void *&nbsp;</td>
          <td class="mdname" nowrap> <em>paramStruct</em> = NULL</td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"><code> [inline, inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Execute query. <dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>query</em>&nbsp;</td><td>selection criteria </td></tr>
    <tr><td valign=top><em>aType</em>&nbsp;</td><td>cursor type: <code>dbCursorForUpdate, dbCursorViewOnly</code> </td></tr>
    <tr><td valign=top><em>paramStruct</em>&nbsp;</td><td>pointer to structure with parameters. If you want to create reentrant precompiled query, i.e. query which can be used concurrently by different threadsm you should avoid to use static variables in such query, and instead of it place paramters into some structure, specify in query relative offsets to the parameters, fill local structure and pass pointer to it to select method. </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>number of selected records </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a27" doxytag="dbCursor::selectByKey" ></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 dbAnyCursor::selectByKey </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">char const *&nbsp;</td>
          <td class="mdname" nowrap> <em>key</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>void const *&nbsp;</td>
          <td class="mdname" nowrap> <em>value</em></td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"><code> [inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Select all records from the table with specfied value of the key <dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>key</em>&nbsp;</td><td>name of the key field </td></tr>
    <tr><td valign=top><em>value</em>&nbsp;</td><td>searched value of the key </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>number of selected records </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a28" doxytag="dbCursor::selectByKeyRange" ></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 dbAnyCursor::selectByKeyRange </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">char const *&nbsp;</td>
          <td class="mdname" nowrap> <em>key</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>void const *&nbsp;</td>
          <td class="mdname" nowrap> <em>minValue</em>, </td>
        </tr>
        <tr>
          <td></td>
          <td></td>
          <td class="md" nowrap>void const *&nbsp;</td>
          <td class="mdname" nowrap> <em>maxValue</em></td>
        </tr>
        <tr>
          <td></td>
          <td class="md">)&nbsp;</td>
          <td class="md" colspan="2"><code> [inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Select all records from the table with specfied range of the key values <dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>key</em>&nbsp;</td><td>name of the key field </td></tr>
    <tr><td valign=top><em>minValue</em>&nbsp;</td><td>inclusive low bound for key values, if <code>NULL</code> then there is no low bound </td></tr>
    <tr><td valign=top><em>maxValue</em>&nbsp;</td><td>inclusive high bound for key values, if <code>NULL</code> then there is no high bound </td></tr>
  </table>
</dl>
<dl compact><dt><b>Returns:</b></dt><dd>number of selected records </dd></dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a34" doxytag="dbCursor::setPrefetchMode" ></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"> void dbAnyCursor::setPrefetchMode </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">bool&nbsp;</td>
          <td class="mdname1" valign="top" nowrap> <em>mode</em>          </td>
          <td class="md" valign="top">&nbsp;)&nbsp;</td>
          <td class="md" nowrap><code> [inline, inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Set prefetch mode. By default, current record is fetch as soon as it is becomes current. But sometimesyou need only OIDs of selected records. In this case setting prefetchMode to false can help. <dl compact><dt><b>Parameters:</b></dt><dd>
  <table border="0" cellspacing="2" cellpadding="0">
    <tr><td valign=top><em>mode</em>&nbsp;</td><td>if <code>false</code> then current record is not fetched. You should explicitly call <code>fetch</code> method if you want to fetch it. </td></tr>
  </table>
</dl>
    </td>
  </tr>
</table>
<a class="anchor" name="dbCursor_3_01Sequencer_01_4a44" doxytag="dbCursor::setRecord" ></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"> void dbAnyCursor::setRecord </td>
          <td class="md" valign="top">(&nbsp;</td>
          <td class="md" nowrap valign="top">void *&nbsp;</td>
          <td class="mdname1" valign="top" nowrap> <em>rec</em>          </td>
          <td class="md" valign="top">&nbsp;)&nbsp;</td>
          <td class="md" nowrap><code> [inline, inherited]</code></td>
        </tr>

      </table>
    </td>
  </tr>
</table>
<table cellspacing=5 cellpadding=0 border=0>
  <tr>
    <td>
      &nbsp;
    </td>
    <td>

<p>
Set destination for selected record rec - buffer to which fields of current record will be fetched     </td>
  </tr>
</table>
<a class="anchor" name=