Re: [Emerald] Deleting MBRs
Randy Martin ( IEAEmerald@austintx.net )
Sun, 27 Feb 2000 23:23:56 -0600
At 10:07 PM 2/27/00 -0600, you wrote:
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
Actually, I found the problem. I thought I was running .328, but Iwasn't. I upgraded the Emerald client to .328, and started the program.The system showed one MBR, but when I clicked on the search button on the"Simple" tab, it found no MBRs. I thought this was verystrange, so I went to SQL and ran a query on the masteraccounts table.Sure enough, there was one MBR there! I noted the CustomerID, and went tothe MBR tab, entered the CustomerID and clicked search. Then it found oneMBR. I was then able to delete that MBR, and it deleted the associatedinvoices also.
I think what happened is that I originally had one account with twomembers. I deleted the main member using the old client, and it failed todelete the sub-account. I used the new client to find the MBR for theoriginal sub-account, and then the delete worked correctly.Strange??!!
Anyway, thanks for your help.
Regards,
Randy
Randy Martin
President
Austin Internet
512-485-7977