VFP7: Table field caption

[cj001]

How do I programmically add the CAPTION to a field in a table?

Thanks!
CJ

 

[ramani]

USE myTable
DBSetProp("ac_code","Field","Caption","Account&quot

ac_code.. is the fieldname
Account.. is the field description

Field and caption are literals

ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[rgbean]

Note: This only works if the Table is part of a database (.DBC) - freestanding tables don't have this option.

Rick

 

[Mike Gagnon]

cj001

Can you explain what you are trying to do? There is a way to force a caption if you drag a field for table that is part of a database The way you asked your question it is not possible, but it maybe I don't understand your question.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[cj001]

Thanks Ramani! That works.

Thanks Rick! I realize that the Table has to be part of a container, because that is the only place the default caption field appears.

Mike Gagnon,
What I am trying to do is create a table from information I put into a Excel spreadsheet.
Basically, I have an Excel sheet which I have listed the names of fields and their properties.

It mostly works except it wasn't including the caption for the fields.