Share via

ADOAdapter.Command Property

  • Article
InfoPath Developer Reference

Sets or retrieves the SQL command string text for an ADOAdapter object. Read/write

Version Information
 Version Added:  InfoPath 2003

Syntax

expression.Command

expression   An expression that returns a ADOAdapter object.

Return Value
String

Remarks

The Command property of the ADOAdapter object contains the SQL command text that is used by the ADO data adapter to submit data to and retrieve data from an ActiveX Data Objects/OLEDB external data source.

Bb229892.vs_note(en-us,office.12).gif  Note
The ADOAdapter object is limited to work only with Microsoft SQL Server and Microsoft Access databases.
Bb229892.vs_note(en-us,office.12).gif  Note
If a SQL command performs an UPDATE or an INSERT, you must prepend the SQL statement with "SET IMPLICIT_TRANSACTIONS off;" or the command will fail.

Security Level 2: Can be accessed only by forms running in the same domain as the currently open form, or by forms that have been granted cross-domain permissions.

Example

In the following example, the Command property of the ADOAdapter object is used to display the SQL command text of the ADO data adapter in a message box:

JScript 
  var objADOAdapter;

objADOAdapter = XDocument.DataObjects("CityList").QueryAdapter;
XDocument.UI.Alert("SQL command text: " + objADOAdapter.Command);

See Also