The Database menu bar contains all options associated with a database object.

These include:

Remove

Removes the current database object, and all of it's query objects, from the dataModule page.

Add Query

Opens the "Create Query Object" page. Query objects give you access to particular tables contained in the current database and are based on an SQL (Structure Query Language) statement. This page contains two options for creating a query object.

Option 1 automatically builds a simple SQL statement, such as "select * from customer.dbf", that returns all fields, and rows from a selected table. All tables contained in the current database are displayed in the Select Table listbox.

Option 2 allows you to type an SQL statement manually. You can also build an SQL statement using the "SQL Statement Builder". This option is available by clicking the SQL button on any existing query object.

Log In

To activate a query object based on a security protected table, it is necessary to enter the requisite information in the login fields. If you initially neglect to do so, you can still login to the table by accessing the login fields via the "Log In" button. The same holds true when you open a previously saved dataModule that contains protected databases. After loading the .dmw from disk, click the "Log In" button for each database that requires you to log in.