Incorrect Syntax in HANA

[Former Member]

Dear Experts,

Am using DataAdpater to update one UDT in SAP B1 Hana database. But am getting the following Error.

"Sap.Data.Hana.HanaException (0x80004005): sql syntax error: incorrect syntax near "@": line 1 col 13 (at pos 13) at Sap.Data.Hana.HanaDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.UpdateFromDataTable(DataTable dataTable, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataTable dataTable) "

Even I have tried with HANADATAADAPTER also. But still same Error.

Code :

sboStagingHanaAdapter.UpdateCommand = new HanaCommand(updateCommand, this.SboHanaConnecton);

sboStagingHanaAdapter.Update(dt);

sboStagingTableAdapter.UpdateCommand = new System.Data.Odbc.OdbcCommand(updateCommand, this.OdbcConnection);

sboStagingTableAdapter.Update(dataSet.Tables[0]);

Thanks in advance.

[former_member233854]

Please, share the command you are trying to run

[former_member197733]

It will be hard to tell without sharing the query.

Nevertheless, read my answer about SQL statements on HANA.

The XSOdata works on top of tables as well and might give you a more streamlined approach.