Skip to Content
0

invalid column name : sap hana

Nov 22, 2016 at 12:20 PM

788

avatar image

Hi ,

I have two columns queid integer primary key , quename varchar i have created it , but when i try to insert values into it 's giving me error invalid column name

Could not execute 'insert into q2 values(1, "You got a second job offer that pays good but not of your interest, while ...' SAP DBTech JDBC: [260]: invalid column name: You got a second job offer that pays good but not of your interest, while the first job offers a less pay but great value to your career, youd: line 1 col 26 (at pos 25)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sebastian Esch Jul 14, 2017 at 10:36 AM
0

To insert String values, you have to use single quotes for the values. Like:

insert into q2 values(1, 'You got a second job offer that pays good but not of your interest')
Share
10 |10000 characters needed characters left characters exceeded