arts-pdf variform plus 1.0.2 ユーザーズマニュアル
ARTS PDF Variform Plus
7.3 SQL
Queries
SQL (Structured Query Language) is a standard interactive and programming language
for getting information from and updating a database. Although SQL is both an ANSI and
an ISO standard, many
database products support
SQL with proprietary
extensions to the standard
language. Queries take the
form of a command language
that lets you select, insert,
update, find out the location
of data, and so forth.
A database query can be
either a select query or an
action query. A select query
is simply a data retrieval query. An action query can ask for additional operations on the
data, such as insertion, updating, or deletion. Variform only supports select queries since
its purpose is to merge data from a database, not to change or manage data.
either a select query or an
action query. A select query
is simply a data retrieval query. An action query can ask for additional operations on the
data, such as insertion, updating, or deletion. Variform only supports select queries since
its purpose is to merge data from a database, not to change or manage data.
Because of the broad range of possibilities in SQL queries this document makes no
attempt to explain them in any detail. Users who are unfamiliar with writing SQL queries
should seek assistance from an IT professional or published books on the subject. A
widely available book is: SQL Queries for Mere Mortals: A Hands-On Guide to Data
Manipulation in SQL
attempt to explain them in any detail. Users who are unfamiliar with writing SQL queries
should seek assistance from an IT professional or published books on the subject. A
widely available book is: SQL Queries for Mere Mortals: A Hands-On Guide to Data
Manipulation in SQL
by Michael J. Hernandez and John L. Viescas.
7.3.1 Querying an authenticated Database
To query an authenticated database, follow the steps below:
• Go to ARTS PDF Variform Plus -> Setup...
• Then click on 'Connect', select the 'Machine Data Source'
• Look for the DSN created and click to select then press 'Ok'
• If the database is authenticated, it will prompt for the username and password
then click 'Ok' once the user id and password have been entered.
• You can now write queries and test them to see if they return the relevant data.
• If the relevant data is returned, click on 'Ok' to confirm settings.
Queries should be written in the following format:
SELECT fieldname FROM databasename.DBO.tablename
fieldname = Name of the field in the selected table
databasename = TestingDatabase
tablename = Customers
ARTS PDF Variform Plus 1.0.2
Page 27 of 28
Copyright © 2004 ARTS PDF