Error of any update /edit database sql

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

0 9 1,055
9 REPLIES 9

Steve
Participant V

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.

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

Have you check your slice update mode to allow adds?

and check table Are_Update_allowed?:

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

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” ?

How did the user arrive at this view?
2X_d_d4b382aae074b27d80eefce5deb61e252b481d15.png

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:


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

JNGIDS
Participant II

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

Please post a screenshot of the error.

Top Labels in this Space