🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #4409

Re: Dynamic Cursor

#4409
From: Tharun Pillay
Date: Wed, 19 Dec 2001 14:03
36 lines
1972 bytes
How are you displaying the recordset? If you're using the TDBGrid, that
won't be possible because it doesn't support bookmarks. You can however use
TDBEdits, etc.

Heres what you do if using TADODataSet:

1.    Set the CursorLocation to clUseServer
2.    Set the CursorType to UseDynamic

Something you should note, is that dynamic server side cursors should
generally be used when the recordset is incredibly big and cannot be brought
to the client. Dynamic cursors consume the most resources of all other
cursor types.

Tharun Pillay

"Holger Wiebrock" <Holger.Wiebrock@T-Online.de> wrote in message
news:3c1c6c98_2@dnews...
> Hey
>
> I try to build an app which should use a dynamic Cursor because several
User
> supposed to use the same Recordset. So if somebody makes any changes to
this
> Recordset all the other User have to notice that. Unfortunatley the Driver
> "OLE DB for SQL Server" doesen't support this feature. Any Idea's whether
a
> function exists like "FindFirstChangeNotification" for a Databasetable.
>
>
> Greetings
>
> Holger
>
>
Technical Details
Message-ID: <3c209e59_2@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews
References: <3c1c6c98_2@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,830fbcba6d64592c
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-19 06:09:31 PST
From: "Tharun Pillay" <tharun@webmail.co.za>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3c1c6c98_2@dnews>
Subject: Re: Dynamic Cursor
Date: Wed, 19 Dec 2001 16:03:12 +0200
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 155.239.242.186
Message-ID: <3c209e59_2@dnews>
X-Trace: dnews 1008770649 155.239.242.186 (19 Dec 2001 06:04:09 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!newshub2.rdc1.sfba.home.com!news.home.com!newsfeed.mesh.ad.jp!osa.uu.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews