Using SQL Pass-Through Statements | 55
Using SQL Pass-Through Statements
The Autodesk MapGuide enhanced layer functionality supports the use of
pre- and post-SQL statements with spatial queries, allowing you to execute
these statements either before or after you perform a spatial query against a
layer.
Note To use pre- and post-SQL statements with spatial queries, you must access
the database management system from within Autodesk MapGuide.
Pre- and post-SQL statements provide access to the database management
system from within Autodesk MapGuide. Although you can execute only
one spatial query statement per layer, you can apply multiple SQL statements
before and after the spatial query to further customize the results. The state-
ments you enter are processed in the order in which you list them.
For example, you may want to access different versions of a version-enabled
Oracle data set. In this case, you would add a pre-spatial query SQL statement
to call the desired workspace in Oracle.
To execute pre- and post-spatial query SQL statements
1 Open the map containing the layer to which you want to apply SQL state-
ments.
2 Double-click the name of the layer in the list to the left of the map. The
Map Layer Properties dialog box is displayed.In the Map Layer Properties
dialog box, click the Data Sources tab, as shown in the following illustra-
tion.
