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.