Navigation:  »No topics above this level« How to Work with a Local Database

 

Overview

 

Local Databases are located in the device. A Local Database includes one or more tables which (as data files) provide a storage space for application data but, also, allow for complex data structures like joined tables, etc..

An MCL-Designer V4 project can include one local database with multiple tables.

The data included in the local database are managed and manipulated via SQL transactions.

MCL-Designer V4 provides you with processes ("Insert Record", "Delete Record", "Free SQL Statement",etc.) that handle the table(s) included in the local database.

See Working with the Local Database Processes Group.

The data within the local database can be indexed (see Working with Indexes) and its display can be structured with the help of views (see Working with Views).

The data included in the table(s) of a local database are displayed in the device's screen with the use of certain controls (Combo Box, Input List, Advanced List Box and Grid). The maximum number of displayed records is 1000.

 

 

Topics

 

This chapter covers the following topics: