Re: [Emerald] Deleting MBRs

David Routh ( )
Sun, 27 Feb 2000 22:07:56 -0600

At 08:31 PM 02/27/2000 -0600, you wrote:
>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

That's unusual with .328 (being it's the latest)... but not impossible.

You're right in that the deletion will remove everything associated with
the MBR... At least that's how I understand it...

Perhaps Dale can shed some light on it in the AM.

Sorry I can't be of more help.


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