Tersus: New in Version 1.1.3 - Table Wizard [beta version]

New in Version 1.1.3 - Table Wizard [beta version]Date: Jul 25, 2008Table Wizard lets you create a pane with a table that corresponds to a database table or view.The current beta version supports just basic table management at this stage:

Adding a table with any number of fields:

Supported field types: Text, Number, Date, Date and Time, Boolean
Support for primary key fields (including a numeric or time-stamp auto-generated primary key)

Table implementation includes:

Automatic creation of the underlying database table
Table display on screen
Basic data management capabilities ('New', 'Update' and 'Delete')

Updating a table pane previously created by the wizard:

Renaming the table
Renaming and/or changing the type of any field
Adding and deleting fields

Eventually, Table Wizard will replace both modules 'Table Display and Management' and 'Advanced Table Display and Management', including:

Validations (prevent duplicate field names; allow an auto-generated primary key only if the sole primary key; make database table name read-only)

Sorting and filtering by any field(s)

Paging (useful when the underlying database table includes many records)

Starting from an existing database table/view (including the ability to create several views of the same database table/view)

Support for choosers (fields whose values are restricted to a closed set of values or values appearing in some field in a database table/view)

Support for image fields (e.g. icons)

Support for memo fields ('Text Area')

Support for hierarchical data structures

Automatic management of timestamp fields (<Creation Date>, <Creation Time>, <Last Update Date>, <Last Update Time>) and user identification fields (<Creating User>, <Last Updating User>)