Josh Hillman
hillman@talstar.com
----------
> From: Josh Hillman <admin-maillist@talstar.com>
> To: emerald@iea-software.com
> Subject: Ran out of licenses; need to wipe out old MBRs
> Date: Friday, July 24, 1998 1:30 PM
>
> I ran out of licenses yesterday in Emerald and Emerald (2.1.11) locked
out
> our staff from going into the program. Luckily, I still had it running
on
> another machine so I could use that to clear out a few MBRs that had
> expired back in 96. Unfortunately, that only freed up 10 MBRs, so we're
> just about to run out again.
> Is there a decent SQL script that'll perform the same function as hitting
> DELETE in the MBR search screen in Emerald? I'd rather not sit there
> entering in who knows how many old accounts and hitting delete, then
> confirming a few times each time. If this deletes only subaccounts and
> masteraccounts where MasterAccounts.maExpireDate < 7/1/97 and
ma.customerid
> = sa.customerid, then I can write the script(s) myself, but I wasn't sure
> if the Delete button had any other effects...
>
> When deleting old MBRs, it has no effect on the following tables, right?:
> Payments
> InvoiceItems
> Charges
> Invoices
>
> Before wiping out the old accounts, I will print out a listing of all
> invoices and payments associated with the old accounts since after wiping
> out the MBRs, I'll have no way of associating any of them with anyone's
> name/company...
>
> Josh Hillman
> hillman@talstar.com