Recordset - default cursor type

[emozley]

Hi,

If I create a recordset with:

rsUsers.Open strSQL, adoCon

and I've not specified the cursor type, which one will it default to? If I want to make it forward only what is the syntax?

cheers

 

[QatQat]

if you include the file adovbs.inc then
here is the syntax

RS.Open strSQL, adoConn, adOpenForwardOnly, adLockOptimistic


otherwise

RS.Open strSQL, adoConn, 0, 3


By default I think it creates

RS.Open strSQL, adoConn, adOpenStatic, adLockOptimistic

or

RS.Open strSQL, adoConn, 3, 3


cheers

QatQat

Life is what happens when you are making other plans.

 

[DotNetGnat]

http://www.4guysfromrolla.com/webtech/112998-1.shtml

-DNG

 

[Bullschmidt]

And here's a related article:

Cursor & LockType Performance Report - 6/27/1999

http://www.4guysfromrolla.com/webtech/062799-3.report.shtml

Best regards,
-Paul

http://www.Bullschmidt.com

- Freelance Web and Database Developer

http://www.Bullschmidt.com/DevTip.asp

- Classic ASP Design Tips