Re: ADO error setting filed when using oralce hint in sql select
From: Val Mazur (group51a_at_hotmail.com)
Date: 07/21/04
- Next message: Val Mazur: "Re: Determining version of MDB file"
- Previous message: Val Mazur: "Re: establish a connection"
- In reply to: Mark Fisher: "ADO error setting filed when using oralce hint in sql select"
- Next in thread: Mark Fisher: "RE: ADO error setting filed when using oralce hint in sql select"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 21 Jul 2004 19:31:37 -0400
Hi Mark,
What does hint do in a case of Oracle? do you get some sort of a
concatenated field value? If yes, then you cannot edit
concatenated/calculated values. It is a restriction by-design and these
columns are always read-only
--
Val Mazur
Microsoft MVP
"Mark Fisher" <Mark Fisher@discussions.microsoft.com> wrote in message
news:3F638C00-9033-4626-9265-A094D2C77FBD@microsoft.com...
> 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
>
>
- Next message: Val Mazur: "Re: Determining version of MDB file"
- Previous message: Val Mazur: "Re: establish a connection"
- In reply to: Mark Fisher: "ADO error setting filed when using oralce hint in sql select"
- Next in thread: Mark Fisher: "RE: ADO error setting filed when using oralce hint in sql select"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
