Alastair - It seems like this should work but ...Have you tried creating the GROUP BY portion as a view and referencing the view in your rule?
Sami ----------------------------------------------------------- Sami Aaron Software Management Specialists 19312 W 63rd Terr Shawnee KS 66218 913-915-1971 [EMAIL PROTECTED] http://www.softwaremgmt.com ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, January 26, 2003 6:14 AM Subject: [RBASE-L] - Rule problem > Hi all, > > Can anybody tell me why this rule doesn't work? > > MESSAGE : Limit of [ 10 ] entries reached! > TABLE : Top10_Performances Row is added or changed if condition SUCCEEDS > WHERE : Top10_Performances.Inst_Type IN ( SELECT Inst_Type FROM > Top10_Performances GROUP BY Inst_Type HAVING COUNT(Inst_Type) <= 10 ) > > I'm trying to limit the number of rows for any individual value in Inst_Type > to a maximum of 10 (10 guitars, 10 drums, etc.). At the moment whichever I > way I try this (succeeds or fails) I cannot change anything even though > there are only 5 rows in the table. > > Thanks in advance, > Regards, > Alastair. > > ---------------------------------- > A D B Burr, > St. Albans, UK. > ---------------------------------- > [EMAIL PROTECTED] > ---------------------------------- > > > >
