2.2.1.2.19 adoAdapter

  • Article

The adoAdapter element specifies the properties of a data adapter that MUST be created to query data from a database. The ActiveX Data Objects (ADO) data adapter MUST NOT support submitting the form file and MUST NOT support querying an Access data source.

Parent Elements

dataAdapters

query

Attributes:

commandText: This attribute specifies the SQL statement that is used for querying or submitting data to a database.

connectionString: This attribute specifies the ADO connection string that is used to connect to a database. The specified value MUST NOT specify a data connection to a data source file with the extensions ".mdb", ".mde", or ".accdb".

name: Specifies the name of the data adapter. The specified name MUST be unique for all data adapters within the form template. If this attribute is not present, its value MUST be interpreted as an empty string.

queryAllowed: This attribute specifies whether the data adapter is allowed to query the database for data. If this attribute is not present, its value MUST be interpreted as "yes".

submitAllowed: This attribute MUST be ignored.

The following W3C XML Schema ([XMLSCHEMA1] section 2.1) fragment specifies the contents of this element.

 <xsd:element name="adoAdapter">
   <xsd:complexType>
     <xsd:attribute name="name" type="xsf:xdTitle" use="optional"/>
     <xsd:attribute name="connectionString" type="xsd:string" use="required"/>
     <xsd:attribute name="commandText" type="xsd:string" use="required"/>
     <xsd:attribute name="queryAllowed" type="xsf:xdYesNo" use="optional"/>
     <xsd:attribute name="submitAllowed" type="xsf:xdYesNo" use="optional"/>
   </xsd:complexType>
 </xsd:element>