Delphi 2<->Oracle 7.2.3 : "Multiple records found only one expected" ?!

From: Alan MCCulloch <amccullo_at_ccu1.auckland.ac.nz>
Date: 1997/11/30
Message-ID: <65r9n1$1ho$1@scream.auckland.ac.nz>#1/1

My application works well except for a very annoying intermittent error message, when - on certain occasions - one focuses into a database control, or starts to change data in a database control.

I feel that it occurs when the data source is put into edit mode, and is somehow to do with the BDE trying to find which single record in the table to update, and somehow getting more than one record.

It is "fixed" by the user cancelling out and starting again. It doesn't always occur.

I feel it is likely to be a bug in either the BDE or the Oracle driver but am not sure...anyody seen this one before ?

Alan McCulloch Received on Sun Nov 30 1997 - 00:00:00 CST