cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with HANA Update -10210 Invalid command state (No prepared SQL command)

shail_verma
Explorer
0 Kudos

Hi,

I am using ODBC to query HANA. I am also able to do a select and have data come from HANA. However, when I am trying to do an Update, I get the following error.

[SAP AG][LIBODBCHDB DLL][HDBODBC] General error;-10210 Invalid command state (No prepared SQL command)

Following is the SQL Query I am using

hxehost.."XXX."US_PEOPLE" set "FIRST_NAME" = 'Mr. X' where "PHONE1"= '123-111-1111'

Accepted Solutions (0)

Answers (1)

Answers (1)

SergioG_TX
Active Contributor
0 Kudos

are you missing the actually UPDATE keyword ?

update <Table> -- first word on this line

set <col> = <value>

where <col>=<condition>

shail_verma
Explorer
0 Kudos

thanks for your input however i added the update keyword in query. The same query is running in HANA Studio but not through external system