Re: SQL Problem - thanks to all

Hi Everyone,

thanks for your help and Information!!

In my helpless Iīve searched the hole internet and called everybody I know. And Iīve found a simple problem solve by using the "exist" Statement.

Again: Thanks to everyone who as helped!

Bye
Carsten Bliessen

On Mon, 11 Feb 2002 08:22:05 GMT, bliessen_at_gmx.de (Carsten Bliessen) wrote:

>Hi together,
>
>I have a little problem with an SQL Script. I need it for an Oracle 8
>DB wich was installed from our Software company wich supports us. Now
>I must change some data for myselfn and construct this script. But it
>dosnīt work and I canīt find related information on the Internet - of
>course I can find the Failure Code and some explanaitons, but it
>doesnīt meet my Problem - in my opinion. Perhaps you have a tip for
>me?
>
>Script:
>
>update
>(
>Select a.x as wert
>from y a, z m
>where m.nr = x.nr
>and a.wert2 = '1'
>and a.wert3 = '10'
>)
>Set wert = '6'
>
>The failure Code is: ORA-01779: cannot modify a column which maps to
>an non key-preserved table.
>
>Thatīs my Problem, I can't do anything with the information "a non
>key-preserved Table".
>
>Anybody an idea? Anything is helpfull, THX
>
>regards
>
>Carsten Bliessen
Received on Tue Feb 12 2002 - 04:38:30 CST