Project temp tTableName from sourctablename using * No constraints, no rules... :P
> -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of Karen > Tellef > Sent: Saturday, January 04, 2014 11:56 AM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Converting Rules > > 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. > > > > > > > >
