Article View: borland.public.cppbuilder.database.ado
Article #4427Re: Dynamic Cursor
From: Gary Desroches
Date: Wed, 26 Dec 2001 14:48
Date: Wed, 26 Dec 2001 14:48
48 lines
2341 bytes
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-mailReferences:
<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