At 05:06 PM 05-04-01 +0100, you wrote:

>The thing is, when I try this command interractively it works fine
>(there seem to have been a number of postings recently with this type of
>problem).

The similarities are only superficial. In the other reported cases, they were getting Delphi syntax errors, not SP compiler errors or runtime errors server-side. I'd still be wanting to examine closely what the SP is trying to write as a result of that calculation; and I'd want to explore the possibility that the proc is getting ambiguous results in one or more of those subselects.

>I guess it's time for the fine toothed comb
>mutter mutter grumble

I don't understand why you are using while...do to iterate through this. Have you thought about controlling the flow with a for select...into....do?

(Going to bed now....)
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________