Databases

Summary

Lets you view, edit and test databases

Details

Select a database using the button and the system will display all non-system tables in that database in a tree structure

The system will display various information about the database and an Index Tab offers 4 options:

Fields

Fields in the current Database Table are shown in a grid

These fields can be edited directly, but extreme care should be taken. Changing, for example, a Job Code will render data in other tables which relate to the old Job Code as Orphans

A record selection panel lets you enter an SQL Select statement and then refresh to populate the fields table.

Selected records can be exported to an XML file

Test

A series of tests can be run on the currently displayed database. Results of the test are shown in a display panel

SQL

SQL statements can be entered directly and executed. This should only be done by experienced users with a sound knowledge of SQL syntax. You can do a lot of damage with very little effort.

Database Support

Controls database options and permissions

Newly created databases can be set to various Microsoft Access  formats. In general, use the latest format unless you have an earlier version of   Microsoft Access and you want to be able to link to or edit your databases .

Access databases start to fall down when the databases get large ( say over 30 megabytes ) or the networks or number of users get large. At this stage or before, you should consider switching to a more stable platform such as SQL Server or MSDE. Databuild support staff can help you with this transition.

To enable these formats, check Allow Additional Database Formats, Nominate your Server name, Data Provider and whether data processing is client or server based.

Toolbar

               Creates a new Database. A Database type dialogue box appears:

               Selects or deselects all tables for copying or testing

               Repairs, Updates and compacts a selected database (not the current one) and then selects it.

               Deletes selected rows in the current table. Extreme care should be taken

               Updates a selected database and then selects it

               Repairs and compacts a selected database (not the current one) and then selects it

               Clones (copies) the current Access database

               Copies selected tables from one database to another

               Previews Report. This gives a detailed report of Databuild database structures

               Closes the routine