Data Access User Manual

This manual consists of a table of contents, preface, 12 chapters, 4 appendixes and a glossary.

Views Data Access Common Framework

• Introducing Data Access contains a brief introduction of the product.

• Data Access Basics describes the basic objects in Views that are necessary to build an application with Data Access. The second part of this chapter is an overview of Data Access and the main objects that are available in the API.

• Tables describes one of the most important objects in Data Access, the table object (IliTable class and its subclasses).

• Data Sources and Gadgets describes the data source object (IliDataSource and its subclasses) and data source aware gadgets.

• Handling Values in Data Access contains information on how values are handled in Data Access, without having to take into account their actual type until run time. This feature is implemented by the IliValue class.

• Hints and Tips for Using Data Access contains some examples of the types of situations that you may encounter when using Data Access (and Views Studio), and provides you with some useful tips on how to handle them.

Data Access and SQL

• SQL Tables contains more detailed information on one of the most important table subclasses in Data Access, IliSQLTable. This is the class used to connect with a relational database management system.

• SQL Data Sources tells you how to define parameters in an SQL table and provides hints on using the SQL data source.

• Connecting to a Database contains information on how Data Access objects are used to implement a connection to a database.

Views Data Access Gadgets

• Views Studio Data Access Gadgets introduces the Data Access gadgets found on the Palettes panel.

• Data Source Gadgets Reference describes the two data source creation gadgets: IliSQLDataSource and IliMemoryDataSource.

• Display Gadgets Reference describes the display gadgets listed in the Data Access menu in the Palettes Panel.

• Utility Classes provides information on a few of the useful additional classes in Data Access, IliString, IliDate, IliFormat, and IliInputMask.

• Format Syntax, describes the syntax used to specify the data format.

• Mask Syntax, describes the syntax used to specify the mask format.

• Error Messages, describes the error messages.