question ConvertJSONToSQL - Ignores underscore in update keys in Support Questions

ConvertJSONToSQL - Ignores underscore in update keys

MPraveen — Mon, 23 Mar 2020 04:53:53 GMT

Eg: Update table table_name emp_name=? where empid=?

But My column name is emp_id

Re: ConvertJSONToSQL - Ignores underscore in update keys

MPraveen — Mon, 06 Apr 2020 05:16:02 GMT

Anybody has answer for this- I get this issue on PutDatabaseRecord as well. When I check java code of PutDatabaseRecord. I could see below replace with - underscore.

Re: ConvertJSONToSQL - Ignores underscore in update keys

MPraveen — Mon, 06 Apr 2020 06:16:04 GMT

Finally fixed the issue by myself. have changed all the columns to Uppercase and made the Translate Field Names to false.. That works for me.

Re: ConvertJSONToSQL - Ignores underscore in update keys

SS_Jin — Thu, 10 Oct 2024 13:55:12 GMT

I set the Translate Field Names to false, it started working, before this it was converting the primary key field to upper case, removing the underscore, so when I run the putSQL, it was throwing error, working fine now, thanks to your answer!