Object Automation

The Object Automation dialog allows you to create new queries, forms, views, and stored procedures from other database and profile objects in the quickest way. To open the dialog, select an object in the Profile Window and select one of the following Insert menu sub-items: Auto Query, Auto Form, Auto View or Auto Procedure.

The appearance of the dialog depends on source and target object types.

Selecting Auto Query from a table allows you to set the new query name and select columns for the query. The Use Relationships option defines whether the INNER JOIN clauses, generated from the profile relationships will be added to the new query text. The Auto Query dialog is available for tables, views, and procedures.

The Auto Form dialog also allows you to set the name of the form and select columns to add as controls to the form. The Use Relationships option defines whether the lookup controls will be used while generating the form. Check the Form is Read-Only option to make the new form non-editable. The Auto Form dialog is available for tables and views.

The Auto View dialog allows you to create database views from tables and SELECT-based queries. Set the view name, select the columns for the view, and select whether to add the relationship-based joins to the view text. Note, that views are available only for MySQL 5.0.1 or higher.

The Auto Procedure dialog is available only for non-SELECT queries. It creates a stored procedure simply by putting the source query text into the procedure body. Note, that stored procedures are available only for MySQL 5.0 or higher.

The Auto Page dialog allows you to create web pages from tables, view or data forms. Use Create Page as Form/Create Page as Grid options to select whether the page will represent the table or view data within an editable form or within a table. The Use Relationships option defines whether the lookup controls will be used while generating the page. Check the Form is Read-Only option to make the page form non-editable.