borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2014 Andrea Tincaniborder

AndreaVB | Forum | News | Downloads | Register | Help | Member List | Statistics | Search | PM | Profile

Print This Topic
Previous Topic (Need help with code)Next Topic (vb 10.0) New Topic New Poll Post Reply
AndreaVB Forum : VB General : problem editing adodb recordset
Poster Message
Bamboozled
Level: Trainee

Registered: 23-12-2009
Posts: 1

icon problem editing adodb recordset

I've created a recordset in VB Express 2008 as follows
rsmembers = New ADODB.Recordset
with rsmembers
            .Source = cn.Execute("SELECT * FROM members")
            .ActiveConnection = cn

            .CursorType = ADODB.CursorTypeEnum.adOpenDynamic
            .LockType = ADODB.LockTypeEnum.adLockOptimistic
            .CursorLocation = ADODB.CursorLocationEnum.adUseServer

            .Open("members", Options:=ADODB.CommandTypeEnum.adCmdTableDirect)
            .movefirst
            .Fields("Active").Value = vbFalse

but the error window tells me that .fields("active") active is readonly. Tried using cursortype as adopenkeyset and tried without the Source property being set as well but same error.

Can anybody tell me how to this please.


____________________________
Billy

23-12-2009 at 04:13 PM
View Profile Send Email to User Show All Posts | Quote Reply
AndreaVB Forum : VB General : problem editing adodb recordset
Previous Topic (Need help with code)Next Topic (vb 10.0) New Topic New Poll Post Reply
Surf To:


Not Logged In? Username: Password: Lost your password?
borderAndreaVB free resources for Visual Basic developersborder
borderAndreaVB Visual Basic and VB.NET source code resources - Copyright © 1999-2014 Andrea Tincaniborder