Filter
Top Products
Using Quick Select
120 DataWindow .NET
The SELECT statement that DataWindow Designer creates is:
SELECT emp_id, dept_id, salary
FROM employee
WHERE (emp_id >= 500 AND emp_id <= 1000)
AND (salary >= 30000 AND salary <= 50000)
Example 7
In a grid with three columns: Emp Last Name, Emp First Name, and Salary, the
expressions
LIKE C% in the Criteria row and LIKE G% in the Or row in the Emp
Last Name
column retrieve information for employees who have last names
that begin with C or G.
The
SELECT statement that DataWindow Designer creates is:
SELECT emp_last_name, emp_first_name, salary
FROM employee
WHERE emp_last_name LIKE 'C%'
OR emp_last_name LIKE 'G%'
Providing SQL
functionality to users
You can allow your users to specify selection criteria in a DataWindow object
using these techniques at runtime:
• You can automatically pop up a window prompting users to specify
criteria each time, just before data is retrieved.
For more information, see Chapter 5, “Enhancing DataWindow Objects.”
• You can place the DataWindow object in query mode using the Modify
method.
For more information, see the DataWindow Programmer’s Guide.