AGG Software
Ask a question  Top  Previous  Next

SQL

The program can retrieve data using two methods:

 

1. Table name. In this case, then program will read all columns from the specified table. The program will automatically build the SELECT SQL query.

2. SQL statement. You can specify your own SQL statement with necessary columns. Also you can query data from several tables. For example:

 

SELECT COL1, COL2 FROM DATA

 

sqlsrc2

Fig. 2.10.2 SQL

 

Select interval - the program will execute the selected query the every specified interval.

 

Check new data by column - you can specify a column name that the program will use to select new data only. After each query the program will store a maximum value and next time will select new data only. If you'll not specify a column name then the program will read all data from a database with every query. It can be useful, if your table contains just few records that are being updated periodically.




Copyright © 1999-2016, AGG Software.
All rights reserved.