Hi!

VFP have its own tool called GENDBC. Create the PRG file using it, edit that PRG file to change field names by built in VFP editor Find and Replace functionality in the code editor, then run PRG to re-create the database and all its files again. This way is reliable, but you have to copy data from old database to new database in case you already have valuable data in database. You can, of course, strip out only required parts from the PRG generated by GENDBC, delete required objects and then create them again by running PRG only with these parts, this way you will have less data to copy.

HTH.

>HI,
>I need to make some changes of some fields name to match business rules and to clarify their use. I find tedious to open tables and re-create views one by one in order to apply the field name change. Is there a way ab=nd/or utility that wolud help me to accomplish the task in an easier way ? Also, is there a possibility to extend the process to forms ?
>
>Thank you for your help,
>Christian Cote