Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Accessing Table Structure - Field Comments
Message
From
28/12/2000 13:18:42
 
 
To
28/12/2000 13:08:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00457435
Message ID:
00457446
Views:
31
Hi Paige,

You can use the FCOUNT function to cycle through all of the fields in the table and for each field, you can use DBGETPROP() to get the Comments for each field. I suppose you could then write the field name and the comments to a table for export to Excel.

>Hello all and a happy new year,
>
>I'm trying to copy the data from a file structure into an Excel spreadsheet. I'm particularly interested in the "Fields Comments" field, and others, which do not copy with the "Copy Stru Extended" command. I can copy fields from a data table into Excel but how do I access the "data" from a table structure? TIA.
>
>Regards,
>
>Paige
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform