Cannot edit in browser

[SpringBox]

Hi guys

Browser testing latest app. We can add and delete records but any attempt at editing result in :


Update failed - record could not be updated.

and the following browser error :

PUT http://localhost:8001/odata/pdsw/cust?_v=102 404 (The requested page was not found)

jquery-1.10.2.min.js?_v=7.2Beta11.1129-1648218234566:6

App deployed
database = pdsw
local table = cust
30 records
All called server side procs disabled


Also the display is not in indexed order as it is on desktop.

Could this be something to do with the fact that we have to call the app twice from the "preview in browser" button? 1st press we always get the app center which is blank if we log in. Leave that open and next press will open the app in browser

Any thoughts?

Cheers

Simon

[yvonne.milne]

Hi Simon,

Does that table have update triggers? If so, check that there is nothing in the code that is invalid for client/server.

For the blank App Center, check the App Center Tile properties for your App - may be something there that is causing a problem. Recently had an issue where there was a non-printable character in the specified icon filename that did this.

Regards,

Yvonne

[SpringBox]

Hi Yvonne

Done lots more testing and chopped up app again to simplify it to see if we can pinpoint erratic behavour.

Update triggers removed (we know how to do that now) and all prg/dbo files deleted from disk too for good measure.


OK - we can edit fields that already have something in them ie not blank but any field that is currently blank will not take the edit and returns the same error. This applies to both numeric fields and character fields.

Looks like a bug but open to suggestions

How do we go about diagnosing this one?

Thanks in advance

Simon

[barrymavin]

Turn ODATA tracing on in the server manager and look in the debug directory for odata_debug files.

Is that a native lianja table or an oledb VT to a VFP table?

If its the latter check what NULL constraints you have specified.

[SpringBox]

Hi Barry

This edit issue is with a native Lianja table. It sounds like some sort of NULL value issue.

Have emailed the debug files to you.

Thanks in advance


Simon

[barrymavin]

Hi Simon

Close the app.

open the database

use The table

list dictionary

You say you have triggers so look in the database in the cloudserver directory and compare with what you have in the development database.

Look in the odata trace files

Copy the update statement and try it in the console.