SQL strings enable the application of advanced filters within SAP2000. The SQL string entered into SAP2000 corresponds to the portion of the full SQL Select Statement which follows the
SQL Where Clause
. To demonstrate, advanced filtering will be applied, using SQL strings, to the Joint Coordinates table of Verification Example 1-024 as follows:
Report 1
Report 1 selects all joints where the X coordinate is greater than 1.0, then organizes the data in order of XorR, Y, and Z coordinates using the SQL string which follows:
XorR > 0 ORDER BY XorR, Y, Z
The application of this advanced filter SQL string is shown in Figure 1:
Figure 1 - Advanced filter SQL string
Data is organized accordingly in the Joint Coordinates table, as shown in Figure 2:
Figure 2 - Joint Coordinates table
Report 2
Report 2 selects all joints with a Z coordinate between 12 and 14, then organizes the data by XorR, Y, and Z coordinates using the SQL string which follows:
Z > 12 AND Z < 14 ORDER BY XorR, Y, Z
The application of this advanced filter SQL string is shown in Figure 3:
Figure 3 - Advanced filter SQL string
Data is organized accordingly in the Joint Coordinates table, as shown in Figure 4:
Figure 4 - Joint Coordinates table
External Links
- Unknown macro: {new-tab-link}- SQL tutorial by w3schools.com
SQL Where Clause