>Actual error message is: 3251, object or provider is not capable of performing requested operation. I do not need to edit the Oracle, just the recordset so report shows more info. Thanks.
>
>>I've asked this in other forums and not getting response.
>>
>>So, I am using Oracle with ADO open method inputting the params for optimistic, dynamic cursor. The data is there, but I need to edit four fields before printing a report.
>>
>>rstWO!user_1="aaa"
>>nor
>>rstWO.fields("user_1").value="aaa"
>>work to change the data, as I get error something like:
>>'task can't be accomplished'
>>then I would do an:
>>rstWO.update if I got past the edit line.
>>
>>Any ideas?
I found while using a dynaset that I could not edit a field that contained a NULL, nor would the dynaset.UPDATE work. That is why I used dynasets to load and scroll records but call PARAMETERS.ADD, etc., to communicate to a stored procedure. Then refresh the dynaset. YMMV.
Nebraska Dept of Revenue