on 12-20-2016 5:54 PM
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'
are you missing the actually UPDATE keyword ?
update <Table> -- first word on this line
set <col> = <value>
where <col>=<condition>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.