The dataModule Menu Bar contains all options associated with the dataModule.

They include:

Add Database

Takes you to the "Database Object" screen, which displays all available BDE aliases. A BDE alias can point to local tables (dBASE, Paradox, Foxpro, etc.), or client-server tables via SQL Links drivers or ODBC.

A database gives you access to tables. If the tables are local, a database will simply point to a directory available to the web server. If the database is for client-server tables, you’ll be given access to tables in that database.

The three login fields, UserID, Password and Group, can be left blank for local tables not protected with security. For encrypted dBASE tables, all three login fields must be entered. For client-server tables, or protected Paradox tables, both UserID and Password must be entered. Contact your database administrator to find out specific security requirements for the databases you need to access via a dQuery/Web Query.

Test

This option executes the current dataModule to determine if all currently selected options are valid. An attempt is made to open all database and query objects of the current dataModule. If a database or query object cannot be activated, an error screen will point to the source of the problem. For example, if you added a client-server database but forgot to fill in the security fields, the error "Activation of datamodule has failed" will be displayed along with the actual line of dBL code where the problem occurred.

Save

If the current dataModule has been saved previously, the Save button will overwrite the existing .dmw file, incorporating any changes made since the dataModule was last opened. Otherwise, the Save button will open the "Save dataModule to Disk File" page described below.

Save As

Opens the "Save dataModule to Disk File" page. This page contains two options:

Option 1, "Overwrite an existing .dmw file", contains a drop-down of all saved .dmw files. The current dataModule will be saved as, and consequently overwrite, the file selected from the drop-down.

Option 2, "Create a new .dmw file", prompts you to supply a name for the new dataModule. Once entered, click the "Submit" button to save. It is important to give the file a .dmw file extension, otherwise it will not appear among the available selections when you later attempt to load an existing dataModule file.

Open

Opens the "Load dataModule from Disk File" page, which displays a listbox containing all available dataModule (.dmw) files. After selecting the dataModule you wish to load, click the "Submit" button to return to the dataModule page. The dataModule will be loaded from disk, and displayed.

New

Clears the current dataModule, and all of it's objects, from the page. This option reverts the dataModule page to an empty, untitled state.

Warning: The "New" option does not give you an opportunity to save your work! It is used to abandon your current work when you wish to start over.

Delete

Opens the "Delete DMW Disk File on Server" page, which displays a listbox containing all available dataModule (.dmw) files. After selecting the dataModule you wish to delete, click the "Submit" button to permanently remove it from the server's hard drive.