At 10:27 PM 9/03/2005 +0000, Ray Holme wrote:

>I just ported an application from 1.0.3 Classic to 1.5 SS on Linux.
>
>I am getting a new and strange message from the engine
>
>SQLCODE: -833 - expression evaluation not supported
>
> 1) what does this mean - I am doing a simple insert with shorts,
>longs, datestamps, and string (one datestamp has a suspicious value
>in the day portion - -678971 - could this be it???)

Yes. If you are inserting/updating date and time types with literal data,
you have to use an accepted literal format enclosed in single quotes, e.g.
'3/09/2005' or '09.03.2005'.

> 2) why does once it occurs - every following insert gets the same
>message - is some new kind of clear required here in 1.5

Well, the operation won't be able to get past your error without
intervention from you. It will just keep throwing the exception until you
do something about it. Transactions are atomic - either everything is
committable because everything is OK, or everything is uncommittable
because one thing is not committable. That's not new.

>PS - if you are trying to use FB 1.5 Classic and UDFs - beware using a
>call to routines like isc_encode_date (causes wierd problems with all
>routines not being findable - entry point not found).

Hmm, it sounds as though you don't have the Firebird paths set up
right. Can the engine find its root directory?

./heLen