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. > > >
