<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <HTML ><HEAD ><TITLE >hk_database</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.7"><LINK REL="HOME" TITLE="The knoda scripting tutorial" HREF="index.html"><LINK REL="UP" TITLE="using hk_classes as a Python module" HREF="chapter4.html"><LINK REL="PREVIOUS" TITLE="hk_connection" HREF="hk_connection.html"><LINK REL="NEXT" TITLE="Tips and tricks" HREF="chapter5.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="SECTION" 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 knoda scripting tutorial</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="hk_connection.html" ACCESSKEY="P" >Prev</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" >Chapter 4. using hk_classes as a Python module</TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="chapter5.html" ACCESSKEY="N" >Next</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><DIV CLASS="SECTION" ><H1 CLASS="SECTION" ><A NAME="HK_DATABASE" ></A >4.3. hk_database</H1 ><P >hk_database represents a particular database on the SQL Server <A NAME="AEN404" ></A ><BLOCKQUOTE CLASS="BLOCKQUOTE" ><UL ><LI STYLE="list-style-type: disc" ><P > vector<hk_string>* tablelist(void): returns a list of all existing tables in this database</P ></LI ><LI STYLE="list-style-type: disc" ><P >vector<hk_string>* querylist(void): returns a list of all existing queries in this database</P ></LI ><LI STYLE="list-style-type: disc" ><P >vector<hk_string>* formlist(void): returns a list of all existing forms in this database</P ></LI ><LI STYLE="list-style-type: disc" ><P >vector<hk_string>* reportlist(void): returns a list of all existing reports in this database</P ></LI ><LI STYLE="list-style-type: disc" ><P >hk_datasource* new_table(const hk_string& name="",hk_presentation* p=NULL): gets a new table object of type hk_datasource (read and write)</P ></LI ><LI STYLE="list-style-type: disc" ><P >hk_datasource* new_resultquery(hk_presentation* p=NULL): gets a new query object of type hk_datasource (readonly)</P ></LI ><LI STYLE="list-style-type: disc" ><P >hk_actionquery* new_actionquery(void): gets a hk_actionquery object. It can execute SQL statements that don't return data and are only successful or not successful (e.g. CREATE TABLE)</P ></LI ><LI STYLE="list-style-type: disc" ><P >hk_datasource* load_datasource(const hk_string& name,bool query=false,hk_presentation* p=NULL): a convenience function for new_table and new_resultquery, that loads an existing datasource</P ></LI ><LI STYLE="list-style-type: disc" ><P >bool delete_table(const hk_string& table,enum_interaction x=interactive): deletes a table</P ></LI ><LI STYLE="list-style-type: disc" ><P >bool table_exists(const hk_string& tablename): returns true if the table 'tablename' exists</P ></LI ><LI STYLE="list-style-type: disc" ><P >bool query_exists(const hk_string& queryname): returns true if the query 'queryname' exists</P ></LI ></UL ></BLOCKQUOTE > </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="hk_connection.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="chapter5.html" ACCESSKEY="N" >Next</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >hk_connection</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="chapter4.html" ACCESSKEY="U" >Up</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >Tips and tricks</TD ></TR ></TABLE ></DIV ></BODY ></HTML >