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#.

[ANKIT_CHAUHAN]

Hi ramco1917,

It can be done something as below:

Query = @"SELECT IFNULL(SUM(""U_PKGWGHT"") + SUM(""U_BAGWGHT""), 0) AS ""BAGWGHT"" FROM " + TEST.HanaDBName + @".""@PACKINGTABLE"" WHERE ""U_BAGNUM"" = '" + MYBAGNUM + "'";
SAPbobsCOM.Recordset oRs = ((SAPbobsCOM.Recordset)(oCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset)));
oRs.DoQuery(Query);

Kind regards,

ANKIT CHAUHAN

SAP Business One Support