Subject Re: [firebird-support] something very strange going on here
Author Milan Babuskov
martinknappe wrote:
> select min(asterm) from dicentries where ((asterm = :asterm_temp
> and id >= :id_temp)) or (asterm > :asterm_temp) into :asterm_temp;

Try using a separate variable here. IIRC, I've already seen some
problems when the same variable is used in both WHERE and INTO clauses.


--
Milan Babuskov
http://swoes.blogspot.com/
http://www.flamerobin.org