NOTES command

Used to create, modify, or remove notes associated with individual records in ACL tables.

Syntax

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

Parameters

IF test

Optional. Specifies a condition that must be met. The command is only executed on records that pass the test.

TEXT note_text

Specifies that the note_text string should be added as a note. The note_text must be a string enclosed in quotation marks, or a Character expression.

APPEND

Specifies that the note_text string should be added to the end of any existing notes. If you omit the APPEND parameter, any existing notes are overwritten.

CLEAR

Specifies that the notes should be deleted. Even if all record notes in a table are deleted, the auto-generated RecordNote field is not deleted from the table layout.

Remarks

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 the CLEAR parameter, the notes for those records that meet the condition are deleted.

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

Examples

a. Add the same note to multiple records

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

Any exiting notes for the specified records are overwritten.

b. Add or append the same note to multiple records

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

Any exiting notes for the specified records have the new note text appended.

c. Delete notes from multiple records

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

Notes for the specified records are deleted.

NOTES IF RECNO() <= 100 CLEAR

Notes for records 1-100 are deleted.

Related reference
DELETE command


(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback