Skip to Content

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

Help

Hi everyone!

I have problem in execute query to delete and create a report with SQL 2000 in SAP.

Try

oForm.DataSources.DataTables.Item(0).ExecuteQuery("DELETE FROM rptReport")

Catch ex As Exception

End Try

oForm.DataSources.DataTables.Add("TestReport")

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

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