query unit sql not woking

14 Jul '20, 07:53 PM
18,492 Views
No Forum Badges

hi 

I have a schema called named movie and I have a table called movie inside of it, I want to update a field in the table movie, called rating using SQL. I tried every version that I think it might work but it is not working can you help me?

update movie set rating = 37 where movieid = 1;

 
x 0
Follow
Answer Answer at this question and get points!
Forum Hero - Level 9

Hi Rozhan,

you can try to see this guide: https://my.webratio.com/learn/learningobject/getting-started-with-the-query-unit.

For example the problem could due to a wrong query definition (wrong management of schema and table name prefixes in the query) or to a syntax error (refer to the specific dbms in use). Moreover you can write a query in SQL or in HQL but these languages adopt different syntaxes. For details refer to https://my.webratio.com/learn/learningobject/how-to-use-hibernate-in-a-custom-component-v-72.

Anyway to perform operations like INSERT, UPDATE, DELETE, etc, you can refer to standard components (Create, Modify, Delete, etc) instead of Query Component. You can find related guides in the Learn section https://my.webratio.com/learn.

I hope this will help you.

Regards,

 
x 0
Answer at this question and get points!