Hi Albert, TRANSACT is OFF - I've even removed the demo version of RBW7.0 in case there was some chance of 2 rbase.cfg files. File System Properties|Troubleshooting - Disable write-behind caching for all drives is ticked.
Do I take it that you don't get the same problem? If so, would you mind checking how the rule has been restored? If the complete where clause is in brackets try removing the outermost pair. R:Base seems to save the rule without them but the backup writes the rule slightly differently. Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Tuesday, January 28, 2003 10:20 PM Subject: [RBASE-L] - Re: Rule problem > 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/ >
