triadis engineering GmbH - DB Form Template

TrDBFormTemplate
Version 1.0

Features
Download
Register
Future

TrDbFormTemplate is a very powerful Form-Template specifically designed to give professional CS database frontend developers unmatched power in their Delphi frontend applications.

Demoapplication as a frontend for Delphi's MastApp database.

TrDBFormTemplate use RxLib components.


Features:

Top

Form and Table View

TrDbFormTemplate shows data in two different ways.

  • Form-View
  • Table-View

Features

  • Select view by speed button , hot key F6, double click into form or grid, or automatic after applying record filter.
  • Remembers form size an position.
  • Different form size in Form- and Table-View.
  • Switch view mode even if forms dataset is in edit or insert mode.

Auto SQL Update support

TrDbFormTemplate supports automatic Delphis SQL-Update component.

Features

  • Using triadis TrQuery component and SQL Update component are automatic supported.
  • Using Cached-Update and any query (joins, like's, order by etc) will be updateable.
  • No additional code required if you set TrQuery's property qfAutoCachedUpdate to True.

Filter Dialog

TrDbFormTemplate uses a Filter-Dialog to reduce the number of records in form's dataset. Filtering sets a WHERE clause in the SELECT statement of the query object and requery the dataset. This procedure results in small dataset and minimum net load between server and client. Filtering does NOT use Delphi's TTable or TQuery filter property!

The Filter-Dialog is designed by the programmer and is depending of the application. The Filter-Dialog should only support the most important filter and search criteria. It should be a very easy way to filter data.

Features

  • Supports all filter and search requirements for the common user.
  • Full keyboard support, even if you use combo boxes (TrDBLookupComboBox has proper behavior in modal dialogs).
  • Actions after filter is applied, see Behavior After Apply a Filter Expression:
  • Button to open Filter-Script-Dialog.
  • Check box to select automatic clearing filter fields after applying a filter.

Filter Script

TrDbFormTemplate uses a Filter-Script-Dialog to reduce the number of records in form's dataset. Filtering sets a WHERE clause in the SELECT statement of the query object and requerys the dataset. This procedure results in small dataset and minimum net load between server and client. Filtering does NOT use Delphis TTable or TQuery filter property!

The Filter Script Dialog gives power users full access to the WHERE and ORDER BY clause. But, programmer can set the base WHERE expressions which always applies.

Features

  • Supports all filter and search requirements for the power user.
  • Key in raw SQL WHERE and ORDER BY clause.
  • Drag and drop field names from field list.
  • Actions after filter is apply, see Behavior After Apply a Filter Expression:

Filter Manager

TrDbFormTemplate uses a Filter-Manager to store and recall filter expressions.

Any filter expressions generated by Filter-Dialog or Filter-Script-Dialog can by stored in the filter database.

User can recall these stored filters from the filter select combo box.

Features

  • Give filter expressions a name and store it in the filter database.
  • Filters can be visible for all users or only for the filter owner.
  • Store filter expressions under a new name.
  • Delete filter database entries.

Record navigator

TrDbFormTemplate uses speed buttons for user record navigation.

Features

  • Direct EOF and TOF feedback.
  • Correct EOF and TOF user feedback. Prior and first button are disabled if current record is the first record, unless Delphis TDBNaviagtor disables speed buttons if you try to move from the first record backward (prior or first). Same behavior for the next and last button.
  • Works in CS- and Desktop-Applications.

Record number feedback

TrDbFormTemplate displays current record position and number of records in dataset to the user..

Features

  • Feedback current scroll position in dataset.
  • Feedback number of records in dataset.
  • Works in CS- and Desktop-Applications.

Restors Forms position and size

TrDbFormTemplate stores form position and size in users registry section.

Features

  • Form position and size restoring.
  • Each user has own settings.
  • Different form size for form view mode and table view mode..

Jump from Form to Form

TrDbFormTemplate user can jump (switch) from one form to another using Ctrl+Tab key.

Features

  • Very fast form switching with Ctrl+Tab.
  • Use form select list to switch to another form.

Jump within Form sections

TrDbFormTemplate user can move focus from one form section to another.

Focus control in Delphi is insufficient, you are unable to move focus away from a grid or a DBCtrlGrid without using the mouse.

TrDbFormTemplate allow to move focus from panel, grid or ctrlgrid to another by pressing the F7 key.

Features

  • Move focus within form sections.
  • Full focus control by keyboard.
  • Move focus "forward" by pressing F7 and "backward" by pressing Shift+F7.

Download

Top

To download demo program of TrDBFormTemplate.

The demo program demonstrate:

  • The power of TrDBFormTemplate as a small frontend for Delphi's MastApp database.
  • Extensive use of DataModules.
  • How to build a CS Frontend Application.
  • Usage of Delphis TDBCtrlGrid as a DB Grid with spezial features like columns sorting by mouse click.
  • And many more.

Register

Top

If you are interested in TrDBFormTemplate send a eMail to sales@triadis.ch.

Planed for the Future

Top

  • Record level copy and paste.
  • Multiple record bookmarks.
  • Dataset sorting by click in grid header.
  • Printing a grid in Table-View.
  • Saving and restoreing the grid layout.
  • Visual WHERE clause builder.

triadis engineering GmbH
Eichholzstrasse 7
Postfach
CH-3254 Messen

1998 triadis engineering GmbH

Telefon: +41 (31) 768 15 15
Telefax: +41 (31) 768 15 16

mailto:admin@triadis.ch

1998-11-11