Re: Error of any update /edit database sql

Francisco_Labor · 12-04-2019 10:21 PM

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

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.

Francisco_Labor

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

Francisco_Labor

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.