UPDATE dbo_MasterAccounts INNER JOIN dbo_SubAccounts ON
dbo_MasterAccounts.CustomerID = dbo_SubAccounts.CustomerID SET
dbo_MasterAccounts.Active = 0, dbo_SubAccounts.Active = 0,
dbo_MasterAccounts.Comments =
[dbo_MasterAccounts]![Comments]+0x0D+0x0A+'12/29/99, bja, deactivated
expired account'
WHERE (((dbo_MasterAccounts.Active)=1) AND ((dbo_SubAccounts.Active)=1) AND
((dbo_MasterAccounts.maExpireDate)<#10/1/99#));
It deactivates anyone who has been expired since 10/1/99 and adds a comment
in the master account so if you look at it later you know what was done.
Versions older than 2.5.294 also had a problem created phantom MBR's. You
can find them with this:
SELECT dbo_SubAccounts.Login, dbo_SubAccounts.AccountID,
dbo_SubAccounts.CustomerID, dbo_MasterAccounts.LastName,
dbo_MasterAccounts.FirstName
FROM dbo_MasterAccounts INNER JOIN dbo_SubAccounts ON
dbo_MasterAccounts.CustomerID = dbo_SubAccounts.CustomerID
WHERE (((dbo_SubAccounts.Login) Is Null));
I was able to free up several hundred accounts this way.
btw- I did this in Access97 so the linked Emerald tables all have the prefix
dbo_
> -----Original Message-----
> From: emerald-request@iea-software.com
> [mailto:emerald-request@iea-software.com]On Behalf Of david leigh
> Sent: Friday, January 21, 2000 7:38 AM
> To: emerald@iea-software.com
> Cc: juliel@wadata.com.au; ericl@wadata.com.au
> Subject: [Emerald] Problems with Manual Invoices
>
>
> Hi All
>
> We are 25 users away from purchasing another 1000 MBR licences
> for Emerald.
> I'm nervous about doing so because I still haven't got an answer regarding
> the problem of manual invoices not being added to the Balance, but being
> subtracted from the balance when voided.
>
> Dale and Peter - I'm directly addressing you as the two most
> cluey people on
> this list. (But if anyone else knows the answer then I am
> desperate to hear
> it)
>
> 1) Can you confirm that this bug (which is a known bug from what
> is said in
> this lists archives) is repaired?
> 2) Can you tell me how to fix it on my installation (2.5.322 on SQL 7)
>
> Cheers
> David Leigh
>
>
> For more information about this list (including removal) go to:
> http://www.iea-software.com/support/maillists/liststart
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart