Subject Re: [firebird-support] Re: Firebird Stored Procedure syntax - rejecting ;
Author Woody
From: "grip_2ls" <lists@...>
> Hi Thomas
> Thanks for the quick response.
> Unfortunately this doesn't work. I now get "Token unknown - line 37,
> column 1" which is the INTO line.

Not sure but you should use HAVING clause, not WHERE clause when doing
aggregate queries. The best way, IMO, to test these things is to use a
visual query builder like IBO Admin or something like it to get the query
right first. Once you have it right, then just wrap it with FOR and INTO and
put it in the procedure and it should work fine, in most cases.

Woody (TMW)