
Multiple-step operation generated errors. (Delete Error)
All that means is that for that line of code to execute, multiple operations
had to occur and VB was unable to keep track of the error for you. Usually
this is caused by a type conversion problem but because you are deleting a
record, this is not the case. One possibility is that you are trying to
delete a parent record with child records still existing or are attempting
to violate some other constraint. In any case you have a couple of options.
1. Break down the statement into several statements, each of which only
accomplishes one task. Remember a statement like,
sMyVariable = rs.Fields!FieldName, does not do just one thing, but this
is the max that should be accomplished on one line
while troubleshooting.
2. You can enumerate the Errors collection to try to find out what
problem(s) occurred. Do something like this:
Dim adoErr As ADODB.Error 'No "s" on the end, you want the
Error object not the Errors collection
For Each adoErr in cn.Errors
MsgBox adoErr.Number & " " & adoErr.Description
Next
regards,
ed
Quote:
> I am using an ADO data control and when i execute the command
> adodc1.recordset.delete it generates the following error:
> i get this error Multiple-step operation generated errors. Check each
status
> value.(err No -2147217887)
> Any sugestions?
> Thanx in advance