Share via

IAxapta::ExecuteStmt

  • Article

HRESULT ExecuteStmt(

  [in] BSTR bstrStmt,

  [in] VARIANT record1,

  [in, optional] VARIANT record2,

  [in, optional] VARIANT record3,

  [in, optional] VARIANT record4,

  [in, optional] VARIANT record5,

  [in, optional] VARIANT record6,

);

Executes a statement on the specified Axapta records.

The statement must be a Microsoft Axapta X++ statement. A valid a statement could be: select * from %1 where %2.Name == ‘Axapta’. This statement requires two Microsoft Axapta records, one for %1 (record1) and one for %2 (record2). The %-signs are automatically substituted with the corresponding record names.

This method offers the same functionality as IAxapta::ExecuteStmtEx and the method accepts up to 6 Microsoft Axapta records. If more than 6 Microsoft Axapta records are needed then IAxapta::ExecuteStmtEx must be used.

Parameters

bstrStmt

The statement to execute on the specified records.

record1-record6

Microsoft Axapta records to replace the %-signs in the bstrStmt. record2 to record6 are optional.

Return Value

The return value obtained from the returned HRESULT is one of the following:

 

Return value

Meaning

S_OK

Success

E_FAIL

General failure

E_INVALIDARG

One or more of the arguments is invalid

The IAxapta object is not logged on

The security key for using class objects through the Microsoft Axapta Business Connector is disabled

Comments

If only one Microsoft Axapta record is specified in the bstrStmt it is often more convenient to used the IAxaptaRecord::ExecuteStmt method.

Example (Visual Basic)

Dim Axapta As Object

Dim MyRecord As Object

 

Set Axapta = CreateObject("AxaptaCOMConnector.Axapta")

 

Axapta.Logon

 

‘ create an Axapta record

Set MyRecord = Axapta.CreateRecord("MyTable")

 

Axapta.ExecuteStmt "select * from %1 where %1.Name == ’MyName’", MyRecord

 

While MyRecord.Found

  txt = MyRecord.Field("Address")

 

  ‘ do something with the address in "txt"

 

  ‘ get the next record

  MyRecord.Next

Wend