|Updatability with OraOLEDB [message #134799]
||Sat, 27 August 2005 03:55
Registered: August 2005
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"
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.
Would appreciate any help.
[Updated on: Sat, 27 August 2005 03:58]
Report message to a moderator