Visual Fox Pro7 - Updating multiple fields for multiple account records
Posted on 2012-08-28
Can someone tell me the best way/the best command argument to use to update multiple records for the following fields in one shot to a dbf (free) table using Visual FoxPro 7? The information update for each field will be the same for all records. Basically, I have dozens of account for one client...their contact and billing info has changed, so I want to be able to apply the updates to all records in one shot. Currently, the front end of my Customer/Trade database only allows for updating records 1 by 1.
Essentially, I need help constructing the entire command argument to execute this. I am familiar with some basic foxpro stuff but not this combinantion.
Table to update (free table)
Fields to be updated (all string fields except where indicated)
Update all fields withwhere investor.taxid = XX-XXXXXXX