Using SQL Direct - Some Examples

This chapter gives examples of using SQL Direct to access PDMS data with some of the principal data consumer applications available, but without having to have SQL Server installed. It is assumed that:

• PDMS is correctly installed.

• SQL Direct is correctly installed.

• You have used the Table Designer to set up some tables. Refer to Table Designer and Using the Table Designer.

Full details of the installations are in the relevant installation guides.

Example database files for each of the applications named in this chapter are supplied as part of your installation. You can find them in:

C:\AVEVA\SQL-Direct12.0\Samples