"Row cannot be located for updating" error

[Nick]

Hi guys,

I am using VB6 SP5, ADO 2.8 and SAPDB 7.4.3.27

I have a table as follows
        CREATE TABLE "DBA"."TBL_USERS"
        (
                "USERID"               Integer    NOT NULL,
                "LOGONID"               Varchar (20) ASCII    NOT NULL,
                "USERNAME"               Varchar (30) ASCII,
                "USERSURNAME"               Varchar (30) ASCII,
                "LASTLOGGEDIN"               Timestamp,
                "LASTCHANGED"               Timestamp,
                "ISACTIVE"               Smallint,
                "XPASSWORD"               Integer,
                "CANEDIT"               Smallint,
                "CANSYSADMIN"               Smallint,
                "LOGGEDIN"               Smallint,
                PRIMARY KEY ("USERID")
        )

I run the following VB code
        Private Sub Command1_Click()
            Dim sSql As String
            Dim ors As ADODB.Recordset

            sSql = "select userid, username from TBL_USERS where LOGONID = 'ND'"
                ' get recordset with LockType= adLockOptimistic,
                ' CursorLocation= adUseClient, CursorType = adOpenDynamic
            Set ors = OpenMeARecordset(goConnection, sSql)
            ors!USERNAME = "fred"
            ors.Update

            Set ors = Nothing
        End Sub

When I run it, I get a "Row cannot be located for updating" error on the
oRs.Update line.

If I switch the cursor to serverside,  I get a SAP error "Syntax error or
access violation; -3014 POS(15) Invalid end of SQL statement".


I am at a complete loss as to what is going on.
Any help would be greatly appreciated!


Cheers,

Nick Damoulakis
[EMAIL PROTECTED]



-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]