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

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.



Regards,

Nols Smit


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

> Hi,
>
>
> > I'm using Firebird SuperServer V1.5 RC6 on Windows 2000 Pro as a
> > Local Host (update program and database on the same PC).
> >
> > The database has 12 tables and about 60 views. I'm also using
> > IBManager V3.6.5.1 to administer the database.
> >
> > The only problem I have on this stage is that some views

occasionally

> > are getting corrupt.
>
> What does "corrupt" mean in your case?
>
> >I then use IBManager to open the view's SQL,
> > copy it to the clipboard, delete the view and recreate it.
> >
> > Any suggestions why this happens and how to avoid it?
>
> Please provide is with an explanation of the problem first :-)
>
> Well, you could try RC8.
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird, MySQL

& MS SQL

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