>>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?
>
>You might want to try a different type of cursor, like a client side static one: Cursorlocation = 3 (adUseClient), CursorType = 3 (adOpenStatic).

I use Cursorlocation = 3 (adUseClient), CursorType = 3 (adOpenStatic), and I can change the values, however the only syntax I use is with zero-based field index, ex:
? ors.fields(0).value
or ors.fields(1).value = "someval".
This works, however, the movenext and other pointer move methods will call the update and actually change the values on your source table. Be careful if you're not looking for that, ie: if you just want something like a disconnected VFP cursor that you can change values on and dump without affecting the source. I haven't figured out how to do that yet with ADO.