Subject | Error backup/restore |
---|---|
Author | "DUOK INFORMATICA, S.L.- Luis MÂȘ Monter |
Post date | 2004-06-23T06:43:19Z |
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
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