> I'm quite sure that the problem was caused by the SP
> or something else that changed on system level.
>
> The statement was:
> SELECT CAST('Now' AS DATE) AS ACTTIME FROM RDB$DATABASE
>
> And I tried it on the same database I copied from our customers
> to my place. And it worked.

Ok, it's a valid statement. Where does that error occur?
In your client application, third-party tool, ...?

In what context is the statement above executed? As a
pure DSQL call, or within a trigger/SP?



--
Best Regards,
Thomas Steinmaurer

The IB LogManager Product Family
Logging/Auditing Suite for InterBase and Firebird
http://www.iblogmanager.com