cursortypes and other ad-constants

Results 1 to 2 of 2

Thread: cursortypes and other ad-constants

  1. #1
    gideon isaac Guest

    Default cursortypes and other ad-constants

    I keep seeing ASP code such as:<BR>rsTemp.Open sql, DBConn, adOpenKeyset, adLockOptimistic, adCmdText.<BR>I&#039ve seen explanations of the last 3 constants (and their alternatives, but I don&#039t understand them. The cursor types make sense - at least static and forward-only make sense. But when do you use adLockOptimistic vs adLockPessimistic vs other types of locks? And Is adOpenKeyset/dynamic useful at all, given the fact that asp pages cannot be refreshed?

  2. #2
    Join Date
    Dec 1969
    Posts
    2,849

    Default RE: cursortypes and other ad-constants

    Good questions, all of them!<BR><BR>There are some helpful articles on 4Guys to help answer your questions:<BR><BR>Cursor & LockType Performance Issues<BR>http://www.4guysfromrolla.com/webtech/062799-3.shtml<BR><BR>Choosing the Right Cursor for the Job<BR>http://www.4guysfromrolla.com/webtech/112998-1.shtml<BR><BR>Happy Programming!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •