JavaScript Editor js editor     Web development 

Main Page

You can add descriptions to fields in a database table so it is easier to understand and update. When you select a field from a database table in the Project Manager, the comment text displays in the Description area of the Project Manager window.

To add a comment to a field

  1. Open the database containing the table.

  2. Open the table in the Table Designer.

  3. On the Fields tab, select the field that you want.

  4. In the Field comment box for the field, type the text for the description.

  5. Click OK.

For more information, see Table Designer (Visual FoxPro).

To add a comment to a field programmatically

  • Use the DBSETPROP(В ) function to set the Comment field property.

For more information, see DBSETPROP( ) Function.

For example, suppose you want to add a description to a unit price field in a table containing items in an order. The following code assigns the text, "Current retail price per unit" to the field:

В Copy Code
?DBSETPROP('OrdItems.Price', 'Field', 'Comment', ;
   'Current retail price per unit')

See Also

JavaScript Editor js editor     Web development