I'm not using a special character set. In IBManager the "Charset"
field is blank.

I am not sure. I will fix the corrupt view and then do a
Backup/Restore and then open all 60 of them one by one.

Do you have any other suggestions about tests I can do?


Regards,

Nols Smit


--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi,
>
>
> > When I open the view (using IBManager) I get the following

message:

> > frmViewView_2.frmData.DataSelectQuery:
> > Arithmetic overflow or division by zero has occured.
> > arithmetic exception, numeric overflow, or string truncation
>
> Does this happen "occasionally", or after a backup/restore?
>
> Do you have a special characterset defined for your database?
> If so, do you connect with that characterset?
>
> > This particular view's definition:
> >
> > CREATE VIEW PROVINCE_DC (
> > PROV_ID,
> > PROV_DB_ID,
> > PROV_DESC,
> > DC_ID,
> > DC_DB_ID,
> > DC_DESC)
> > AS
> > SELECT
> > PROVINCES.ID,
> > PROVINCES.DB_ID,
> > PROVINCES.DESCRIPTION,
> > DISTRICTCOUNCILS.ID AS ID1,
> > DISTRICTCOUNCILS.DB_ID AS DB_ID1,
> > DISTRICTCOUNCILS.DESCRIPTION AS DESCRIPTION1
> > FROM
> > JUNCTION
> > INNER JOIN PROVINCES ON (JUNCTION.FROM_ID = PROVINCES.ID)
> > INNER JOIN DISTRICTCOUNCILS ON (JUNCTION.TO_ID =
> > DISTRICTCOUNCILS.ID)
> > ;
> >
> >
> > I can open the views this one depends on without problems.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

> Server.
> Upscene Productions
> http://www.upscene.com