cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Updating Table values

Former Member
0 Likes
275

Hello Experts,

I have came across a scenario wherein i need to update the values of some column of existing table on the basis of joins from another table.

Is it possible to achieve the same via Stored procedure and call it via SQL script Calculation view?

As far as i am aware, in Calculation view we cannot call the procedures which is using update/insert statement.

Is this true??

Wanted to be sure before i build my data model using Graphical calculation View.

View Entire Topic
pfefferf
Active Contributor
0 Likes

Correct, you cannot call write enabled procedures/functions in a calculation view.

Former Member
0 Likes

Thanks Florian...So the only way to achieve it is via Graphical calculation view?