At 12:41 PM 05/14/98 -0400, you wrote:
>In the process of entering our accounts in a new Emerald installation, we
>have run into the following problem:
>1. An account is entered into Emerald (MBR and Subaccounts)
>2. Another person (or the same, being very tired and loosing track) enters
>the same MBR again and saves it.
>3. When the second person attempts to enter a subaccount they are informed
>that the login name is in use already.
>4. The second person backs out and goes on to another customer.
>5. When I go and search for last name Jones (or whatever) I find one MBR,
>but when I run a script such as:
>
>SELECT * FROM MasterAccounts
>WHERE LastName='Jones'
>
>I get 2 records listed. (Also, and what brought all this to my attention,
>the phantom second MBR shows up in the Expired Accounts Reports)
>
>Any suggestions how to get rid of my Phantom MBR's ??
>
>Gregory E. Keys
>System Administrator
>LoclNet (A Division of ESC Inc.)
>Electro-data Systems Company Inc.
>Voice: (704)861-1251
>Fax: (704)861-1870
>E-Mail: greg@loclnet.com
>
>
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>
<flushright>M. Ersan
ersan@first.net.jo
firstnet</flushright>