This class is a data source driver for the PEAR::DB_Table object
SUPPORTED OPTIONS:
view: (string) The view from $sql array in your DB_Table object. This
option is required.
where: (string) A where clause for the SQL query.
params: (array) Placeholder parameters for prepare/execute
GENERAL NOTES:
If you use aliases in the select part of your view, the count() method from DB_Table and, therefore, $datagrid->getRecordCount() might return a wrong result. To avoid this, DB_Table uses a special query for counting if it is given via a view that needs to be named as '__count_' followed by the name of the view that this counting view belongs to. (For example: if you have a view named 'all', the counting view needs to be named as '__count_all'.)
To use update() and delete() methods, it is required that the indexes are properly defined in the $idx array in your DB_Table subclass. If you have, for example, created your database table yourself and did not setup the $idx array, you can use the 'primaryKey' option to define the primary key field.