Working with Forms

To create an OpenInsight Data Entry Form, from the OpenInsight IDE choose New, Windows Forms, Data-bound Form.

From the New Data-Bound Form dialog box select Tables from the drop-down list. A list of native tables is displayed in the list box.

Select the OpenInsight table from the list in the list box (by double-clicking the name). Choose SALES_SALESTERRITORY

The columns from the selected table are displayed in the Columns list box.

Select columns from the Columns list box to use in creating the OpenInsight form. To select a column, double-click on the column name in the Columns list box or select the column and click the Add button. The selected columns are displayed in the selected columns edit table. The order in which columns are selected sets the tab order for the controls in the OpenInsight form being created. Select all the fields.

The default control type for columns is an Edit line. The Edit Table control is the default control type for a multi-value column. If you want to specify another control type, select the appropriate column row in the selected columns edit table and double-click to display a list of control types. Double-click the required control type in the control type list for the specified column. The new control type is indicated in the selected columns edit table.

If you want to remove a column from the selected columns edit table, select the column row and click the Remove button. The row is deleted from the edit table and therefore not displayed on the OpenInsight form.

When all columns have been selected and the required controls specified, click the OK button to create the default OpenInsight form. The form should resemble the following:

Rearrange and resize your controls by holding the Ctrl key and clicking on the controls you want to select. Right click to rearrange and resize the selected controls.

Save the form by choosing File, Save from the OpenInsight IDE. The Save Form dialog box will be displayed.

Type SALESTERRITORY in the Entity Name field and click the OK button.

Choose Settings, IDE Settings from the OpenInsight IDE.

Click the test run button from the Tool Bar.

Type an initial value (1 – 10) for the TerritoryID then tab off the field. The form will display the customer information.

You can also enter a new customer record by selecting a TerritoryID greater than 10.

5. Press the OK button on the form to save this record. The record is saved, the form is cleared. After adding or displaying the last record, choose Cancel to exit the form. This will return you to the Form Designer.

Multiple Document Interface (MDI) windows are child windows or OpenInsight forms that belong to a parent frame and are displayed in the window client area. The MDI Frame is the main window and normally contains a menu, a client area and a status line. The MDI Frame controls all of the child windows. The MDI children are the OpenInsight forms that appear within the client area of the MDI frame.

To create an OpenInsight MDI Frame, from the OpenInsight IDE choose New, Windows Forms, MDI Frame.

An MDI frame with an MDI client window is displayed. The MDI client window is part of the frame window and cannot be deleted or copied. MDI child windows are confined to the MDI client area. The text “MDI Client Window” is visible only during OpenInsight form design so that you can distinguish the MDI client area from other controls. The Client Window should display as follows:

The MDI Client Window can be resized.

MDI Child windows are those that reside within the MDI client area. MDI Child windows can be any OpenInsight form created for the current application. MDI Child windows are often created prior to creating the MDI frame. A feature of MDI child windows is that they do not contain menus. Menu functionality is provided by the frame.

An MDI child is executed from the MDI frame with the BASIC+ function START_MDICHILD.

Choose Edit the menu for this form button from the Toolbar. The Menu Builder designer is displayed.

The first menu item is highlighted.

Enter Sales Territory in the Add listbox. Click the + button.

Use the arrow buttons and indent buttons to place your menu item in the correct postion.

Choose File, Save from the OpenInsight IDE.

Check the Quick Event check box. The Quick Events dialog box is activated.

Choose Start an MDI child window from QuickEvent Options. The EventAction Params value will be populated with default settings for the Start_MDIChild function.

On the Specify Procedure Parameters: change WinID to ‘SALESTERRITORY’ and CreateParam to null (‘’). Include the single quotes.

Press the OK button. This will return you to the MDI Frame.

Select File, Save from the OpenInsight IDE. Enter ADVENTUREWORKS_MDI for the name of the form.

Click the test run button from the Tool Bar. The following MDI Frame will display:

Choose Sales Territiry from the File menu. The SALESTERRITORY data entry form will display:

Your application now contains MDI capability.