Skip to Content

Incorrect Syntax in HANA

Dec 22, 2017 at 08:52 AM


avatar image
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);


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


Thanks in advance.

10 |10000 characters needed characters left characters exceeded

Please, share the command you are trying to run

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ralph Oliveira
Jan 11 at 10:54 AM

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.

10 |10000 characters needed characters left characters exceeded