EQuIS Forms Series – Part 4 of 5 – EQuIS SQL Form – April 2016

April 20, 2016




Part 4 of 5
EQuIS Forms provide users with the ability to view and update data from often-used tables that relate to facilities, locations, and sample test results.

TABLE of CONTENTS
01:00 Definition SQL (1:20)
02:20 EQuIS SQL Form (1:55)
04:15 Limitations SQL Query Form (1:31)
05:46 Overview EQuIS SQL Form (1:16)
07:03 Basic Query (6:25)
13:29 Multiple Tables Query (4:28)
17:57 Exploring the Database (15:23)
33:22 Publishing a (*.sql) Report (2:36)
35:58 Q1? Is there a list of valid local variables?
38:34 Q2? Once the SQL statement has been published, does it appear under the Report tab, or the Form tab?
39:28 Q3? What permissions are required to publish a report?
39:57 Q4? Are there any blocks for the type of SQL, such as Insert or Delete?

Download EQuIS Forms Series:
Part 1 of 5 – Introduction to Forms – March 2016 [16:34]
Part 2 of 5 – Coordinate Conversion Form – March 2016 [14:30]
Part 3 of 5 – RVF Builder Form – April 2016 [10:30]
Part 4 of 5 – EQuIS SQL Form – April 2016 [43:50]
Part 5 of 5 – Create Custom Forms in EQuIS Professional – April 2016 [39:10]



Subscribe to Our EarthSoft YouTube Channel!



View Over 300+ EarthSoft Videos!

Comments

Comments are closed.


EarthSoft Currents Week 50 2017 Video Newsletter

Create Crosstab Configurations and Templates - Dec 2017