Hi,


Could you please, send the modified SP to the list?

SanTa

2011.03.21. 16:24 keltezéssel, grip_2ls írta:

> Thanks Woody but the SQL works fine and gives me what I want - I already tested it and validated it before tyring to put it into a stored procedure. The issue is the syntax of the stored procedure.
>
> Neil
>
> --- In firebird-support@yahoogroups.com, "Woody"<woody-tmw@...> wrote:
>> 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.
>>
>> HTH
>> Woody (TMW)
>>
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>

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