Following SAP HANA Query is not executing in C# code. But its working in SAP HANA studio. I'm trying to fix this error for a long time.
Hana queries that I tried:
SELECT VIEW_NAME,VIEW_TYPE,SCHEMA_NAME FROM VIEWS WHERE SCHEMA_NAME ='TEST' SELECT "VIEW_NAME","VIEW_TYPE","SCHEMA_NAME" FROM VIEWS WHERE "SCHEMA_NAME" ='TEST' SELECT view_name,view_type,schema_name FROM VIEWS WHERE schema_name ='TEST' SELECT "view_name","view_type","schema_name" FROM VIEWS WHERE "schema_name" ='TEST'
public dynamic ExecuteReader(string query) { SAPbobsCOM.Recordset recSet = (SAPbobsCOM.Recordset)this.m_CompanyConn.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset); recSet.DoQuery(query); return recSet; } Error: ***** 1). [SAP AG][LIBODBCHDB32 DLL][HDBODBC32] General error;260 invalid column name: VIEW_NAME: line 1 col 8 (at pos 7)