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>
Parameters
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).
|
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. |
Examples
Adding the same note to multiple records
Any existing notes for the specified records are overwritten:
NOTES IF MATCH(RECNO(),1,3,5,7) TEXT "note text"
Adding or append the same note to multiple records
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
Deleting notes from multiple records
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
Remarks
Deleting the RecordNote field
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.