The ability to set rules off/on has always been a plus for me too. I am sure that my 25 years running database could reduce some of the rules to Constraints and will be doing that but some of the rules are really handy. Ron
On Sat, Jan 4, 2014 at 11:55 AM, Karen Tellef <[email protected]> wrote: > What the heck, let's stir the pot a bit. I don't like rules either, and > try to replace > with constraints whenever possible. That being said, sometimes I sorely > miss > being able to say "set rules off".... It's usually when I'm doing some > batch processing > from the r> prompt, or bringing in a dump of data that I know will > temporarily break > a constraint but I don't care. So much easier to set rules on and off > than altering a > table to remove a constraint and then put it back on... > > The other day we added a column to a Payables table that already had a > constraint on it > to limit what could be entered new. When I went to update the new column > to insert > values, got constraint errors on all the old rows... If it was a rule I > could have simply > turned the rule off. > > Karen > > > -----Original Message----- > From: Albert Berry <[email protected]> > To: RBASE-L Mailing List <[email protected]> > Sent: Sat, Jan 4, 2014 10:34 am > Subject: [RBASE-L] - RE: Converting Rules > > I have a 280+ Mb database with no rules at all. I have triggers and I > have constraints. > Albert > > On 1/4/2014 5:41 AM, MikeB wrote: > > I would chime in that if you haven't changed rules for constraints where > applicable, you should do that ASAP. Your life will be less complicated. My > internal database is not huge, but my rules table has only 5 rows. > > > > > > > > > >
