Hi,

At August 20, 2003, 23:07, Darryl wrote:

> Curiously, this VIEW was created and does work, despite this error being
> displayed.

What are you using to create the view? Because, it might be the
front-end application that is giving that error and not Firebird.
But, personally, I would prefer to write:
(case SIZE_ID
WHEN 1 then QUANTITY
WHEN 7 then QUANTITY
WHEN 13 then QUANTITY
end) as CASE_FIELD_1 or whatever more significant name

But, that is personal preference, and also makes it easier to know
what is the name of the result field.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)