Home

Select current data

Select current and deleted data

From .NET code

Use DataInterface.SelectCurrent, as demonstrated in the following code sample. For more information, see the documentation.

    DataTable result = dataInterface.SelectCurrent(
        "tblCompany", "CompanyID=12");

From native SQL

Use SQL Retroview's provided views, which filter out deleted rows.

    
    SELECT * FROM tblCompany_Current