Which cursor type should I use ?

gop373 · #1 (**permalink**) 01-20-05, 08:36

I use ASP to program my web and I need to insert , update, and delete data in microsoft access. Which cursor and lock type should I use and why ???

Should I use rs.open sql,conn,1,3 ?

gyuan · #2 (**permalink**) 01-20-05, 10:33

The following article may give you a help.

http://www.w3schools.com/ado/prop_rs_cursortype.asp

http://www.w3schools.com/ado/prop_rs_locktype.asp

Bullschmidt · #3 (**permalink**) 01-21-05, 02:26

And:

Cursor & LockType Performance Report - 6/27/1999
http://www.4guysfromrolla.com/webtec...3.report.shtml

Cursor & LockType Performance Issues - 6/27/1999
http://www.4guysfromrolla.com/webtech/062799-3.shtml

Recordset Cursors: Choose the Right Cursor for the Right Job - 11/29/1998
http://www.4guysfromrolla.com/webtech/112998-1.shtml

Internet Services

Web Development

Digital Marketing

Consumer Tech