CPDB.Net

https://cpdb.ppcompiler.org/

6- Sort and search operations (CPDB library)

Introduction

With CPDB, it's very simple to search on any field of the database. Search a string value on a 7000 records database take less than 4 seconds* !

* test done with a Zip code database on a Palm IIIxe device : search of the last record

The first method consist with a generic search, a string value is used. You must convert to a string if the value is a numeric value.

Use the following example :

Err err;
Boolean bFound;



err = CPDB_Search(mydbHandle, "FIELDNAME", "1234", CPDB_SEARCH_FROMCURRENT);
err = CPDB_IsFound(mydbHandle, &bFound);

The bFound boolean contain true if the search succed.

Please note the CPDB_SEARCH_FROMCURRENT parameter. You can also use :

•  CPDB_SEARCH_REVERSE
  
•  CPDB_SEARCH_FROMCURRENT
  
•  CPDB_SEARCH_WITHIN
  
•  CPDB_SEARCH_CASELESS

This permit to search all the records with a specific value. Just use CPDB_SEARCH_FROMBEGIN for the first search operation then loop on CPDB_SEARCH_FORMCURRENT to search the next record. This is an exemple :

Err err;
Boolean bFound;



err = CPDB_Search(mydbHandle, "FIELDNAME", "1234", 0);
err = CPDB_IsFound(mydbHandle, &bFound);


while ( bFound == true && err == 0 )
{
  // your code here
  // ...
  // Next record
  err = CPDB_Search(mydbHandle, "FIELDNAME", "1234", CPDB_SEARCH_FROMCURRENT);
  if (err == 0) err = CPDB_IsFound(mydbHandle, &bFound);
}