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