XFA Specification
Chapter 20, Source Set Specification
Source Set Element Reference
772
The query element
Controls a cursor and associated record set.
<query
Properties:
commandType="unknown
|
text
|
table
|
storedProc"
id="xml-id"
name="xml-id"
use="cdata"
usehref="cdata"
>
<recordSet>
[0..1]
<select>
[0..1]
Children:
<map>
</query>
[0..n]
The query element is used within the following other elements:
command
Despite the name, this element can also be used to delete, insert, and update records.
The commandType property
The type of select string in the child select element. This has the same function as "CommandTypeEnum"
defined in the ADO API Reference [ADO], but it has a more restricted range of values. The value must be
one of the following:
unknown
Indicates that the type of select string is not known. The XFA application or database is required to
parse the string to find out.
text
Indicates that the select string is a SQL command or textual stored procedure call.
table
Indicates that the select string is the name of a table. All of the columns in the table are returned
by the query.
storedProc
Indicates that the select string is the name of a stored procedure.
The id property
A unique identifier that may be used to identify this element as a target.
The map child
Maps a database column to a bind element descended from the same source element.