Re: Cursors - Server Side - Only Forward?

From: Gerard (anonymous_at_discussions.microsoft.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 06:06:32 -0800

Karl,
   Yes, I see. But... and there's always a but, My
connection object(Dbs) doesn't have .CursorType as a
property, and when I just type it in despite the
intellisense saying its not there, I get a runtime error
saying "Object doesn't support named arguments". When I
assign .CursorType on the recordset object, the value
doesn't hold after the object is set to a recordset.
After assigning the recordset object a recordset via the
Set statement, the value I have set the .CursorType
property to doesn't persist, and it reverts back to a
value of 0. In the project I am referencing the ActiveX
Data Objects 2.8 Library and the ActiveX Recordset 2.8.
Hope you can shed some light, thanks in advance,

Gerard
Gulf Management Systems
Programmer / Processor

>-----Original Message-----
>Hi Gerard,
>
>You're using VB's ADO.Recordset object to manipulate the
cursor data. The
>default cursor type for a ADO.Recordset is adForwardOnly.
If you set it to
>adOpenDynamic, you should be able to navigate the cursor
any way you want.
>Add the following code to you app just after the
statement where you set the
>cursor location:
>
>Dbs.CursorType = adOpenDynamic
>
>Also have a look here:
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/ado270/htm/mdprocursortype.asp
>
>--
>Karl Gram, BSc, MBA
>http://www.gramonline.com

Relevant Pages

  • Re: Gebundene Controls aus ADO-Recordset aktualisieren
    ... Engpass ist vor allem das LAN und der Server selbst. ... ob man mit einem SQL-Server oder der Jet-Engine ... Cursor und statischen Recordsets, egal welches Datenbanksystem ... dass eine Bewegung im Recordset eben auch ...
    (microsoft.public.de.vb.datenbank)
  • Re: Gebundene Controls aus ADO-Recordset aktualisieren
    ... Wozu ein serverseitiger Cursor? ... Ich kann also z.B. bei adOpenKeyset im Programmcode ... CursorLocation adUseServer bei Access sinnlos, ... wenn Du in Deinem Recordset zu einem anderen ...
    (microsoft.public.de.vb.datenbank)
  • Re: Suche mit SEEK
    ... ein Recordset mit serverseitigem Cursor ... Das heisst also es muss ein Recordset mit serverseitigem Cursor ... clientseitigem Cursor arbeiten und die Suche nach einem bestimmten Datensatz ...
    (microsoft.public.de.vb.datenbank)
  • Re: How to summarize recordset...Select Distinct alternative?
    ... functionality to store a set of paired values ... then the recordset is copied into local ... ADO provides a Cursor Library that provides the cursor ... reconnected to the database simply by setting the ActiveConnection to an ...
    (microsoft.public.data.ado)
  • Re: CursorType, LockType von ADO-Recordsets
    ... Use the CursorType property to specify the type of cursor that should be used when opening the Recordset object. ... If an unsupported value is set, then no error will result; the closest supported CursorType will be used instead. ...
    (microsoft.public.de.access.clientserver)