Error of any update /edit database sql

[anonymous]

Allways I get this error:

Error:
“Unable to add/edit/delete row in table ‘dbo.RutasyOTSyServicios10d’. → One or more SQL errors has been encountered: One or more SQL Server errors has been encountered:\nThe column you are trying to modify is a derived or constant field and thus cannot be modified.\nOriginal error message from the database: Update or insert of view or function ‘dbo.RutasyOTSyServicios10d’ failed because it contains a derived or constant field.”

Please I need help

[Steve]

Francisco_Laborda:

The column you are trying to modify is a derived or constant field and thus cannot be modified.

This means that one of the columns in your SQL database that the app is trying to modify does not allow modifications. You will need to either: (1) reconfigure your app to not attempt to modify the column; or (2) reconfigure the database to allow the modification. If (1), consider contacting support@appsheet.com directly for help. If (2), contact your database administrator.

[anonymous]

Hi Steve, Sorry I m not able to add a new question , and I need help , I¡im getting the message
Table does not allow new entries when the user just updates a row in a simple UPDATE SLICE, May you help ?
See attached

thanks

[hru]

Have you check your slice update mode to allow adds?

and check table Are_Update_allowed?:

[anonymous]

Hi Heru
I just want that UPDATES will be allowed , We don’t want the users adding news rows, just updating
Sorry if I didn’t explain it correctly
Thanks

[hru]

It seems, I don’t understand your question, however, if the requirement is only to allow Updates, than you can specify with the slice update mode :

Or in the Are_Update_allowed? in the table.

To do that, you can just click again the “Adds” or the “Deletes” ?

[Steve]

How did the user arrive at this view?

If by a LINKTOFORM() action, that’s your problem: LINKTOFORM() always tries to add a new row. Use LINKTOROW() instead to open the form view of an existing row.

See also:

[anonymous]

Hi Steve,
Thanks this was the issue, I changed the detail view to allow updates.
Kind regards.

[anonymous]

Hello, I have an app that is now giving me this error. The data source is Azure SQL Database, there are no errors generated in Azure

[Steve]

JNGIDS:

I have an app that is now giving me this error.

Please post a screenshot of the error.