Help

[Former Member]

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_member188826]

Is this an SAP Query created through SQ01? If it is a custom query created through ABAP commands, ABAP forum may be a better one to get more technical details.<a href="https://forums.sdn.sap.com/index.jspa#42">Here is the link.</a>