Thanks, Sami, I was trying to avoid a view because _as far as I can tell_ the select works at the R:>.
I'll give it a while and see if anybody else has any comments then try a view. Regards, Alastair. ----- Original Message ----- From: "Sami Aaron" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Sunday, January 26, 2003 4:41 PM Subject: [RBASE-L] - Re: Rule problem > 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] > > ---------------------------------- > > > > > > > > >
