Hello,



with this code I get an sql error, but it works until today perfect :o(



with wgetnextprio as (select prio, count(*) as kount from tfachzuordnung
where le is null and gesperrt = 0

and elementtyp = 1 and paltyp = :paltyp_anfrage group by prio)

select first 1 prio from wgetnextprio where kount = (select max(kount)
from wgetnextprio)into :prio_to_find;

select first 1 fachnr from tfachzuordnung a where a.elementtyp = 1 and
a.paltyp = :paltyp_Anfrage

and a.dispo = 0 and prio = :prio_to_find and a.le is null and a.gesperrt
= 0 order by fachnr

into :ziel_einl;



paltyp_anfrage = 2. If I execute the first part, I get: Prio A 1 piece
available, Prio B 1 piece available, Prio C 1 piece available.



But now I get: Token unknown, column 1 line 24 (



What can be wrong?



Thanks.



BR

Olaf





[Non-text portions of this message have been removed]