Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Database table in Web dynpro

Hi All,

I am trying to use a database table in Web Dynpro. For this, o already created and deployed a dictionary project and one database table in that project. In my web dynpro project when i am accessing this table columnname it works fine, but its not allowing to insert the data.It is giving following error:

The SQL statement "INSERT INTO "TMP_2" ("NAME") VALUES ( "ASDFGH") " contains the semantics error[s]: - 1:36 - the column >>ASDFGH<< is undefined in the current scope where NAME is my column name.

Also when i change some column name or add one more column to my table and then deploy it. After this, when i run my web dynpro project it doesn't show the updated column name and column count.

Please help.

Regards,

Chirag Aneja

replied

hi

Instead of double quotes use single quote for column field.

INSERT INTO "TMP_2" ("NAME") VALUES ( "ASDFGH")

insert into <tablename>(Name) values('ASDFGH').

proceed with createstatement also.

Regards

sowmya.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question