Thanks Helen,

I've used the correct view syntax. However, I think I
might have some problem with my setup.

When I'm trying

select truncate(fTarif) from "MyTable"

I get the error message:

Dynamic SQL Error.
SQL error code = -804.
Function unknown.
TRUNCATE.

Same thing for:

select abs(-1) from rdb$database;

An error was found in the application program input
parameters for the SQL statement.
Dynamic SQL Error.
SQL error code = -804.
Function unknown.
ABS.

It looks like I can't use any external function. Do I
have to enable those explicitly somewhere?

I'm using Firebird 2.0 RC2.

Arnold




__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com