Mar 30, 2006 08:05 AM|Wombleuk|LINK
OK, went back to basics and recreated the page from scratch (not using copy & paste from the old one) and..... it worked.
There must have been some corruption of the old page somewhere.
So, I formatted the grid a bit to make it look better; hid some fields etc. and got on with some testing.
I then found that certain fields were being wiped out during an update.
It turns out that it was the invisible fields !!! If a field is not visible, gridview doesn't update it; actually no. If that were the case, it would be OK, but it actually nulls the field out!.
I tried removing the fields from the update statement and update parameter list and guess what - I got the ORA-1036 error again. Yet everything matched up.
I then tried to refer to the field with the original_ prefix, after making sure it was defined (
and again got the ORA-1036 error.
Is this flaky or what ?
Of course, it's not likely to get fixed as I can't see anyway of feeding this back to MS except via these forums and it's quite apparent that no-one from MS ever comes here.
Really makes you glad you did the right thing and paid for it, doesn't it?