I am converting several dozen large tables from a FP 2.6 platform to VFP 6.0. I have already moved these tables into a VFP database container and now need to add a caption and update the fieldnames to a standard naming convention. There are almost 2000 data elements and I don't want to spend the next 3 days fumbling through the database designer to set each caption manually. In that old system, I have a table that contains the "Friendly Name" (or caption) for all the data elements and want to write a program to update the caption for each field. I thought I found the solution with the ALTER TABLE command, but there does not seem to be an option to change the caption. Any Ideas?
Ken Russell
Mechanicsville, Virginia