Cursors and stored procedures

Results 1 to 2 of 2

Thread: Cursors and stored procedures

  1. #1
    Loke Guest

    Default Cursors and stored procedures

    What happens when I use a stored prodedure that returns a record set - what type of cursor will it have (default) ?<BR><BR>The following codes works, but Im not sure wether the recordset gets the cursors I have assigned it.<BR><BR>Set objCmd = Server.CreateObject("ADODB.Command")<BR>objCmd.Com mandType = adCmdStoredProc<BR>objCmd.CommandText = "sp_getLatestNews"<BR>objCmd.ActiveConnection = Application("DB")<BR><BR>Set objRS = Server.CreateObject("ADODB.RecordSet")<BR>objRS.Lo ckType = adLockReadOnly<BR>objRS.CursorType = adOpenForwardOnly<BR><BR>Set objRS = objCmd.Execute

  2. #2
    Join Date
    Dec 1969

    Default RE: Cursors and stored procedures

    adOpenForwardOnly - default

Posting Permissions

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