Article View: borland.public.cppbuilder.database.ado
Article #5408Re: Refreshing data in SQL Server with ADO
From: BM
Date: Thu, 24 May 2001 15:27
Date: Thu, 24 May 2001 15:27
26 lines
1610 bytes
1610 bytes
Try setting the CursorType to ctDynamic - "ctDynamic => Dynamic cursor; data modifications, deletions, and insertions by other users are visible; scrolling forward and back allowed" or use Requery. Carlos <shangri-la@teleline.es> wrote in message news:3b0d1649_2@dnews... > Hi, i have detected several problems using the normal Refresh method of > TADOTable with SQL Servers tables. > > For instance when someone inserts a new record, when we call to Refresh the > new record doesn๏ฟฝt appear. > > The only way i have found to solve this problem is to close and open the > TADOTable, but this method waste a lot of time and CPU resources. > > Someone know other method to solve this question ? > > Thanks. > > > >
Technical Details
Message-ID:
<3b0d2b19_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3b0d1649_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,21d343828e3cd413 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2001-05-24 08:46:11 PST From: "BM" <m02x7z00@cwcom.net> Newsgroups: borland.public.cppbuilder.database.ado References: <3b0d1649_2@dnews> Subject: Re: Refreshing data in SQL Server with ADO Date: Thu, 24 May 2001 16:27:26 +0100 Lines: 28 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 NNTP-Posting-Host: 172.155.206.57 Message-ID: <3b0d2b19_1@dnews> X-Trace: dnews 990718745 172.155.206.57 (24 May 2001 08:39:05 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews