ClientBatch with Update method, error 40041 
Author Message
 ClientBatch with Update method, error 40041

Can someone explain why I get error:
         40041        Object Collection: Couldn't find item indicated by text.
when the UPDATE statement is executed.  The information is placed in the
rdoErrors collection.
The update works, but I would like to better understand what is going on.

Sub main
    Dim cn As New rdoConnection
    Dim rs As rdoResultset
    Dim col As rdoColumn
    Dim re As rdoError

    ' configure the connection
    With cn
        .CursorDriver = rdUseClientBatch
        .Connect = "DRIVER={SQL Server};SERVER=DFWCSCQ1;database=quotes"
        .EstablishConnection rdDriverNoPrompt, True
        ' clear messages
        rdoEngine.rdoErrors.Clear
    End With

    Set rs = cn.OpenResultset("exec QuoteHeaderByQuoteNo 10179",
rdOpenDynamic, rdConcurBatch)

    ' identify source of fields
    For Each col In rs.rdoColumns
        col.SourceTable = "Quotes.dbo.QuoteHeaders"
        col.SourceColumn = col.Name
    Next

    ' identify the key column
    rs.rdoColumns("QuoteNo").KeyColumn = True

    If Not (rs Is Nothing) Then
        rs.Edit
            rs.rdoColumns("VersionNo") = 99
        rs.Update                                               ' error is generated here
        rs.BatchUpdate

        rs.Close
    End If

    cn.Close
end sub

Thanks,

Harold



Mon, 20 Mar 2000 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Error 40041 Object Collection: Couldn't find the item indicated by text

2. RDO run time error "40041"

3. VB 5/6 runtime error 40041 when accessing stored procedures using RDO

4. Error 40041 Object Collection Couldn't find item indicated by text

5. URGENT: VB5 /6 Runtime error 40041 when accessing stored procedures using RDO

6. VB4 and DAO 3.6 Update method Compile Error

7. Error 405(Method not allowed) error in using webclient.uploadfile method

8. Update method error

9. Application-defined error 3315 during table.Update method

10. Update method causes untrappable error.

11. CDO Update method errors

12. Database error during update-method: 3426

 

 
Powered by phpBB® Forum Software