I have a view:
PSProblems (WOPhsVer, ProblemDesc)
SELECT HeaderID,(CTXT(Count(*)) & 'copies of header.')
FROM Headers GROUP BY HeaderID HAVING COUNT (*) > 1
UNION SELECT DISTINCT
HeaderID, 'No header' FROM Details WHERE HeaderID NOT
IN (SELECT DISTINCT HeaderID FROM Headers) UNION
SELECT HeaderID,('Duplicate Line' &
CTXT(LineNum)) FROM Details GROUP BY HeaderID, LineNum
having count (*) > 1
I can select from this view without trouble, and see
the results in about 4 or 5 seconds. However, if I
try to BROWSE the view, R:Base hits 98 or 99% CPU
time, and stays there -- I never see the view.
Anyone see anything like this before trying to browse
from a complex view?
--
Larry
