>>>CLOSE DATABASES all >>> >>>CREATE TABLE test (field1 c(1)) >>>FOR x = 1 TO 10 >>> INSERT INTO test (field1) VALUES (chr(x+64)) >>>ENDFOR >>> >>>GOTO 8 >>>DELETE >>> >>>CLOSE DATABASES all >>>SET DELETED OFF >>>SET ANSI OFF >>>SET EXACT OFF >>> >>>WAIT WINDOW "Ansi off, Exact off" NoWait >>>SELECT * FROM test && browse should show record 8 as deleted >>>CLOSE DATABASES all >>>SET EXACT ON >>> >>>WAIT WINDOW "Ansi off, Exact ON" NoWait >>>SELECT * FROM test && browse should show no deleted records >>>CLOSE DATABASES all >>>SET EXACT OFF >>>SET ANSI ON >>> >>>WAIT WINDOW "Ansi ON, Exact off" NoWait >>>SELECT * FROM test && browse should show no deleted records >>>CLOSE DATABASES all >>>SET EXACT OFF >>>SET ANSI OFF >>> >>>WAIT WINDOW "Ansi off, Exact off" NoWait >>>SELECT * FROM test && browse should show record 8 deleted again >>>