Skip to Content
avatar image
Former Member

Incorrect Syntax in HANA

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 11, 2018 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.

    Add comment
    10|10000 characters needed characters exceeded