I have used Family Phone 3 to contain some numeric information for our local needs. Because of an operations change in 2011, I would like to use the Database manager utility to make a mass change to that field. Basically "if Family Phone 3 = 150 then Family Phone 3 now = 200" ...... "If Family Phone 3 = 250 then Family Phone 3 now = 225". What syntax would I use to make these mass changes? Thanks for any insight you can give me.
----- Brent -----
How to do a mass field change
Moderators: Moderators, Tech Support
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: How to do a mass field change
Make a backup before you start... there is no undo button in the Database Manager!
use ma (hit Enter or click Run Command)
replace all phone3 with "200" for phone3="150" (hit Enter or click Run Command)
replace all phone3 with "225" for phone3="250" (hit Enter or click Run Command)
use ma (hit Enter or click Run Command)
replace all phone3 with "200" for phone3="150" (hit Enter or click Run Command)
replace all phone3 with "225" for phone3="250" (hit Enter or click Run Command)