QUERY with SDK in SAP HANA

Hello Experts,

I am doing a query from the SAP SDK to SAP HANA, I use Visual Studio 2015 with C #.

The error that gives me is when I make a WHERE, that does not bring me anything and I effectively check that it exists in sap, since I do the same query but without WHERE and it shows me.

screenshot-1.png (64.8 kB)
screenshot-2.png (48.4 kB)

Hello Experts, I am doing a query from the SAP SDK to SAP HANA, I use Visual Studio 2015 with C #. The error that gives me is when I make a WHERE, that does not bring me anything and I effectively check that it exists in sap, since I do the same query but without WHERE and it shows me. screenshot-1.png (64.8 kB) screenshot-2.png (48.4 kB)

QUERY with SDK in SAP HANA

Very Helpfull

User Rating: Be the first one !
Doctor Asked on September 29, 2017 in SAP PORTAL.
Add Comment
2 Answer(s)

oRecordSet.DoQuery(“SELECT * FROM OITM WHERE OITM.\”ItemName\” = ‘ABCDEFG'”);

Add Comment

Hi Jesus,

Did you try use in your code, the same query that you use in query manager with the where clause?

Hana have differences of SQL Server. One is that the fields should be envolved with “.

A sample:

SELECT TOP 10 * FROM OITM WHERE "ItemName" = 'your item name'

Hope it helps.

Kind Regards,

Diego Lother

Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.