Click here to Skip to main content
Click here to Skip to main content
Articles » Database » Database » General » Downloads
 
Add your own
alternative version

DarkSide SQL Mini Version 1, The embedded database

, 23 Mar 2006
An embedded database library in C++.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><!-- InstanceBegin template="/Templates/main.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<!-- InstanceBeginEditable name="doctitle" -->
<title>ResultSet</title>
<!-- InstanceEndEditable -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<!-- InstanceBeginEditable name="head" --> 
<link href="ss.css" rel="stylesheet" type="text/css">
<!-- InstanceEndEditable --> 
</head>

<body bgcolor="#FFFFFF" text="#666666">
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
  <tr> 
    <td bgcolor="#CCCCCC"><h3><font color="#999999">DarkSide SQL Mini Help</font></h3></td>
  </tr>
</table>
<table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
  <!--DWLayoutTable-->
  <tr> 
    <td width="164" height="305" valign="top"><table width="100%" border="1" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC">
        <tr> 
          <td><a href="index.htm">Home</a></td>
        </tr>
        <tr> 
          <td><a href="intro.htm">Introduction</a></td>
        </tr>
        <tr> 
          <td><a href="using.htm">Using The Library</a></td>
        </tr>
        <tr> 
          <td><a href="api_ref.htm">API Reference</a></td>
        </tr>
        <tr> 
          <td><strong>SQL Commands</strong></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_ct.htm">CREATE TABLE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_dd.htm">DROP DATABASE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_dt.htm">DROP TABLE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_use.htm">USE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_i.htm">INSERT</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_u.htm">UPDATE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_d.htm">DELETE</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_s.htm">SELECT</a></div></td>
        </tr>
        <tr> 
          <td><div align="center"><a href="sql_o.htm">OPTIMIZE</a></div></td>
        </tr>
        <tr> 
          <td><a href="types.htm">Data Types</a></td>
        </tr>
        <tr> 
          <td><a href="oprs.htm">Operators</a></td>
        </tr>
        <tr>
          <td><a href="bugs.htm">Bugs</a></td>
        </tr>
        <tr> 
          <td><a href="lic.htm">License</a></td>
        </tr>
        <tr> 
          <td><a href="tps.htm">Third-party software</a></td>
        </tr>
        <tr> 
          <td><a href="abt.htm">About</a></td>
        </tr>
      </table></td>
    <!-- InstanceBeginEditable name="txt" -->
    <td width="398" valign="top"><p><strong>ResultSet</strong></p>
      <p><font color="#990000">bool next()</font>: Moves cursor to the next record.<br>
        <br>
        <font color="#990000">bool prev():</font> Moves back cursor to the previous 
        record. <br>
        <br>
        <font color="#990000">bool first(): </font>Moves cursor to the first record.<br>
        <br>
        <font color="#990000">bool last():</font> Moves cursor to the last record.<br>
        <font color="#990000"><br>
        string getString(int col_num):</font> Returns the data of column at &quot;col_num&quot; 
        of the ResultSet as a string.<br>
        <br>
        <font color="#990000">string getString(const char* col_name):</font>Returns 
        the data of column named &quot;col_name&quot; as a string.<br>
        <br>
        <font color="#990000">int getInt(int col_num)</font>: Returns the data 
        of column at &quot;col_num&quot; of the ResultSet as an int<br>
        <br>
        <font color="#990000">int getInt(const char* col_name):<font color="#666666">Returns 
        the data of column named &quot;col_name&quot; as an int.<br>
        </font><br>
        float getFloat(int col_num): <font color="#666666">Returns the data of 
        column at &quot;col_num&quot; of the ResultSet as an float</font><br>
        <br>
        float getFloat(const char* col_name): <font color="#666666">Returns the 
        data of column named &quot;col_name&quot; as a float.</font><br>
        <br>
        double getDouble(int col_num): <font color="#666666">Returns the data 
        of column at &quot;col_num&quot; of the ResultSet as a double</font><br>
        <br>
        double getDouble(const char* col_name): <font color="#666666">Returns 
        the data of column </font><font color="#990000"><font color="#666666">named 
        &quot;col_name&quot; </font></font><font color="#666666"> as a double</font><br>
        <br>
        long getLong(int col_num): <font color="#666666">Returns the data of column 
        at &quot;col_num&quot; of the ResultSet as a long</font><br>
        <br>
        long getLong(const char* col_name): <font color="#666666">Returns the 
        data of column named &quot;col_name&quot; as a long</font><br>
        <br>
        <a href="date.htm">openutils::MyDate</a> getDate(int col_num): <font color="#666666">Returns 
        the data of column at &quot;col_num&quot; of the ResultSet as a &quot;MyDate&quot; 
        object </font><br>
        <br>
        <a href="date.htm">openutils::MyDate</a> getDate(const char* col_name): 
        <font color="#666666">Returns the data of column named &quot;col_name&quot; 
        as a &quot;MyDate&quot;</font><br>
        <br>
        bool getBool(int col_num): <font color="#666666">Returns the data of column 
        at &quot;col_num&quot; of the ResultSet as a bool</font><br>
        <br>
        bool getBool(const char* col_name): <font color="#666666">Returns the 
        data of column named &quot;col_name&quot; as a bool</font><br>
        <br>
        int getColumnCount(): <font color="#666666">Returns the number of columns 
        in the ResultSet.</font></font></p>
      <p><font color="#990000"> void operator = (ResultSet rslt): <font color="#666666">Assigns 
        the ResultSet in the argument to the calling ResultSet</font></font></p></td>
    <!-- InstanceEndEditable --></tr>
  <tr> 
    <td height="58" colspan="2" valign="top"><div align="center">&copy; 2003 <a href="mailto:vijaymathewp@yahoo.co.in">LogicMatrix</a></div></td>
  </tr>
</table>
</body>
<!-- InstanceEnd --></html>

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The BSD License

About the Author

No Biography provided

| Advertise | Privacy | Mobile
Web04 | 2.8.140721.1 | Last Updated 23 Mar 2006
Article Copyright 2003 by AnOldGreenHorn
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid