Description

Creates an empty Isah data entry form.

Use the EditForm Object to activate an instance of a Isah Edit form and to populate it with data from your database. You can use the Edit form to view specific data and to create and mutate data from your database. All standard grouping, sorting, search, filter functionalities will be available in this Edit form.

The EditForm implicitly uses Isah framework functionalities (properties, methods and events) for mutating data.

If you want to mutate standard Isah tables be sure to create SIP stored procedures by copying and renaming the standard stored procedures (the IP_sel_xxxRS, IP_ins_xxx, IP_del_xxx and IP_upd_xxx stored procedures). Stored procedure names always have to begin with the character 'S'. For more information about database customizations see Deal With Database Customizations.

All primary keyfields, IsahUserCode and the LastUpdatedOn fields must be available in the derived SIP_sel_xxxRS stored procedure. Be sure that these required fields are available in the derived stored procedure.

If you want to extend a standard Isah table you can choose between different scenarios.

• Parent-Child Edit Form relation

  Use the parentform to browse the standard Isah data (grid only) and link the parent form to a child form where you can mutate the related records of your own table. See the Edit Form With Childs Code Snippet to get an idea how to implement a Parent-Child relation.

• A 2-query edit form

  Display the standard Isah data (by calling the IP_sel_xxxRS stored procedure) in the grid on the Browse tabsheet and your own data on the Record tabsheet (by calling your own linked SIP_sel_xxxRecord stored procedure). See the RecordSQL Property for more information. See the 2-Query Edit Form Code Snippet to get an idea how to implement a 2-query Edit form.

Remarks

• The TEditFormObject inherits its class from the TForm object. You can use all properties, procedures and functions available as TForm components in the TEditFormObject. Please refer to the Components section for more information on the controls and components that you can use to build custom forms and the properties, methods and events that are available.
• The IsahDBGrid properties and methods as described in TIsahDBGrid and TIsahDBGridColumn can also be invoked on the TEditForm object. Use the IsahGridMain dataset (myEditFrm.IsahGridMain) to invoke the properties and methods.
• Because of the implicit usage of Isah framwork functionality do not override events that are not described in this reference manual. The behaviour of the EditForm will become unpredictable and unstable if you do override the events. If you want to use events on a EditForm please use event scripts.

  Another option is to create a editable form from scratch by using a TForm (instead of a TEditForm), TIsahCDSQuery, TIsahCDSStoredProcUpdateObject or TIsahCDSSQLUpdateObject, TIsahDBGrid, TIsahDBNavigator. In this case you can use any of the published events of the dataset component.

• See the code snippets for more information about the usage of the different properties, methods and events.