Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Field Comments in a table
Message
 
À
16/06/2005 16:19:37
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows '98
Network:
Novell 6.x
Database:
Visual FoxPro
Divers
Thread ID:
01024122
Message ID:
01024124
Vues:
20
>I have noticed that when you modify the structure of a table, there is an option on the right side to add field comments as well as other things. This always seems to be an inactive option, how do you enable these for input? Once there is input in them, how do you reference to pull this information from these in a program? For example, I would like to put in the field comments a description of what the field is used for, then in my program I would like to display these descriptions as the fields are advanced in a combobox to give the user the option if they want to add the field as one they would like to pull for a report.

Here how you can add comments to the fields (kerep in mind this is only possible for Tables that are in DataBase, For Free tbables you can't add comments.
*****
USE Yourtable EXCLUSIVE
MODIFY STRUCTURE
How can retreive this information from Table
OPEN DATABASE DBWhereYourTableIs
SET DATABASE TO DBWhereYourTableIs
Use YourTable
FOR i = 1 TO FCOUNT()
    ? DBGETPROP("YourTable."+FIELDS(i),"FIELD", "Comment")
NEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform