Larry What update are on? I had that problem with update 74 I think - it's fixed now. Dawn
-----Original Message----- From: Lawrence Lustig [mailto:[EMAIL PROTECTED] Sent: Friday, July 16, 2004 2:33 PM To: RBG7-L Mailing List Subject: [RBG7-L] - What's wrong with this view? 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
