[Logic] Modifying an userfield value

[Arthur Tan]

Hi Fidel,

On Mon, Mar 04, 2002 at 10:14:55PM +0100, Fidel Leon wrote:


> Looks like LOGic does a per-district zone location, but there are some
> exceptions to the rule.

> I'd like to do mass changes to the database, based on the State info
> instead of district, but I don't know how to change, in FoxPro, the
> CQZ tag in the Userfields field.


Make a backup of your log data, no matter what happens.

Try using Tools|Miscellaneous Utilities|Fix Stuff.PRG first.

You can also try Tools|Advanced|Database Commands

USE LOG
REPLACE USERFIELDS WITH 'CQZ:5|' FOR STATE='FL'

[...etc...]
CLOSE TABLES ALL


You can do this for each state but it's a long and tedious process.
Hope this helps.

73, Art AB4RL