Thanks Atrix, I thought something along those lines at first but if it's not in the view then there's no count to compare to. It's only the first addition of a new item as by the time of the second one the first one is in the view.
I'm beginning to think that I may need a work-around - perhaps have a count column in the original table and somehow set each new one to the current max plus one until 10 is reached. Regards, Alastair. ----- Original Message ----- From: "Atrix Wolfe" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 5:37 PM Subject: [RBASE-L] - Re: Rule problem > well, pardon me if im wrong because i havent worked much with views and > never worked with rules, but it looks to me that the rule is whats letting > > 10 through. > > the rule basicly says in english: > > let in records where InstCount <= 10 > OR > let in records that are not part of the view > > it seems to me the rule should be: > > let in records where IsntCount<=10 > OR > (let in records that are not part of the view and these records have > InstCount<=10) > > so i think that would look something like this: > > (Top10_Performances.Inst_Type IN ( SELECT InstType FROM > Top10_Rule_View WHERE InstCount <= 10 ) OR (NOT > Top10_Performances.Inst_Type IN ( SELECT InstType FROM > Top10_Rule_View ) AND Top10_Performances.InstCount<=10)) > > > > ----- Original Message ----- > From: "Alastair Burr" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > Sent: Monday, January 27, 2003 4:19 AM > Subject: [RBASE-L] - Re: Rule problem > > > > I think I've found out what's wrong while playing with the view as Sami > > suggested: > > > > While a value exists in the view then it works. > > When a value doesn't exist then it also works - but not as I want - or > > expected. > > > > Obviously, once the penny/cent drops, any new value will not be in the > > view so the rule prevents the addition of the row. > > > > So I changed the view to: > > > > create view Top10_Rule_View (InstType, InstCount) as SELECT > > Inst_Type, COUNT(Inst_Type) FROM Top10_Performances > > GROUP BY Inst_Type > > > > and the rule to: > > > > (Top10_Performances.Inst_Type IN ( SELECT InstType FROM > > Top10_Rule_View WHERE InstCount <= 10 ) OR NOT > > Top10_Performances.Inst_Type IN ( SELECT InstType FROM > > Top10_Rule_View )) > > > > I had hoped that this would prevent entries where the count was more > > than 10 and let in any new Inst_Type(s). > > It lets in new ones but also more than 10 the same. > > > > Anybody got any ideas why? > > > > Regards, > > Alastair. > > > > > > ----- Original Message ----- > > From: "Alastair Burr" <[EMAIL PROTECTED]> > > To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> > > Sent: Sunday, January 26, 2003 5:48 PM > > Subject: [RBASE-L] - Re: Rule problem > > > > > > > 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] > > > > > ---------------------------------- > > > > > > > > > > > > > > > > > > > > > > > > > > > > > >
