<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >Get in contact with a table</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="The hk_classes programmer's tutorial" HREF="index.html"><LINK REL="PREVIOUS" TITLE="Get in contact with your SQL Server" HREF="chapter1.html"><LINK REL="NEXT" TITLE="Preselect the driver and user information" HREF="chapter3.html"><META HTTP-EQUIV="Content-Style-Type" CONTENT="text/css"><LINK REL="stylesheet" HREF="common/kde-common.css" TYPE="text/css"><META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1"><META HTTP-EQUIV="Content-Language" CONTENT="en"><LINK REL="stylesheet" HREF="common/kde-localised.css" TYPE="text/css" TITLE="KDE-English"><LINK REL="stylesheet" HREF="common/kde-default.css" TYPE="text/css" TITLE="KDE-Default"></HEAD ><BODY CLASS="CHAPTER" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#AA0000" VLINK="#AA0055" ALINK="#AA0000" STYLE="font-family: sans-serif;" ><DIV CLASS="logoheader" ><A HREF="http://www.kde.org/" ></A ></DIV ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >The hk_classes programmer's tutorial</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="chapter1.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="chapter3.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="CHAPTER" ><H1 ><A NAME="CHAPTER2" ></A >Chapter 2. Get in contact with a table</H1 ><P > Below you see the program of chapter 1 with some additional commands. A hk_database object represents a database, the name of the database can be set either with the constructor or with "set_name(const string&)".</P ><P > A table or a query is be represented by a hk_datasource object (a query with a "SELECT statement is called in hk_classes a resultquery and can be created with hk_datasource* mydatasource=mydatabase->new_resultquery(); ).</P ><P > Before you can see the data of a datasource you have to enable it (then the SQL-statement will be executed). The last command ("dump_data()") is just added so that you can see the data, please don't use it in your code.</P ><P > <DIV CLASS="EXAMPLE" ><HR><A NAME="AEN42" ></A ><P ><B >Example 2-1. Get in contact with a table</B ></P ><TABLE BORDER="0" BGCOLOR="#E0E0E0" WIDTH="100%" ><TR ><TD ><PRE CLASS="PROGRAMLISTING" > 1 2 #include <hk_classes.h> 3 #include <iostream> 4 int main() 5 { 6 hk_drivermanager* mydrivermanager = new hk_drivermanager(); 7 if (mydrivermanager==NULL) {cout <<"error creating mydrivermanager"<<endl;exit(1);} 8 hk_connection* myconnection = mydrivermanager->new_connection(); 9 if (myconnection==NULL) {cout <<"error creating myconnection"<<endl;exit(1);} 10 myconnection->connect(); 11 12 <FONT COLOR="RED" >hk_database* mydatabase=myconnection->new_database("exampledb");</FONT > 13 <FONT COLOR="RED" >if (mydatabase==NULL) {cout <<"error creating mydatabase"<<endl;exit(1);}</FONT > 14 <FONT COLOR="RED" >hk_datasource* mydatasource= mydatabase->new_table("authors");</FONT > 15 <FONT COLOR="RED" >if (mydatasource==NULL) {cout <<"error creating mydatasource"<<endl;exit(1);}</FONT > 16 <FONT COLOR="RED" >mydatasource->enable();</FONT > 17 <FONT COLOR="RED" >//the following internal debugging command should not be used. It is used here for</FONT > 18 <FONT COLOR="RED" >//demonstration purposes only!!!! </FONT > 19 <FONT COLOR="RED" >mydatasource->dump_data(); // DON'T USE THIS COMMAND IN YOUR PROGRAMMS!!!</FONT > 20 21 delete mydrivermanager; 22 }</PRE ></TD ></TR ></TABLE ><HR></DIV ></P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="chapter1.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >Home</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="chapter3.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >Get in contact with your SQL Server</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" > </TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Preselect the driver and user information</TD ></TR ></TABLE ></DIV ></BODY ></HTML >