delete... Delphi/Oracle drivers bug ?

Article View: comp.lang.pascal.delphi.databases

Article #149

Back to comp.lang.pascal.delphi.databases Previous Next

#149

From: Fran�ois Delaby
Date: Mon, 17 Nov 1997 00:00

21 lines
1216 bytes

Hello !

I use Delphi 3 CS and Oracle 7.3 (native drivers).
I have a UpdateSQL wich has a delete SQL statement like that :

delete from MyTable
where
  ID = :OLD_ID and
  ID_CTR = rpad(:OLD_ID_CTR, 4, ' ') and
  DATES = :OLD_DATES

When only one row has to be deleted, all is going right...
But when more that one row have to be deleted, Delphi send an error
mesage as if the operation was not complete :
  Project Stuff.exe raised exception class EDataBaseError with message
"Update Failed"...
Nevertheless, when I look at the table (with sqlplus), I can see that
the rows have been deleted...

Any Idees ?

Technical Details

Message-ID: <34700AD8.4B5DA6D4@univ-lille2.fr>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ffff5,13113ef5091b93d2,start
X-Google-Attributes: gidffff5,public
X-Google-Thread: 10de66,13113ef5091b93d2,start
X-Google-Attributes: gid10de66,public
From: "Fran�ois Delaby" <delaby@univ-lille2.fr>
Subject: delete... Delphi/Oracle drivers bug ?
Date: 1997/11/17
Message-ID: <34700AD8.4B5DA6D4@univ-lille2.fr>
X-Deja-AN: 290101395
X-Priority: 3 (Normal)
Organization: Universite des Sciences et Technologies de LILLE, France
Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.sqlservers