SQL query form is available, but requires SQL syntax knowledge

Niagara Release 2.3
Revised: August 15, 2002
Niagara Browser Access Guide
Chapter 7 Application Database
Using the SQL Query Form

7–8
Typically, the SQL select statement is used to retrieve data. All queries run against a particular database table, which you must type inexactly as it appears in the database. The wildcard asterisk (*) is also typically used to select all fields (columns) in an archive, coupled with a where condition that limits which records are selected. SELECTS TATEMENT E
XAMPLES
Table 7-1
shows a few example SQL queries using the select statement. You can experiment with the query form using similar statements modified to name appdb tables in your system. (The select statement is never destructive to appdb data).
Note
Any SQL query with a syntax error yields a The page cannot be found result.
Tip
To avoid typing table names in queries, open another browser window and and sign onto the station to display the database (appdb) index (

Download 3.76 Mb.

Share with your friends: