Re: SQL Replacement

Lawrence Watkins Work ( (no email) )
Tue, 5 May 1998 17:31:34 -0500

That would work fine.
-----Original Message-----
From: Michael Whisenant <mwhisen@airnet.net>
To: emerald@iea-software.com <emerald@iea-software.com>
RadiusNT@iea-software.com <RadiusNT@iea-software.com>
Date: Tuesday, May 05, 1998 12:19 PM
Subject: RE: SQL Replacement

>Well I found the Update statement. Lets say for example I
wanted to replace
>all the entries in the Table SubAccounts the field is
LoginLimit where
>LoginLimit=0 I wanted to change it to LoginLimit=1. There
is something
>about update in place. Any ideas on the script to run.
>Here is one sample,
>anyone know if this will do what I anticipate?
>
>
>UPDATE SubAccount
> SET
>LoginLimit = '1'
> WHERE LoginLimit = '0'
>GO
>
>
>Michael J. Whisenant
>Vice-President, Operations
>AIRnet Internet Services, Inc.
>ph: (256) 704-4692 fax: (256) 704-2329
>
> ----------------------------------------------------------
> RadiusNT Mailing List lists@iea-software.com
>
>