MoveFirst causes a requery

Results 1 to 2 of 2

Thread: MoveFirst causes a requery

  1. #1
    Jonathan Brune Guest

    Default MoveFirst causes a requery

    I&#039m having a problem using a stored proc on an SQL database. Whenever I call MoveFirst the stored proc is run again. I have set the cursor type to static, shouldn&#039t that preclude it from having to go back to the database?<BR><BR>Here&#039s a code snippet:<BR>&#060;%<BR>ConnString = "Driver={SQL Server};;" &_<BR> "APP=xxx_xxx;WSID=xx_xxxx;Database=xxx_xxx;"<BR>cn .Open ConnString,"xx","xx"<BR>cn.CommandTimeout = 90<BR> <BR>SET rsData.ActiveConnection = cn<BR>rsData.Open SQL,cn,adOpenStatic,adLockOptimistic,adCmdText<BR> %&#062;<BR><BR>Any help would be greatly appreciated.<BR><BR>-Jonathan Brune<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: MoveFirst causes a requery

    Try using adOpenDynamic instead of adOpenStatic.<BR><BR>Are you going to be updating this recordset? If not, perhaps you should replace the adLockOptimistic with the adLockReadOnly parameter.<BR><BR>Cheers<BR>Matthew

Posting Permissions

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