Article View: borland.public.cppbuilder.database.ado
Article #4409Re: Dynamic Cursor
From: Tharun Pillay
Date: Wed, 19 Dec 2001 14:03
Date: Wed, 19 Dec 2001 14:03
36 lines
1972 bytes
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!dnewsReferences:
<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