ADO 2.7: Multiple-step operation generated errors

I'm receiving "Run-time error '-2147217887 (80040e21)': Multiple-step
operation generated errors. Check each status value." when attempting to set
a value in a field:

rs.Fields("MyField").Value = 0

I'm fairly certain I know what's causing this error. The column that this
field comes from is a constant value in the query, e.g. SELECT 0 As
MyField, ..., ..., ... FROM MyTable, so the dynamic properties
BASETABLENAME, et. al. are all blank.

The scenario in our application is this: The data is loaded into a
RecordSet and then disconnected. The app never intends to update the
database from this particular recordset but does want to change values in
the recordset just in-memory.

So my question is this: Is there any way to alter the record set schema to
allow me to change the value in a field that has no back-end reality? When
I open the recordset is there a way to say "don't bring any of the back-end
schema along because I don't want any smart validation"?

Thanks,
Mike



.

Relevant Pages

  • Re: access crashing after filter
    ... You have the Debug.Print line after the line that is causing the problem. ... What happens if you comment out the line that is causing the crash? ... using an ADO recordset and SQL server, the definition of variables (we can't ... recordset without specifically applying the filter. ...
    (microsoft.public.access.forms)
  • Re: OLE error 80040200 when assigning events of a TCustomADODatasetpointingto a multi-select stored
    ... are you saying calling EnableEvents after open is a valid approach? ... all properties should be set on initial recordset before Open. ... > characteristics of the stored procedure that is causing the multiple ... > declare @Temp int ...
    (borland.public.delphi.database.ado)
  • RE: Cannot edit form
    ... It is definately the form that is causing the problem! ... The macro and table are fine. ... Recordset defined as Dynaset? ... > may be a conflict between the filter code and the ...
    (microsoft.public.access.forms)
  • KB832483 Problem
    ... Security patch install I believe is causing a problem when I return a recordset on an ASP page. ...
    (microsoft.public.sqlserver.server)