Update is wrong

Bernd Maierhofer

Delphi Developer

Sun, 06 Oct 2002 03:00:00 GMT

BDE 5.11, Oracle 8.0.5 - Select/Update is wrong

I just upgraded to BDE 5.11 and ran into a severe problem:

select * from ttmaterialdescription where matid=26582

returns in the SQl Worksheet:

MATID LANGUAGEID DESCRIPTION
---------- ---------- ------------------------------------------------------
--------------------------
26582 1 WV.KL.SUPPE M.GEMUS.1X30FS
26582 2
2 Zeilen ausgew?hlt

whereas in the sql explorer

26582 1
26582 2
If I enter a value in the second line for the description, the value for the
first line is retrieved too.

Does anybody know, what is going on here?

--
dato Denkwerkzeuge - Bernd Maierhofer
Corneliusgasse 4/5
A-1060 Wien , Austria
supp...@dato.at

Ruud Laanbroe

Delphi Developer

Sun, 06 Oct 2002 03:00:00 GMT

Re:BDE 5.11, Oracle 8.0.5 - Select/Update is wrong

Do you have more information?
- Table definition (data types)?
- Oracle server and client both 8.0.5?
- What do you mean by 'upgraded'?
Did you have BDE 5.10?
- Did the problem not occur before upgrading?
And further whatever you think is relevant.

Ruud

Bernd Maierhofe

Delphi Developer

Sun, 06 Oct 2002 03:00:00 GMT

Re:BDE 5.11, Oracle 8.0.5 - Select/Update is wrong

Going back to the last SqlOra.dll solved the problem.

dato Denkwerkzeuge - Bernd Maierhofer
Corneliusgasse 4/5
A-1060 Wien , Austria
supp...@dato.at

Bernd Maierhofer schrieb in Nachricht <8dk5ar$5...@bornews.borland.com>...

Quote

>I just upgraded to BDE 5.11 and ran into a severe problem:

>select * from ttmaterialdescription where matid=26582

>returns in the SQl Worksheet:

>MATID LANGUAGEID DESCRIPTION
>---------- ---------- -----------------------------------------------------
-
>--------------------------
> 26582 1 WV.KL.SUPPE M.GEMUS.1X30FS
> 26582 2
>2 Zeilen ausgew?hlt

>whereas in the sql explorer

> 26582 1
> 26582 2

>If I enter a value in the second line for the description, the value for
the
>first line is retrieved too.

>Does anybody know, what is going on here?

>--
>dato Denkwerkzeuge - Bernd Maierhofer
>Corneliusgasse 4/5
>A-1060 Wien , Austria
>supp...@dato.at

John Smit

Delphi Developer

Sun, 06 Oct 2002 03:00:00 GMT

Re:BDE 5.11, Oracle 8.0.5 - Select/Update is wrong

I have similar problem. My query is 5 tables with outerjoins produces
correct result in Oracle SQL Plus but wrong result in SQL Explorer or DB
Desktop. I tried to switch the driver but it did not solve my problem.

Alex

Quote

Bernd Maierhofer wrote in message <8dk5ar$5...@bornews.borland.com>...
>I just upgraded to BDE 5.11 and ran into a severe problem:

>select * from ttmaterialdescription where matid=26582

>returns in the SQl Worksheet:

>MATID LANGUAGEID DESCRIPTION
>---------- ---------- -----------------------------------------------------
-
>--------------------------
> 26582 1 WV.KL.SUPPE M.GEMUS.1X30FS
> 26582 2
>2 Zeilen ausgew?hlt

>whereas in the sql explorer

> 26582 1
> 26582 2

>If I enter a value in the second line for the description, the value for
the
>first line is retrieved too.

>Does anybody know, what is going on here?

>--
>dato Denkwerkzeuge - Bernd Maierhofer
>Corneliusgasse 4/5
>A-1060 Wien , Austria
>supp...@dato.at

John Pierc

Delphi Developer

Mon, 07 Oct 2002 03:00:00 GMT

Re:BDE 5.11, Oracle 8.0.5 - Select/Update is wrong

I strongly urge anyone using Oracle 8 to use Direct Oracle Access
(www.allroundautomations.nl). It will solve all your problems, and do
away with the BDE.

JP

Other Threads

1. BDE 5.11, Paradox, AutoIncrement and SQL update problem.

2. BDE 5.11 not updating???

3. BDE Version 1 makes Problem when updating to 5.11

4. delphi 4 , bde 5.11 ,oracle 8.16 problems with Blobs

5. Delphi 5+Oracle 8i +BDE 5.11 Two query master-Detail (Requestlive=true)

6. Problem with Delphi 5, BDE 5.11 and Oracle 8.1.7

7. Packages with Oracle 8.1.7 and BDE 5.11

8. Oracle 8.1.6, bde 5.11, delphi4

9. Problem with BDE 5.11 and Oracle 8

10. BDE 5.11 & Oracle 8