Article View: borland.public.delphi.database
Article #228ROWSET SIZE - DUPLICATE RECORDS
From: pfinster
Date: Tue, 28 May 2002 17:21
Date: Tue, 28 May 2002 17:21
20 lines
1744 bytes
1744 bytes
Hi I have an unsupported application that uses BDE Administrator 5.0 connecting to a Personal Oracle 8 database and has ODBC connections to Progress databases. When querying a table in the Oracle database via BDE the records are returned twice. If I look at the table through the Oracle Navigator, the correct number of records exist and if I query the table using Oracle SQLPlus, the correct number of records are returned. It doesn't do this all the time and I have yet to determine a pattern, although I am told this is seen more frequently lately. I was grasping at straws by changing the ROWSET SIZE from 20 to 40, but it seems to have resolved the issue. Why? Can I always rely on this? What is the best solution? Regards Ken
Technical Details
Message-ID:
<d0PI8.2$D%4.83@newreader.ukcore.bt.net>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!btnet-peer!btnet-peer0!btnet-feed5!btnet!newreader.ukcore.bt.net!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 115d96,2c28fdd615affc75,start X-Google-Attributes: gid115d96,public X-Google-ArrivalTime: 2002-05-28 10:21:18 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!supernews.com!telocity-west!TELOCITY!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!btnet-peer!btnet-peer0!btnet-feed5!btnet!newreader.ukcore.bt.net!not-for-mail From: "pfinster" <pfinster@altavista.co.uk> Newsgroups: borland.public.delphi.database Subject: ROWSET SIZE - DUPLICATE RECORDS Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 Message-ID: <d0PI8.2$D%4.83@newreader.ukcore.bt.net> Date: Tue, 28 May 2002 17:21:13 GMT NNTP-Posting-Host: 217.33.24.98 X-Trace: newreader.ukcore.bt.net 1022606473 217.33.24.98 (Tue, 28 May 2002 18:21:13 BST) NNTP-Posting-Date: Tue, 28 May 2002 18:21:13 BST