Hello
Sorry but my English is very elemental
Have a problem with a Firebird 1.5.
After do restore I have this problem in various views

SQL ERROR CODE:-802
SQL ERROR MESSAGE:
Arithmetic overflow or division by zero has occurred.

The view is:

Create View V_AlumnoGrupo
(Id, IdAlumno, Nombre, IdGrupo, CodigoModalidad, modalidad, promociona,
titulo, baja)
as
Select
V_AlumnoGrupo0.id, IdAlumno, Alumno.Nombre, V_alumnoGrupo0.IdGrupo,
V_alumnoGrupo0.CodigoModalidad, V_alumnogrupo0.modalidad, promociona,
titulo,
Alumno.baja
from V_AlumnoGrupo0 inner join Alumno
on V_Alumnogrupo0.idAlumno = Alumno.id;

and run good before the backup/restore


If I drop the view and recreate the view, the view run good

Gracias









Yahoo! Groups Links