This is a multi-part message in MIME format.
------=_NextPart_000_012D_01BD00CF.DFD43AA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I had a similar problem when interacting with an Oracle DB through IS\2, =
the problems seems to be due to some freak of nature(front end =
programmers) who try to create sequences(i.e. unique ID etc) in their =
front end code, I'm not saying this is your problem but it seems like =
it,
I bet your application works first time, anytime after that, this errors =
occur, check your code especially where you implement your =
inserts\update, it's possible that you are creating a row and recreating =
it when you update, when you then do a select you have multiple rows...
$100,000 Advice, kill your front end programmer.....
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
'Femi II
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
"Intestinal parasites known as senders of unsolicited
commercial email will be castrated without anaesthesia,
painfully sodomized by a herd of elephants and then
slowly tortured to death. Unlikely survivors will be=20
promptly caught and fed to lawyers."=20
-- I liked this and nicked it, note quotes
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Alan MCCulloch wrote in message <65r9n1$1ho$1_at_scream.auckland.ac.nz>...
>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 =20
>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
------=_NextPart_000_012D_01BD00CF.DFD43AA0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML>
<HEAD>
<META content=3Dtext/html;charset=3Diso-8859-1 =
http-equiv=3DContent-Type>
<META content=3D'"MSHTML 4.71.1712.3"' name=3DGENERATOR>
</HEAD>
<BODY>
<DIV>I had a similar problem when interacting with an Oracle DB through =
IS\2,=20
the problems seems to be due to some freak of nature(front end =
programmers) who=20
try to create sequences(i.e. unique ID etc) in their front end code, I'm =
not=20
saying this is your problem but it seems like it,</DIV>
<DIV>I bet your application works first time, anytime after that, this =
errors=20
occur, check your code especially where you implement your =
inserts\update, it's=20
possible that you are creating a row and recreating it when you update, =
when you=20
then do a select you have multiple rows...</DIV>
<DIV> </DIV>
<DIV>$100,000 Advice, kill your front end programmer.....</DIV>
<DIV> </DIV>
<DIV>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR> &nb=
sp; &nbs=
p;  =
;=20
'Femi =
II<BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D<BR><FONT color=3D#000000=20
face=3DArial size=3D1>"Intestinal parasites known as senders of=20
unsolicited<BR>commercial email will be castrated without=20
anaesthesia,<BR>painfully sodomized by a herd of elephants and =
then<BR>slowly=20
tortured to death. Unlikely survivors will be <BR>promptly caught and =
fed to=20
lawyers." </FONT> </DIV>
<DIV><FONT color=3D#000000 face=3DArial size=3D1>-- I liked this and =
nicked it, note=20
quotes</FONT><BR>=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D </DIV>
<DIV>Alan MCCulloch<AMCCULLO_at_CCU1.AUCKLAND.AC.NZ> wrote in message =
<<A=20
href=3D"mailto:65r9n1$1ho$1_at_scream.auckland.ac.nz">65r9n1$1ho$1_at_scream.au=
ckland.ac.nz</A>>...</DIV>>My=20
application works well except for a very annoying =
intermittent<BR>>error=20
message, when - on certain occasions - one focuses into<BR>>a =
database=20
control, or starts to change data in a database =
control.<BR>><BR>>I feel=20
that it occurs when the data source is put into edit mode,<BR>>and is =
somehow=20
to do with the BDE trying to find which single record<BR>>in the =
table to=20
update, and somehow getting more than one record.<BR>><BR>>It is=20
"fixed" by the user cancelling out and starting again.=20
It <BR>>doesn't always =
occur.<BR>><BR>>I feel=20
it is likely to be a bug in either the BDE or the Oracle<BR>>driver =
but am=20
not sure...anyody seen this one before ?<BR>><BR>>Alan=20
McCulloch</BODY></HTML>
------=_NextPart_000_012D_01BD00CF.DFD43AA0--
Received on Thu Dec 04 1997 - 00:00:00 CST
