At 06:00 AM 1/06/2006, you wrote:

>Hi,
>is it possible to call external functions in a view?
>I'm trying to do something like this:
>
>create view test as
>select truncate(a.fieldname) from mytable as a
>
>Is this possible in Firebird?

Yes, but you have to use the proper syntax! Read up on it. You
can't define a view without a column list if the output columns come
from expressions, joins or unions.

create view test (
id BigInt,
newValue integer)
as
select id, truncate(fieldname)
from myTable

./heLen