The DBSimpleQuery is used to perform stand-alone SQL statements. In the PHsPeed runtime, this component is used for audit trail, role-based access etc. It is used mostly in PHP events to perform all kinds of subtasks. It does not support a bidirectional cursor, but only a sequential cursor. The component binds directly to the database, not to a data source.


Properties

Description

dbconnection

Reference to the database connection component.

query

Propety editor to a visual query dialog. It will maintain the definition for future changes, and supports the sql property when requested. Also handy for users that are not that experienced in writing SQL.

sql

SQL statement (Don't use, if you have used query property)


PHP Events

Description

onBeforeExecute

Triggers just before the SQL is executed

OnAfterExecute

Triggers just after the SQL is executed

JavaScript Events

No additional events.