Subject Re: [firebird-support] error code
Author Helen Borrie
At 07:14 AM 5/08/2003 +0000, you wrote:
>I have this query
>UPDATE PRODEJ SET CISLO=1 where cast(ZAPIS AS DATE)='25.7.2003' and
>(cast(ZAPIS AS time) between '00:01:00' AND '19:30:00')
>- but client return err: (status)
>2. 335544436
>3. -104
>4. 1
>5. 335544796
>10. 335544807
>16. 335544808
>This error code not in doc.

My guess is that you have the wrong firebird.msg file.

>How to correct this query?

Well, I have a systemic aversion to putting expressions on the lefthand
side of predicates generally, but especially in a WHERE clause. I have a
bad feeling about your expression here, although Arno might say it's

I'd rather go for something that tests the data directly, where it's
possible. This should do it:

where ZAPIS between '25.07.2003 00:01:00.0000'
and '25.07.2003 19:30:00.0000';