SQVAR  Examples

Used in:  CONFIG   RESPONSE  
Servers: 
Parent elements:  STOREDQUERY  

<SQVAR Attribute Description Table

     name ="[%var%]"
     position ="nonnegative value"
>

     <FIELD... />

</SQVAR >
Bold: Attribute or child element is required.


Description:


Restrictions:


Notes:


Attribute Descriptions for SQVAR:

Attribute Usage Back to Top
name Defines string used for the variable name.
position Defines the location in the string of the opening bracket "[" in the variable expression. The value should be equal to or less than the position in the string where the bracket is located. If "&apos;" is used in the expression, this is counted as one character.
 

Examples for SQVAR:

Example 1: Back to Top
<?xml version="1.0" encoding="UTF-8"?>
<ARCXML version="1.1">
  <CONFIG>
    <ENVIRONMENT>
      <LOCALE country="US" language="en" variant="" />
      <UIFONT color="0,0,0" name="Arial" size="12" style="regular" />
      <SCREEN dpi="96" />
    </ENVIRONMENT>
    <MAP>
      <PROPERTIES>
        <ENVELOPE minx="-141.0030059814453" miny="41.9133186340332" maxx="-52.62028121948242" maxy="83.10832214355469" name="Initial_Extent" />
        <MAPUNITS units="decimal_degrees" />
        <FILTERCOORDSYS id="4326" />
        <FEATURECOORDSYS id="4326"/>
      </PROPERTIES>
      <WORKSPACES>
        <SHAPEWORKSPACE name="shp_ws-0" directory="<path to CANADA ESRIDATA>" />
      </WORKSPACES>
      <LAYER type="featureclass" name="province" visible="true" id="0">
        <DATASET name="province" type="polygon" workspace="shp_ws-0" />
        <SIMPLERENDERER>
          <SIMPLEPOLYGONSYMBOL filltransparency="1.0" fillcolor="127,127,127" />
        </SIMPLERENDERER>
        <EXTENSION type="StoredQuery">
          <STOREDQUERIES>
            <STOREDQUERY name="Provinces">
              <QUERY where="( NAME = &apos;[%var%]&apos; )" subfields="#SHAPE# AREA CODE NAME POP1991 POP91_SQMI" />
              <SQVAR position="0" name="[%var%]">
                <FIELD name="NAME" precision="0" type="12" size="25" />
              </SQVAR>
            </STOREDQUERY>
          </STOREDQUERIES>
      </EXTENSION>
      </LAYER>
    </MAP>
  </CONFIG>
</ARCXML>