Re: Bug or What?
Reinhard Habichtsberg wrote:
>
> Andreas Kumpf <ak@a-w.de> schrieb in im Newsbeitrag:
> 3816FEFA.5A62CA02@a-w.de...
> > Hi,
> > I've written an SQL-statement consisting of an UPDATE <table> SET
> > <fieldname> =(SELECT <same fieldname as before> ....).
> > But....although the fieldname DOESN'T exist in <table> the statement
> > returns no error and doesn't update any table as well. What it actually
> > does.....hmmm.
> > I'm currently using IDS 7.31.UC2 on SCO 5.0.2.
> >
>
> Hi Andreas,
>
> do you mean something like this:
>
> UPDATE kstamm SET> testfeld =(SELECT testfeld from kstamm);
> # ^
> # 217: Spalte (testfeld) bei Abfrage in keiner Tabelle gefunden (oder ALV
> nicht
>
> definiert). (column not found!)
>
> You see I got an error. Same IDS on Reliant Unix 5.43
Even I got an error. So Andreas can you please give the example that you
have used and along with table schema?
regards,
Rahul.
>
> Regards
>
> Reinhard