Active Record Scaffold Views

Active Record classes can be used together with and ( links both TScaffoldListView and TScaffoldEditView) to create simple Create/Read/Update/Delete (CRUD) web applications.

The scaffold views are intended to assist in prototyping web application, they are not designed to be as customiziable as more complex components such as TDataGrid. The scaffold views provide the following builtin functionality:

• Listing of all active record items.
• Paging and sorting.
• Deleting an item.
• Inserting a new item.
• Updating an existing item.
• Validates required fields and basic data types.
• Presents specialized controls such as date pickers.

Scaffold views are dependent on Active Records and currently supports the following databases: Mysql, Sqlite and Postgres SQL. Support for other databases can be considered when there are sufficient demand.

Setting up a Scaffold View

To use the scaffold view, we first define an Active Record class that represents a table or view in the database. Consider the following Active Record class that corresponds to the users table as defined in the Active Record quickstart page.

The scaffold view classes are in the System.Data.ActiveRecord.Scaffold.* namespace. This namespace can be "imported" in the Application Configuration using the application.xml file or through the php code using the Prado::using() method. The simplest way to provide CRUD functional is to use the where the RecordClass property value equals to an Active Record class name.

Todo...

Other views... list view

edit view...

Combining list + edit views

custom list view...

To be completed...

Address book example...