Alastair - you wouldn't perchance have transaction processing on would you? I doubt it, but ...
The other thing I would check is disk caching. I _always_ turn hard disk caching off for the disk(s) where my databases reside. "Alastair Burr" <[EMAIL PROTECTED]> wrote: >Thanks, Eloen, > >I tried your suggestion straight away and I think that the rule works (see >below) - with one change: >I replaced: >T1.Inst_Type = Top10_Performances.Inst_Type >with: >T1.Inst_Type IS NOT NULL > >That's a better solution than an (otherwise useless) view but I can still >add more than >10 rows with the same Inst_Type from the browser/editor as long as I don't >leave the editor. As soon as I leave and go back then the rule message >appears when I try to edit where the count is more than 10. > >There's a simple work around - run the edit for 1 row at a time in a loop - >but I'd love to know why there appears to be some sort of "delay" in the >count being updated. > >Can anybody say whether R:Base updates itself internally between each row >addition or only at the end of an edit command - be it "edit * from ..." or >"edit using [formname]..."? I'd always thought that it would have to be >instant - especially in a multi-user situation. > >Would someone mind creating - copy & paste - the simple test DB >below and see if the same result occurs? > >SET QUOTES=NULL >SET QUOTES=' >SET DELIMIT=NULL >SET DELIMIT=',' >SET LINEEND=NULL >SET LINEEND='^' >SET SEMI=NULL >SET SEMI=';' >SET PLUS=NULL >SET PLUS='+' >SET SINGLE=NULL >SET SINGLE='_' >SET MANY=NULL >SET MANY='%' >SET IDQUOTES=NULL >SET IDQUOTES='`' >SET CASE OFF >SET AUTOSKIP OFF >SET REVERSE ON >SET BELL OFF >SET NULL '-0- ' >SET TOLERANCE 0. >SET ZERO ON >DISCONNECT >SET STATICDB OFF >SET ROWLOCKS OFF >SET FASTLOCK OFF >CREATE SCHEMA �AUTHOR ADBTEST � � PUBLIC >CREATE TABLE `Top10_Performances` �+ >(`Inst_Type` TEXT � �(1) ) >LOAD `Top10_Performances` >NONUM >'a' >'b' >'c' >'a' >'a' >'a' >'z' >'z' >'z' >'z' >'z' >'z' >'z' >'z' >END >RULES 'Fail' + >FOR `Top10_Performances` SUCCEEDS �+ >WHERE (NOT Top10_Performances.Inst_Type IN (SELECT Inst_+ >Type FROM Top10_Performances T1 WHERE T1.Inst_Type+ > IS NOT NULL) OR Top10_Performances.Inst_Type IN (+ >SELECT T2.Inst_Type FROM Top10_Performances T2 GRO+ >UP BY T2.Inst_Type HAVING COUNT(*) < 10)) >DISCONNECT > >CONN ADBTEST >EDIT * FROM Top10_Performances >RETURN > >Try making all the rows the same, then making 10 the same and the other >different & leave the edit and return and try to make an 11th row the same. > > >Thanks & regards, >Alastair. > > >----- Original Message ----- >From: "ELOEN" <[EMAIL PROTECTED]> >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >Sent: Tuesday, January 28, 2003 10:07 AM >Subject: [RBASE-L] - Re: Rule problem > > >> Hi Albert, >> >> try this: >> >> RULES 'Limit of [ 10 ] entries reached!' FOR Top10_Performances SUCCEEDS >> WHERE+ >> � � Inst_Type NOT IN (SELE Inst_Type FROM Top10_Performances T1 WHERE+ >> � � T1.Inst_Type = Top10_Performances.Inst_Type) OR Inst_Type IN (SELE >> T2.Inst_Type+ >> � � FROM Top10_Performances T2 GROUP BY T2.Inst_Type HAVI COUNT(*) < 10) >> >> Polychronis T. Kontos >> Athens, Greece > > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/
