commandText Attribute

Microsoft Office InfoPath

Show All Show All

commandText Attribute

A string property that contains the ActiveX Data Objects (ADO) SQL command text to be used for querying the data from the specified data source.

Type

      xsd:string
    

Remarks

The commandText attribute is a required attribute of the adoAdapter element.

Example

The following is an example of the commandText attribute as it is used in the adoAdapter element:

    <xsf:query>
   <xsf:adoAdapter 
      connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
         Password=&quot;&quot;;User ID=Admin;
         Data Source=infnwind.mdb;Mode=Share Deny None;
         Extended Properties=&quot;&quot;;..."
      commandText="select [EmployeeID],[LastName],[FirstName] 
         from [Employees] as [Employees]" 
      queryAllowed="yes"
      submitAllowed="yes">
   </xsf:adoAdapter>
</xsf:query>