BLANK Command Example

The following example opens the customer table in the testdata database. The contents of the first record are displayed. SCATTER is used to save the contents of the record to an array. The record is cleared with BLANK, and the contents of the record are displayed again. GATHER is used to restore the original record contents, and the restored record contents are displayed again.

CLOSE DATABASES
OPEN DATABASE (HOME(2) + 'data\testdata')
USE customer  && Open customer table

CLEAR
DISPLAY  && Displays the current record
SCATTER TO gaCustomer  && Create array with record contents
BLANK  && Clear the record
DISPLAY  && Displays the blank record 
GATHER FROM gaCustomer  && Restore original record contents
DISPLAY  && Display the restored record