Forms

DBACentral for MySQL provides a unique feature for viewing and editing data in database tables - user designed forms. Forms can display various types of table data (strings, numbers, enumeration values, images, etc) within specific controls (labels, edit boxes, drop-down lists, etc), navigate through tables, insert new values, update and delete existing rows, and many more. Forms can be a very useful solution for MySQL novices, providing user-friendly graphical interface for working with data instead of data grids. DBACentral forms allow you to create complicate master-detail views, provide easy interface for data filtering, as well as many more powerful features.

The list of forms, stored in a profile, can be viewed and modified at the Forms Page of the Main Profile Window.

You can create a new form in several ways:

1. Create a new form in Design View by double-clicking at the Create form in design view item on the Forms profile window page.
2. Create a new form using the Form Wizard by double-clicking at the Create form by using wizard item on the Forms profile window page.
3. Creating an auto-form from the Table Data View (or Query Data View), or from the Main Profile Window (Tables or Queries page) by selecting the Auto Form item from the popup menu.

To open the existing form for viewing or modifying data, simply double-click at its name on the Forms profile window page.

To change the form design select its name at the Forms page and click the Design button on the toolbar or in the popup menu. This opens the Form Designer, allowing you to add or delete form controls, modify control properties, select form data source, and so on.

To delete a form from the profile, select its name at the Forms page and click the Delete button on the toolbar or in the popup menu.

©2004 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.