>>>... I 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
Thanks Cetin
Works great. I wrote my little program and the "caption" job was done in a few seconds. I'm a VFP rookie, but I should have thought to look at that DBSETPROP command -- I knew that the caption data was stored in the DBC -- not the table.
Thanks again.
Ken Russell
Mechanicsville, Virginia