I have a datastore update that works fine running through the IDE but fails on the Web. It gives no error. I've run through the debugger and get the same....
if ids_customerproductdata.Update(TRUE, FALSE) <> 1 then
A database error has occurred.--
Object : n_busobj_customer
Database error code: -1
Database error message:
No changes made to database.
I had this once before and fixed it by recreating the datastore. Now I have it on another one. This is code migrated from a 20+ year old app.
Any ideas?
Thanks
Jay
All I get is SQLDBCODE = -1
SQLERRORTEXT says "No changes made to database."
SQLSYNTAX is empty
I tried limiting the number of updatable columns to just a few but still no luck.
Thanks...Jay