dubt on cursor effect....

User avatar
sal21
PlatinumLounger
Posts: 4370
Joined: 26 Apr 2010, 17:36

dubt on cursor effect....

Post by sal21 »

Generally i open a recordset with:

'serires of setting cursor (locktypy, cursorlocat...ecc)

rs.open sql, conn
or
rs.open sql,,cursor..,cursor..., conn

if i use:
'serires of setting cursor (locktypy, cursorlocat...ecc)

set rs=conn.execute sql

i can use the same setting of cursor before to execute the execute statement,? have effect? or the SET rs not consider the cursor setting?

User avatar
HansV
Administrator
Posts: 78627
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: dubt on cursor effect....

Post by HansV »

It should make no difference.
Best wishes,
Hans