Subject | Re: [firebird-support] Re: Firebird Stored Procedure syntax - rejecting ; |
---|---|
Author | Woody |
Post date | 2011-03-21T15:12:12Z |
From: "grip_2ls" <lists@...>
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.
HTH
Woody (TMW)
> Hi ThomasNot sure but you should use HAVING clause, not WHERE clause when doing
>
> Thanks for the quick response.
>
> Unfortunately this doesn't work. I now get "Token unknown - line 37,
> column 1" which is the INTO line.
>
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.
HTH
Woody (TMW)