[Emerald] Deleting MBRs

Randy Martin ( IEAEmerald@austintx.net )
Sun, 27 Feb 2000 20:31:30 -0600

I'm just starting out with Emerald. I had a few (three) MBRs in the
database that needed to be deleted, so I found them and clicked the DELETE
button. I got the usual "are you serious?" questions to which I answered
yes. The deletion appeared to be going fine until I got an SQL error saying
that there was a problem deleting invoices from the invoice table.

Now, the MBRs are gone, but the invoices are still there!! How do I get rid
of the orphaned invoices? Also, shouldn't the deletion of the MBR just take
care of deleting the associated entries in the other tables? I don't think
there should be an error trying to delete entries from the invoice table
that are associated with the MBR.

Running SQL 7.0 SP1, Emerald 2.5.328, Emerald Admin 2.5.323

Any help would be appreciated.



Randy Martin
Austin Internet

For more information about this list (including removal) go to: