In ISQL_w (the Query Analyzer in SQL 7.0) you can execute the following
command:
update masteraccounts
set overdue=[integer]
The above, when [integer] is replaced with the number of days you want
all Permanent Extends to be, will udpate all accounts regardless of
their status. If you have already set some accounts to have special
Permanent Extends but want to change the default for your old default
accounts, you can use:
update masteraccounts
set overdue=[new value]
where overdue=[old value]
If you want to leave inactive MBRs in the same state they were when they
were made inactive, you can add the qualifier "where active=1" to the
first query, or the qualifier "and active=1" to the second query.
Sheryl Weidner
David Routh wrote:
>
> Hello,
>
> Is there a way (maybe thru SQL) to change the Permanent Expire for ALL the
> customers we currently have in the database... if so can someone tell me how.
>
> Thanks, David
>
> 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