The DateSelect control can generate an SQL statement from the user
selection. This feature can be useful in creating ad-hoc queries where
a set of records have to be selected from a database table based on
a user selected date range.
To make proper use of the SQL feature, its important to understand
the SQL related properties of the cotnrol. All SQL related properties
start with 'SQL', so they are easy to distinguish. The following table
describes the purpose of the SQL related properties of the control.
|
Property |
Description |
| SQLFormat |
If the Database
server in use requires a specific date format to be used in the
SQL queries, the required format should be assigned to this property.
For example, mySQL requires date values to be formatted in 'yyyy-mm-dd'
format. |
|
SQLFieldName |
The name
of the field to be searched on. For example, if you are to search
based on a field named [Order Date], assign [Order Date] to this
Property. |
|
SQLDateWrapper |
Most cases,
the date value in the SQL statement must enclosed with a character.
MS Access requires '#', while SQL server would require a single
quote. Assign the appropriate character to this Property based on
the Database in use. |
|
SQLUseBETWEEN |
When the
selected option is a date range, the generated expression can
use the BETWEEN clause. In case the Database doesn't support BETWEEN
clause, set this property to False, and the control will generate
the Where clause using AND operator. |
|
SQLPrefix |
In case
the control is used to generate complete SQL statement, assign the
SQL statement to this property excluding the selection criteria.
For example, you may assign 'SELECT * FROM [ORDERS] WHERE' to this
property, and the control will create the rest of the statement
and append to it. |
Dateselect SQL related Properties
Once the properties are properly set, the control can generate a SQL
criteria or complete SQL Statement based on the user selection. The
SQL statement can be accessed using the SQL Method of the control, and
the criteria can be accessed using SQLCriteria method. Please see the
Domonstration project for an example of the SQL feature of the control.
