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 theDELETE
>button. I got the usual "are you serious?" questions towhich I answered
>yes. The deletion appeared to be going fine until I got an SQL errorsaying
>that there was a problem deleting invoices from the invoicetable.
>
>Now, the MBRs are gone, but the invoices are still there!! How do Iget rid
>of the orphaned invoices? Also, shouldn't the deletion of the MBRjust take
>care of deleting the associated entries in the other tables? I don'tthink
>there should be an error trying to delete entries from the invoicetable
>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 notimpossible.
You're right in that the deletion will remove everything associatedwith
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.
David