Skip to Content

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

ExecuteSQL rets empty record if no any data retrieved with SQL

Hi All ))

I sent for ex. "this" :

<DoQuery>

set dateformat ymd

select ItmsGrpCod, ItmsGrpNam, createDate, updateDate from OITB where createDate > '20100101'

</DoQuery>

And I receive this:

<ExecuteSQLResponse xmlns="http://www.sap.com/SBO/DIS">

<BOM><BO><AdmInfo>

<Object>oRecordset</Object>

</AdmInfo>

<OITB><row><ItmsGrpCod>0</ItmsGrpCod><ItmsGrpNam/><createDate/><updateDate/></row></OITB></BO></BOM></ExecuteSQLResponse>

Why? How could I get no records if no data?

Edited by: Slava Vladimirov on Sep 9, 2008 5:09 PM

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