Topic group Related topics

 

  1.  Choose File|New|Data Module, and choose Designer OR from the Navigator choose the Data Modules tab and double click on the [new Data Module] or [new Custom Data Module] icon.
    The Data Module Designer is similar to the Form designer, except that it has no grid and the Component palette contains only data access components.

  2.  Drag the components you need onto the design surface and set their properties (SQL and so on) and write their event handlers. Press F12 to toggle between the Source editor and the visual designer.

  3.  When everything is set up as you want it, save the data module (File|Save). It is saved with a .DMD extension.

Creating business rules in a dataModule

Besides writing event handlers for the components in a dataModule, you can code methods directly in the source file for a dataModule. These methods can be applied to the forms that use the dataModule as business rules. For example, you might write a procedure to perform month-, quarter-, or year-end bookkeeping. You might call the procedure from an event handler for a component in the dataModule.

NOTE: see Linking Master/Detail in Local tables for info on how to create a Parent/Child relationship with dBASE Tables.