This message apparently didn't make it into the forum, for some reason.

Meanwhile I "solved" the problem by dropping every view and then recreating
them, but I would still be quite interested in finding the real cause.

Pepak

----- Original Message -----
From: "PenWin" <PenWin@...>
To: "Firebird support" <Firebird-Support@yahoogroups.com>
Sent: Wednesday, January 17, 2007 2:00 PM
Subject: Arithmetic Overflow in views


> Hi!
>
> I have just found a very strange problem with my database (Firebird
> 1.5.2.4731/WinXP): Some views have recently started to crash with
> "arithmetic exception, numeric overflow, or string truncation" when I try
> to read data from them. Using the original select statements, from which
> the views were created, works correctly. Backing up and restoring the
> whole database has no effect on this, but dropping and recreating the
> views works. I was able to reproduce the problem on three different
> computers and was told by my users that all their computers exhibit this
> behavior - but only with that one particular database, other users who use
> a different database don't have this problem. What could be the cause? Is
> there some way that lets me find out which record is causing the overflow?
> Is there some application which would check all existing views for valid
> data?
>
> Thanks,
>
> Pepak