CodeCharge Studio
DataSource->Where Run-Time Property (PHP)
Applies to
DataSource Object
Type
string
Access
read/write
Syntax
object->DataSource->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
DataSource Property
DataSource->SQL Property
DataSource->CountSQL Property
DataSource->Order Property
On-line, printable versions and updates