SAP Business One DataTable

wanghao

DescriptionRuns the specified SQL query.
Syntax
Public Sub ExecuteQuery( _   ByVal Query As String _)

ParametersQuery A string specifying the SQL query you want to execute.
Remarks

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

ExampleThe 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 AlsoDataTable Object

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