SELECT *, DELETED() as lDeleted FROM <table> etc.>Deleted records appear in the view with .F. in the last column. When I run the same select in the command window, deleted records have .T. in the last column.
SET DELETED OFF lcSource = _samples+'Data\Customer' DELETE FROM (m.lcSource) WHERE cust_id like 'A%' CREATE DATABASE dummy CREATE SQL VIEW myView as ; SELECT cust_id, company, DELETED() as lDeleted ; FROM ; (m.lcSource) USE dummy!myView BROWSE SELECT customer RECALL all CLOSE DATABASES all ERASE dummy.dbc ERASE dummy.dc*Cetin