Re: Migration-Problem: Forms4.5 to Forms6.0

From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/07/10
Message-ID: <smjnngcgnu29_at_corp.supernews.com>#1/1


'kla' either needs to be an alias for a table or a table itself. This shouldn't have compiled in 4.5 either.

See if this works:

...

select count(*) into cnt from ord kla, taxon

(etc...)

-Matt

"Thorsten" <ludwig_at_mathematik.uni-ulm.de> wrote in message news:396985C6.9C249D19_at_mathematik.uni-ulm.de...
> Hello,
>
> I want to convert an Forms4.5-Application to Forms6.0. In one Funktion I
> got an error message: "Error 327 ..., 'KLA' is not in SQL scope here"
> (where 'KLA' is a table...).
> The code is
>
> FUNCTION CountTaxOrd (lordnu varchar2, lunord varchar2,
> lfagru varchar2, lklaid number) RETURN number IS
> cnt number;
> BEGIN
> begin
> select count(*) into cnt from ord, taxon
> where ordnu=lordnu
> and (nvl(unord, lunord) is null or unord=lunord)
> and (nvl(fagru, lfagru) is null or fagru=lfagru)
> and kla.id=taxon.id and taxon.stufe='O'
> and taxon.vorgid=lklaid and taxon.vstufe='K'
> ;
> exception
> when others then null;
> end;
> return cnt;
> exception
> when others then return 0;
> END;
>
> Can anyone help, please?
>
> Thanks and greetings,
> Thorsten.
Received on Mon Jul 10 2000 - 00:00:00 CEST

Original text of this message