[原创]SAP Business One DataTable

Description

Runs the specified SQL query.

Syntax

Public Sub ExecuteQuery( _
   ByVal Query As String _
) 

 

Parameters

Query

A string specifying the SQL query you want to execute.

Remarks

This is an open query that the system does not validate.

 

Example

The following code lines show how to fill a DataTable by query.

[Visual Basic] 

Set oDataTable = oForm.DataSources.DataTables.Item(m_DataTableUid)
    queryStr = "Select 0, CardName, CardType, GroupNum from OCRD"
oDataTable.ExecuteQuery queryStr

See Also

DataTable Object

纳闷!oDataTable.ExecuteQuery(select * into #temp from oact;select #temp,drop table #temp)报错
而oDataTable.ExecuteQuery(select * into #temp from oact;select #temp)正常编译