RE: [Emerald] Records

Nathan Haywood ( nhaywood@whro.org )
Fri, 12 Nov 1999 10:24:50 -0500

Messages sorted by: [ date ][ thread ][ subject ][ author ]
Previous message: Jason: "[Emerald] Records"
Next message: Frank Canode: "Re: [Emerald] Records"
Maybe in reply to: Jason: "[Emerald] Records"
Next in thread: Frank Canode: "Re: [Emerald] Records"

Well, for one thing, you counted the wrong table. The number of MBRs you
have created is the count of (active?) entries in the MasterAccounts
table.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com]On Behalf Of Jason
Sent: Friday, November 12, 1999 10:21 AM
To: emerald@iea-software.com
Subject: [Emerald] Records

When I open up Emerald Manager at the bottom I see my licensing
information
with the number of licenses I have now and how many are used (ie.
1164/1200). Now when I use MSQuery and pull a listing of all the
records
from the Emerald DB:

(SELECT SubAccounts.PhoneHome, SubAccounts.PhoneWork,
SubAccounts.LastName,
SubAccounts.FirstName, SubAccounts.Login, SubAccounts.Password,
SubAccounts.AccountType
FROM Emerald.dbo.SubAccounts SubAccounts)

I get a total of records (1111) that is 53 less that what shows in the
Emerald Manager (1164).

Any ideas as to why this happens? My billing/accounting people are
going
nuts trying to get those numbers to match.

TIA

Jason Roblyer
NCTC
jason@nctc.net

For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart

Previous message: Jason: "[Emerald] Records"
Next message: Frank Canode: "Re: [Emerald] Records"
Maybe in reply to: Jason: "[Emerald] Records"
Next in thread: Frank Canode: "Re: [Emerald] Records"