How to: Add Comments to Views

You can add comments to the views you create. Comments that you add to a view are stored in the database (.dbc) file that contains the view.

To add a comment to a view

  1. Open the view in the View Designer.

  2. On the Query menu, click Comments.

  3. In the Comment box, type comments you want to add to the view.

  4. When you are finished, click OK.

You can see the comments for a view by opening the SQL window. For more information, see How to: View and Edit SQL Statements for Views.

To edit comments for a view

  1. Open the view in the View Designer.

  2. Open the SQL window for the view.

  3. In the SQL window, edit the DBSETPROP( ) function call containing the Comment view property.

  4. When you are finished, close the SQL window.

For more information, see How to: View and Edit SQL Statements for Views.

To add or edit a comment to a view programmatically

  • Use the DBSETPROP( ) function with the Comment property for the view.

For more information, see DBSETPROP( ) Function.

See Also

Tasks

How to: Edit Views

Other Resources

Managing Views
Working with Views (Visual FoxPro)