>>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?
>
>Hi Ken,
DBSETPROP('ALIAS.FIELD', 'Field', 'Caption', "Caption")
For renaming columns check "alter table..rename column".
>Cetin
More explanatory :)
DBSETPROP('CUSTOMER.CONTACT', 'Field', 'Caption', "This is my contact caption")
Cetin