SAP / node-hdb

SAP HANA Database Client for Node
Apache License 2.0
317 stars 98 forks source link

Invalid parameter: 'parameter (5)' contains different types. #192

Open tq20 opened 2 years ago

tq20 commented 2 years ago

Hi Colleague,

This is a consulting issue. I got an error message when attempting to inserting data into a hdb table as below. image

It seems that if the data type of attribute to be inserted is different from what it defines in db, then the error message will be reported. Even if the data type is string in db, and input data type is number, the data type conversion will be not handled by hana client automatically. I am not sure if it is a normal behavior. Could you please help to clarify?

Thank you very much. BR, Qin

Your Project Name https://github.tools.sap/ROCKETS/sample-cap-change-history-fe
OData version v4
Node.js version v14.18.0
@sap/cds 5.6.1
@sap/hana-client 2.11.14