pietro
> try running this select. don't forget to switch to your database with
> "use emerald" or whatewer.
>=20
> UPDATE SubAccounts=20
> Set Active=3D0
> WHERE Login=3D'3soft'=20
>=20
> if you want to "freeze" all accounts of that customer, you have to do
> it
> in MasterAccounts - like this
>=20
> UPDATE MasterAccounts
> Set Active=3D0
> WHERE CustomerID=3D333
>=20
> re-activating is the same but use Active=3D1
>=20
> pietro
>=20
> > -----Original Message-----
> > From: Endang Rachmawati Adwiarto [SMTP:endang@cbn.net.id]
> > Sent: 12. janu=E1r 1998 10:30
> > To: radiusnt@iea-software.com
> > Subject: Freeze (lock) Users on RadiusNT
> >=20
> > For users who have not paid their bill, we usually freeze their
> > accounts.
> > Is there a way to freeze an account on RadiusNT so it can't be used
> > (locked)
> > temporarily without romoving user data on Materaccounts and
> > Subaccounts
> > tables?
> >=20
> > I'm using RadiusNT with SQL Database.
> >=20
> > Appreciate the help,
> > Endang
> > --
> >=20
> >=20
> > ----------------------------------------------------------
> > RadiusNT Mailing List lists@iea-software.com
>=20
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com