• Product Information
  • About
  • News
  • Screenshots
• Support Information
  • Documentation
  • Resources
  • FAQ
  • Support
  • Feature matrix
• Download
• Purchase

SQLite PHP Generator online Help

Columns

For each datasource SQLite PHP Generator creates a bunch of presentations: the List presentation (data grid), the View presentation (on a record viewing), the Edit presentation (on a record editing), etc. The Columns tab of Page Editor allows you to adjust the presentations' appearance.

The General tab allows you to configure column properties for all the presentations. The properties for a concrete presentation can be specified at the corresponding tab.

Include/exclude columns to/from a concrete presentation (List, View, Edit, etc.) using corresponding boxes. Use Include into all presentations / Exclude from all presentations command from the tab's popup menu to get the column listed/unlisted on all generated pages.

To restore default column options, use the Reset column link from the tab's popup menu.

Specify the column caption and set a lookup editor for the column if necessary. By default, SQLite PHP Generator enables a lookup editor for columns linked by a foreign key with a single column from another table (if Setup lookups by foreign key option is enabled).

The View properties determine how the column is displayed on the List, View, Print and Export pages.

The Edit properties define how the column is represented on the Edit and Insert pages.

The Inline Edit, Inline Insert properties determine whether the column will be available for inline adding/editing and how it will be represented.

To reorder columns, use the grid's popup menu of a concrete presentation.