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.