invalid column name : sap hana

[Former Member]

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)

[SebastianEsch]

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')