Problem use SQL query in coding report with SBO
I have problem in execute query to delete and create a report with SQL 2000 in SAP.
oForm.DataSources.DataTables.Item(0).ExecuteQuery("DELETE FROM rptReport")
Catch ex As Exception
oForm.DataSources.DataTables.Item(0).ExecuteQuery("SELECT Number, RefDate, Memo into rptReport FROM dbo.OJDT")
oTable = oForm.DataSources.DataTables.Item("TestReport")
This code is error. I don't know how to execute 2 this sql command. Hope everyone help me hix hix! .