ADO error setting filed when using oralce hint in sql select

From: Mark Fisher (Fisher_at_discussions.microsoft.com)
Date: 07/21/04 

Date: Wed, 21 Jul 2004 03:15:02 -0700

When using an oracle hint, the first field in the select clause becomes not editable...if you try to edit it you get error "-214717887 multiple step operation caused error. Check status of each field"

without the hint all is fine.

with the hint all fields other than the first field are also fine. Any ideas how to resolve?

skeleton sample code:

DIM rsCmd As ADODB.Recordset
DIM rsRet As ADODB.Recordset
Dim cmd As ADODB.Command
    
    
   With cmd
       Set .ActiveConnection = moConn

       cmd.commandtext = "SELECT /*+ RULE */ CODE_ID, CODE FROM CODE WHERE 1 = 0"
                
       Set rsRet = New ADODB.Recordset
        
       With rsRet
           .CursorLocation = adUseClient
           .Open cmd, , adOpenStatic, adLockBatchOptimistic
           Set .ActiveConnection = Nothing

           .Addnew

       End With
        
       Set .ActiveConnection = Nothing
   End With

   rsRet("CODE") = "XYZ" 'ok
   rsRet("CODE_ID") = 1 'generates the error

Relevant Pages

  • RE: ADO error setting filed when using oralce hint in sql select
    ... > with the hint all fields other than the first field are also fine. ... > DIM rsCmd As ADODB.Recordset ... > Dim cmd As ADODB.Command ...
    (microsoft.public.data.ado)
  • Re: Multiple Records (CREATION)
    ... I should mention that I'd inherited this application designed in VBA and I am just trying to redo the application completely in Access since that is what I am more familiar with and this will allow better maintenance of the application. ... the job Title is a combo box that displayed the job title but it was the first field in the underlying combo query. ... The Schedule and Shift controls are also combo boxes which display the second field of the underlying query, but it is the first fields in this combo that needs to go into the table. ... Dim rst As DAO.Recordset ...
    (microsoft.public.access.modulesdaovba)
  • Re: Userform for data pull
    ... In the first field, I enter my criteria. ... > field and I get an error msg saying runtime error 424, ... > Private Sub FindButton_Click ... > Dim x As Range, ...
    (microsoft.public.excel.programming)
  • Cant read the first Field of an Excel Spreadsheet....
    ... I am using the code below to read an Excel spreadsheet and process the data. ... Unfortunately it just misses off the first field. ... Dim dr As SqlDataReader ... Dim drExcel As OleDbDataReader ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Userform for data pull
    ... In the first field, I enter my criteria. ... | field and I get an error msg saying runtime error 424, ... | Private Sub FindButton_Click ... | Dim x As Range, ...
    (microsoft.public.excel.programming)