Replaces the WHERE clause of the original SQL query with a new one.
Note: SQLQuery class methods are used in the After table initialized event.
Syntax
replaceWhere( condition )
Arguments
condition
any conditional clause. Example: "id_sizes < 3 or id_sizes > 6". id_sizes is the field name.
Return value
No return value.
Example 1
Display records from the table where the value of the test field is 'passed':
query.replaceWhere( "test = 'passed'" );
Example 2
Display records from where the value of the size field is 3 and the value of the adjust field is less than 2:
query.replaceWhere( "size = 3 and adjust < 2" );
Example 3
Display all table records:
query.replaceWhere( "" );
See also:
•Security: Additional WHERE tabs
