try running your sql statement in sqlplus against his data. *Nearly* always
you'll find duplicate rows. Of course then you have to work out why. This
first step however will tell you if there are or are not duplicate rows.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
<lorenz_at_k2it.de> wrote in message news:01c215ff$799d7040$4f11a8c0_at_pc79...
> Hello,
>
> i have a little Problem with Oracle in a Delphi-Application. In his
> Environment, a Customer claims to see duplicate Rows in a Delphi-DB-Grid.
> The Customer has an Oracle 8.1.6-Server running on AIX. The Client is also
> 8.1.6.
> In my Test-Environment (Oracle 8.1.6-Server on Linux or Oracle 8.1.5 on
> WinNT4), i can not reprodruce this effect. I've tested the Oracle Client
> 8.1.7 and 8.1.5 (with both servers, everything's just fine). I do not have
> the 8.1.6-Client available here.
> The Delphi-Application is written in Delphi 5, using BDE 5.1 (or 5.2,
tried
> that too) and SQL-Links. There are some hints from Borland (i.e.
> ROWSETSIZE=0), but the customer say's these won't help.
> Has anybody got any idea what's going on or how to avoid this effect?
> Thank's for every hint.
>
> Greetings from Germany,
> Thorsten
>
> E-Mail: lorenz_at_k2it.de
>
Received on Mon Jun 17 2002 - 15:30:03 CDT
