NOTES command

Creates, modifies, or removes a note associated with an individual record in an Analytics table.

Syntax

NOTES <IF test> <TEXT note_text> <APPEND> <CLEAR>

Name	Description
IF test optional	A conditional expression that must be true in order to process each record. The command is executed on only those records that satisfy the condition. Note The IF parameter is evaluated against only the records remaining in a table after any scope parameters have been applied (WHILE, FIRST, NEXT). If you do not specify an IF test, the note text is added to each record in the table If you specify an IF test and CLEAR, the notes for those records that meet the condition are deleted
TEXT note_text optional	The text to add as a note. note_text must be either a string enclosed in quotation marks, or a character expression.
APPEND optional	The note text is added to the end of any existing notes. If omitted, any existing notes are overwritten.
CLEAR optional	Notes are deleted. Even if all record notes in a table are deleted, the auto-generated RecordNote field is not deleted from the table layout.

Any existing notes for the specified records are overwritten:

NOTES IF MATCH(RECNO(),1,3,5,7) TEXT "note text"

Any existing notes for the specified records have the new note text appended:

NOTES IF MATCH(RECNO(),1,3,5,7) TEXT "note text" APPEND

All record notes in the table are deleted:

NOTES CLEAR

Notes for the specified records are deleted:

NOTES IF MATCH(RECNO(),1,3,5,7) CLEAR

Notes for records 1-100 are deleted:

NOTES IF RECNO() <= 100 CLEAR

To delete the RecordNote field from the table layout, and all notes in the table, use the DELETE NOTES command without any of the options specified.