🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: Dynamic Cursor

#4427
From: Gary Desroches
Date: Wed, 26 Dec 2001 14:48
48 lines
2341 bytes
Ummm, I use bookmarks with my DBGrid as the display all the time with no
problems...
it depends on how its coded

"Tharun Pillay" <tharun@webmail.co.za> wrote in message
news:3c209e59_2@dnews...
>
> 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: <a0cnj0$q4r$1@slb6.atl.mindspring.net>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!cpk-news-hub1.bbnplanet.com!washdc3-snh1.gtei.net!news.gtei.net!news.mindspring.net!not-for-mail
References: <3c1c6c98_2@dnews> <3c209e59_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-26 06:42:03 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!cpk-news-hub1.bbnplanet.com!washdc3-snh1.gtei.net!news.gtei.net!news.mindspring.net!not-for-mail
From: "Gary Desroches" <gcdesroches@mindspring.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: Dynamic Cursor
Date: Wed, 26 Dec 2001 08:48:14 -0600
Organization: MindSpring Enterprises
Lines: 50
Message-ID: <a0cnj0$q4r$1@slb6.atl.mindspring.net>
References: <3c1c6c98_2@dnews> <3c209e59_2@dnews>
Reply-To: "Gary Desroches" <gcdesroches@mindspring.com>
NNTP-Posting-Host: d1.56.36.13
X-Server-Date: 26 Dec 2001 14:41:36 GMT
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200