| Updatability with OraOLEDB [message #134799] |
Sat, 27 August 2005 03:55 |
stayi
Messages: 8
Registered: August 2005
|
Junior Member |
|
|
OraOLEDB documentation states:
Rowsets that are created using queries with JOINs are not updatable by Oracle Provider for OLE DB. However, these rowsets could be made updatable for ADO users by specifying CursorLocation as adUseClient.
But I am not able to update queries with JOINs even using a client side recordset.
Dim cn As New ADODB.Connection
Dim rsDtl As New ADODB.Recordset
Dim sSQL As String
sSQL = "SELECT DSP_SKU "
sSQL = sSQL & " FROM A LEFT OUTER JOIN B ON A.A1 = B.A1"
sSQL = sSQL & " WHERE A.A1 =90007252"
cn.ConnectionString = "Provider=OraOLEDB.Oracle;Password=XXX;User ID=XXX;Data Source=XXX"
cn.Open
rsDtl.CursorLocation = adUseClient
rsDtl.LockType = adLockOptimistic
rsDtl.Open sSQL, cn
rsDtl.Fields("DSP_SKU") = "1" ' Fails here: Multiple-step operation generated errors. Check each status value.
MsgBox rsDtl.Fields("DSP_SKU")
Would appreciate any help.
Thanks.
[Updated on: Sat, 27 August 2005 03:58] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
