Difference between revisions of "Database"

From OCAD 12 Wiki - English
Jump to: navigation, search
Line 20: Line 20:
Next Chapter: [[Chapter 18: XML Script]]
Next Chapter: [[Chapter 18: XML Script]]
Back to [[Help:Contents]]

Revision as of 13:12, 2 September 2011

Introduction to Database Connection

(Database connection is a feature of the Professional edition only)

In OCAD you can link objects to information in the database about this object. A database normally consists of several tables. In flat file databases like dBase, each table is a file. All tables in a folder form a database. In other databases like Access or in spreadsheet programs like Excel all tables of the database are in the same file. A table consists of records. A record contains the information about one OCAD object. A record consists of fields which contain the information. A special field is the key field. It normally contains a number to identify the record. To link an OCAD object to a record the number in the key field is stored in the object.

Dataset To connect to a table OCAD uses a dataset. The dataset contains the link to the database, the name of the table, the name of the key field and information about other special fields. You can have several datasets for the same OCAD map. To create a dataset choose Manage Database connection from the Database menu. You can access on databases via ODBC (Open Manage Database Connection). This is an interface to connect to all kind of databases.


Previous Chapter: Chapter 16: GPS

Next Chapter: Chapter 18: XML Script

Back to Help:Contents