Hi!

How i can get the recordcount of a updateable table in ado with
serverside-cursors? Is "OpenDynamic/LockOptimistic" usable?

example:

        strSQL = "select * from tableName where IDCol=" & ueIDcol    '
Select single line
        rs.Open strSQL, cndb, adOpenDynamic, adLockOptimistic
        If rs.RecordCount > 0 Then
            rs("col1") = value1
            ...
            ...
        rs.Update
        End If
        rs.Close

   This fails, it uses clientside-cursors and the error is "table
unknown"(?!) The error occors on update statement.

If i set the cursor location to server-side before the recordset is open,
then recordcount is erverytime -1.

Whats wrong?

Regards
Hagen Schloemer



_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general

Reply via email to