 |
| Price: 32,00 € |
Usd. 41,84
Currency conversion according with PayPal |
|
|
| |
|
| Form: |
Select the form contain the search fields. In case you use the 2 pages method, where you have one page with the search form and one page with the search result leave this field void (select the None value). In this case you must hand-write the form field names in the "Form Field 1" and in the "Form Field 2"
|
| |
|
| Recordset: |
The recordset in the page you want filter with the search form field value |
| |
|
| Boolean value: |
Define the boolean value for your database. This depend on the database you use. For MsAccess use -1/0 for SqlServer use 1/0. |
| |
|
| Jolly char: |
Define the jolly character value for the search with the LIKE operator for your database.
This depend on the database you use. For MsAccess and SqlServer use % |
| |
|
| Date char: |
Define the character your database use to enclode a date value
This depend on the database you use.
For MsAccess use # and for SqlServer use ' |
| |
|
| Filters list: |
The list of filter you want apply. In this list you must create one element for each database field where you want search.
|
| |
| Each item in the filters list has this parameters: |
| Recordset field: |
The database field where you want search in |
| |
|
| Fix operator: |
Define the operator you want use to search in the database field. Use this option when you want setup a fix operator. A fix operator is an operator your user cannot change from the search form you setup. In the exmple you can find in this pages we use the dynamic operator. All the search are case insensitive.
The available operator are:
- All the word (split the entered value with space)
- One of them (split the entered value with space)
- Exact value
- Less then
- Less or equal
- Greater then
- Greater or equal
- Not equal
- Between ( compare 2 fields value )
- Like
- In ( to use with a list of checkeboxes )
- Not In ( to use with a list of checkeboxes )
|
| |
|
| Form field operator: |
Define the operator you want use to search in the database field. Use this option when you want setup a dynamic operator. A dynamic operator is an operator your user can choose from the search form you setup. In this case in this combo you select or hand-write the name of the search form field that define the dynamic operator.
In the example you can find in this pages we use this option.
|
| |
|
| Form field 1: |
Define the form field where get the value to search in the database field |
| |
|
| Form field 2: |
Define the form field where get the value to search in the database field.
Setup this field only for BETWEEN operator. |
| |
|
| Db field type: |
Define the database field type.
The available type are STRING - NUMERIC - BOOLEAN - DATE
N.B. is not possible search in MEMO fields. |
| |
|
| Important feature: |
If you need search inside more that one field, like inside more categories, you can use a multi-select combo-box, like in the image belowe, and the extension will search inside all the selected value in your combo. |
|
|
