Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Problem use SQL query in coding report with SBO

Hi everyone!

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

End Try


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! .

Former Member
Not what you were looking for? View more on this topic or Ask a question