|
| 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
|
 |
|
|
|
|
|
|
|
|
|