SQVAR

Used in

CONFIG  RESPONSE  

Servers


Parent elements

STOREDQUERY 

Syntax

<SQVARAttribute Description Table
     name="[%var%]"
     position="nonnegative value"
>

     (r)<FIELD... />

</SQVAR >
(r): Attribute or child element is required.

Description

Defines a position of the query field in the where expression of the query element.

Restrictions


Attribute Descriptions for SQVAR

AttributeUsage
nameDefines string used for the variable name.
positionDefines 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.
Back to top 

Examples for SQVAR

<?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>

Back to top