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
This sounds like you might be compiling against a slightly different DB Schema than what PS is using. A different DB instance or even DBMS instance or the PS DBMS / DB is the same but the DB login user in PS has different schema privileges. Food for thought. HTH
Regards ... Chris