>*!* program test_recall.prg >*!* demonstrate recall of deleted records during SELECT-SQL cursor creation with keywords READWRITE or/and NOFILTER >CLOSE DATABASES >SET EXCLUSIVE ON >SET SAFETY OFF >SELECT 0 >CREATE TABLE test_recall FREE (fid I(5) autoinc, fld2 N(6, 2)) >FOR lnRec = 1 TO 20 && Append 10 records > APPEND BLANK > REPLACE fld2 WITH 1 + 100 * RAND( ) && Insert random values >ENDFOR >DELETE FOR RECNO() > 10 >BROWSE TITLE "Table with deleted records. Click ESC" >SELECT * from test_recall INTO CURSOR test >BROWSE TITLE "Cursor with deleted records. Click ESC" >SELECT * from test_recall INTO CURSOR test READWRITE >BROWSE TITLE "Cursor created with READWRITE - deleted recalled. Click ESC" >SELECT * from test_recall INTO CURSOR test NOFILTER >BROWSE TITLE "Cursor created with NOFILTER - deleted recalled . Click ESC" >SELECT * from test_recall INTO CURSOR test READWRITE NOFILTER >BROWSE TITLE "Cursor created with READWRITE & NOFILTER - deleted recalled . Click ESC" >CLOSE DATABASES ALL >DELETE FILE test_recall.dbf >