Skip to content

    TDataSet.Refresh

    Refresh the records in the dataset.

    Declaration

    Source position: db.pas line 1940

    public 
procedure TDataSet.Refresh;

    Description

    Refresh posts any pending edits, and refetches the data in the dataset from the underlying database, and attempts to reposition the cursor on the same record as it was. This operation is not supported by all datasets, and should be used with care. The repositioning may not always succeed, in which case the cursor will be positioned on the first record in the dataset. This is in particular true for unidirectional datasets. Calling Refresh results in the triggering of the BeforeRefresh and AfterRefresh events.

    Errors

    Refreshing may fail if the underlying dataset descendent does not support it.

    See also

    Name Description
    TDataset.Close Close the dataset.
    TDataset.Open Activate the dataset: Fetch data into memory.
    BeforeRefresh Event triggered before the data is refreshed.
    AfterRefresh Event triggered after the data has been refreshed.