> How do I get rid of it?
Do you have any referal information you want to keep or don't mind
rekeying? The easiest way to clear them all out is to run this query:
UPDATE MasterAccounts SET ReferredBy = NULL
take care,
Peter
> At 08:11 PM 4/11/2000 -0700, you wrote:
> >On Tue, 11 Apr 2000, Randy Martin wrote:
> >
> > > I have what appear to be integer numbers showing up on screen in the
> > > "Referred" field on the Master tab of the mbr display. I don't remember
> > > there being anything in there when I first started using the program. Now
> > > everytime I display a mbr record, a number appears in that field.
> >
> > > I have "Referrals" setup in Emerald Admin, but I didn't include this data
> > > when I did my data conversion to Emerald.
> >
> > > Does anyone have any idea what's going here?
> >
> >That was pry done in the database conversion to setup a relationship to
> >the origional data.
> >
> >Have Fun!
> >Peter
> >
> >
> >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
>
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart