>Hi all
>I have open connection object and command object which point to the table.I get recordset(rs object variable) like this
>rs = commobj.execute.
>This recordset very limited. I can't add new records to this recordset
>and can't move back.
>But if i use open method of recordset itself i.e rs.open(...) i can
>do everything with this recordset(move back and forward,add and delete
>records).In this case i don't use command object at all.
>What the difference?
Look at the parameters for both functions - they let you specify
the cursor modes. You want to use adKeySet I think for an updatable
cursor.
If you use Connection to create your cursor the rs is imlpicitly
created - if you want full control you should use the objects
individually and assign the appropriate references where necessary.