Please share your trigger when you're done with it, Larry! My complicated version is looking obsolete. You and Michael will have to write a book: "Dummy tables for Dummies."
Bill Lawrence Lustig wrote: >>This >>solution will protect the dummy record even if RULES is set to OFF. It can >>also be used in other situations where it is critical that a record not be >>deleted (such as invoices). > > > I like this because I do sometimes have databases where the default is RULES > OFF. However, I think I may use a TRIGGER based approach -- it will check to > see if it is the last record, and abort the DELETE if so. > -- > Larry > > >
