I seem to have passed the original value in this post previously by inputing it as an second value in dbr.editable. link
I added a second value to mydbr.editable, and also to the update procedure and ran the report and received this error from my dbr. (invalue was the second input in procedure and before this change would receive the new value) sorry that was a missing comma.
Edit report 'sp_DBR_update_NetworkNumber' requires parameter 'invalue', which was not supplied. Column 0 will not be editable.
It works by passing another value in the
select 'dbr.editable'. and adding that parameter to the update procedure. Note invalue seems to be the name assigned to the new value passed to the update procedure by mydbr.
1. i need to read up on how to update/interact with the user as i haven't done that before.
2. as it can be a long text feild they are editing i would like to give them a way to get the edited data before it is discarded, a popup report would work but not sure i can call that from a update proceudre......
3. also would be cool to load the current data from db to the field they just edited so they don't need to reload the whole report to get the current data.