Home » Infrastructure » Windows » Updatability with OraOLEDB
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

Previous Topic: Problem in the installation of Oracle 9i on Windows 2000 server
Next Topic: Rsf73.map(0) error when intalling Developer 6i on Win XP Professional Edition (merged threads)
Goto Forum:
  


Current Time: Tue Dec 07 01:24:17 CST 2021