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