Groups > dBase > dBase shared code > SQL_Locater.cc and sample forms




SQL_Locater.cc and sample forms

SQL_Locater.cc and sample forms
Wed, 20 Dec 2006 18:05:03 +010
Attached is an archive SQL_Locater.zip whic contains SQL_Locater.cc and some 
sample forms.
SQL_Locater.cc is a kind of seeker control that was put together by Marc VdB 
and me. It uses an SQL Where condition to search for strings in a character 
field. Unlike the classic seeker it does not locate a row in in an existing 
rowset, but recreates the rowset so that it will contain only matching rows.
These search options can be set using custom properties:
// --- Search options -------------------------------------------------//
   this.nSearchOptions = 1  // Default: Starts with
   // Array can be used on forms, see sample forms
   this.aSearchOptions = ;
        {'1 - Starts With', '2 - Ends With', '3 - Contains', '4 - Exact 
Length'}
 // Match case or ignore case?
   this.bMatchCase      = FALSE
   // Search after each keystroke?
   this.bIncremental  = TRUE
   // Count how many rows selected
   this.bCountRows  = TRUE
   // Minimum number of characters required before incremental search starts
   this.nCharsRequired = 1
The sample forms included use tables form the following databases
- dBASESAMPLES
- Firebird: EMPLOYEE
- MS SQL: AdventureWorks
Your feedback is welcome.
Roland
Post Reply
about | contact