SDK Code in Hana

[ramco1917]

Hi

  I have below query and i want to do it through SDK for Hana version. Can anyone guide.

Select sum(*) from ODPO A

WHERE

A.cardcode = "C00001' and A.Canceled = 'N' and A.Docstatus = 'O'

Thanks

[mgregur]

Hi,

HANA is Case Sensitive, so your query should take that into account:

Select sum(*) from ODPO A

WHERE

A."CardCode" = "C00001' and A."Canceled" = 'N' and A."DocStatus" = 'O'

BR,

Matija

[ramco1917]

Hi All . I want to know how to do it using SDK with c#.