Query
Reference Manual
Introduction
Introduction
Query is a flexible way to access and manipulate the contents of outside databases from within its products. It provides for a two-way flow of data between application programs and local or remote databases using Structured Query Language (SQL) as its database access language. SQL became an ANSI standard in 1986 and an ISO standard in 1987; it is used today in a great many database application programs management systems.
Query is essentially a programming toolkit which allows the user to create their own macros to carry out functions such as:
•
Reading additional attribute data from local or remote databases
•
Adding object and attribute data to external databases
•
Adding functionality to existing user interfaces
The addition of Query to an application program forms a powerful programmable engineering database system.
Query supports Open Database Connectivity (ODBC), an interface standard for database access. All components necessary to provide the ODBC interface, such as communications, are internal to ODBC.
A user of Query commands is presented with the same interface and need not be aware of the different ways in which the functionality is provided, except of course when Query or the database is configured.
1974 to current year.
AVEVA Solutions Limited and its subsidiaries. All rights reserved.
