SQLQuery class allows you to modify the current SQL query stored in the query object. The query object is available only in the After table initialized event.
All the methods described below should be used in the After table initialized event. This ensures that the changes made are applied to all pages.
Methods
Method |
Description |
Adds a WHERE clause to the current SQL query. |
|
Replaces the WHERE clause of the current SQL query. |
|
Adds a field name to the end of the SELECT clause of the current SQL query. |
|
Removes a field name from the SELECT clause of the current SQL query. |
|
Replaces a field name in the SELECT clause of the current SQL query with a new one. |
See also: