Re: [Emerald] Deleting MBRs
David Routh ( drouth@davlin.net )
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.
David
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart