Helen,
At 23:20 09.07.2003 +1000, you wrote:

>Now that you have successfully confirmed that something in your view is
>giving an overflow error, you now need to examine your view definition and
>find what is causing this error.

could this be due to TGLTERIMA being selected from a view using explicit
join for joining between another view and a table, whereas this other view
consists of multiple joins between tables using the where clause for the
join? i.e.

CREATE VIEW VIEWA
SELECT * FROM TABLEB, TABLEC WHERE TABLEB.ID=TABLEC.ID

followed by

CREATE VIEW VIEWB
SELECT * FROM VIEWA LEFT JOIN TABLEA ON VIEWA.ID = TABLEA.ID

In this scenario, TGLTERIMA would be a field of TABLEC.

Set