CodeCharge Studio
ds->Where Run-Time Property (PHP)
Applies to
DataSource Object
Type
string
Access
read/write
Syntax
object->ds->Where [=value]
Description
This property stores all conditions that are eventually used in the WHERE clause of a query that selects, updates or deletes data from the database.
Programmers can add their own conditions (preserving the SQL syntax) in one of the events triggered before the final query is built and executed (i.e. BeforeBuildSelect, BeforeBuildDelete, BeforeBuildUpdate).
Examples
Dynamically Modify the WHERE and ORDER BY Clauses of a ListBox,
Dynamically Modify the ORDER BY Clause,
Dynamically Modify the SQL Statement,
Retrieve Values From a Multi-Select ListBox,
Dynamically Modify the WHERE Clause
See Also
ds Property
ds->SQL Property
ds->CountSQL Property
ds->Order Property
On-line, printable versions and updates