FieldComment()

FieldComment()

Category: Design

Syntax: FieldComment ( fileName ; fieldName )

Parameters: fileName ”the name of the open file where the field is located; fieldName ”the name of the field for which to return comments.

Description: Returns the contents of any comment that has been entered in Define Database for the specified field. The syntax Table::fieldName is required to reference fields outside of the current table context. (The safest approach is to use this method in all cases.)

Examples:

 FieldComment ( "myDatabase" ; "Contacts::FirstName") 

Returns the comment, if any, for the FirstName field as it appears in the table definition.

Comments:

FieldComment() is useful for documenting a database. Care must be taken, however, because literal references to fields can be broken when file, table, or field names are changed. FieldNames() and TableNames() can be used to dynamically investigate all field names and load the results from FieldComment() into tables for browsing.