Update MasterAccounts
Set Extension=30, OverDue=30
> 2) Since after you post a billing their Temporary extend goes back to
> "0" what script would I run to change everyone back to 30 days?
If you want the temp to stick, then put it in the perm. I don't
understand why you want to do this recurring? Its the same as
the above, just omit the field you don't want (temp is the extension
field, and OverDue is the perm).
> 3) Where is the best place to run the scripts from?
isql_w or you can schedule it in enteprise manager.
--Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com