Want to update single record in Rest Api Expose method, tried 2 methods first is update method (POST) of entity and then tried with SQL Aggregate.
After Update Try adding commit transaction server action
Hi Priyanka,
The error message is self-explanatory. You use a variable mi which is not an input parameter to your advances SQL not is it a column name. If the name column needs to be filled with the text 'mi' then you need to enclose the text in single quotes.
Regards,
Daniel
hi Daniel I tried using following query. update {Product} set {Product}.[Name]='mi' where {Product}.[Id]=31
when I test the query it is showing Query returned no rows.
Well that is correct, an update query does not return rows, it updates a record, in your case the record with Id 31, assuming that record exists.
In entity it is not getting update
How do you call the SQL statement? It will not work from the SQL editor, those changes are not committed.
You can change the SQL query as shown below or you can make use of input variable which stores name value and use the variable value instead of passing "mi" text
update {product} set {product}.[Name] = "mi" where {Product}.[Id]=32
Hidayat
Hi Hidayat
I tried using following query. update {Product} set {Product}.[Name]='mi' where {Product}.[Id]=31
Thank you Hidayat. Got the Solution