adOpenDynamic on a Recordset

Results 1 to 2 of 2

Thread: adOpenDynamic on a Recordset

  1. #1
    Trevor Daniel Guest

    Default adOpenDynamic on a Recordset

    Hi,<BR><BR>I have written a stored proceedure that works fine. I want to open it adOpenDynamic so i can go back and forward through the recordset. <BR><BR>Can this be done?<BR><BR>I just can&#039t get the syntax correct to produce the correct type of recordset can anyone help?<BR><BR>many thanks<BR>Trevor

  2. #2
    Join Date
    Dec 1969

    Default RE: adOpenDynamic on a Recordset

    You probably don&#039t really want to use adopendynamic (for performance and scalability reasons), but if you do...<BR><BR> mystoredproc, cn, adOpenDynamic, adLockOptimistic, adCmdStoredProc (, 2, 3, 4 if you&#039re not using<BR><BR>Do you need to do updates, or just scroll?

Posting Permissions

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