Chapter 8. Searching a column

The method unsigned int hk_column::find (const string& searchtext) searchs in a column whether there is a dataset which contains the needed value. There are different types of this method. See the documentation of hk_column for further details.

It returns the row number if it has found a row with the searchtext, otherwise max rows +1.


Example 8-1. Searching a column

   1 #include <hk_classes.h>
   2 #include <iostream>
   3 int main()
   4 {
   5    hk_drivermanager* mydrivermanager = new hk_drivermanager();
   6    if (mydrivermanager==NULL) {cout <<"error creating mydrivermanager"<<endl;exit(1);}
   7    hk_connection* myconnection = mydrivermanager->new_connection("mysql");
   8    if (myconnection==NULL) {cout <<"error creating myconnection"<<endl;exit(1);}
   9    myconnection->set_host("localhost");
  10    myconnection->set_user("root");
  11    myconnection->set_password("mypasswd");
  12    myconnection->connect();
  13 
  14    hk_database* mydatabase=myconnection->new_database("exampledb");
  15    if (mydatabase==NULL) {cout <<"error creating mydatabase"<<endl;exit(1);}
  16    hk_datasource* mydatasource= mydatabase->new_table("authors");
  17    if (mydatasource==NULL) {cout <<"error creating mydatasource"<<endl;exit(1);}
  18    mydatasource->enable();
  19 
  20    hk_column* mycolumn = mydatasource->column_by_name("name");
  21    if (mycolumn==NULL) {cout <<"error getting column"<<endl;exit(1);}
  22 
  23    unsigned int result=mycolumn->find("searchtext");
  24 
  25    delete mydrivermanager;
  26 }