The TBufDataSet.Clear seems the equivalent of EmptyDataSet or EmptyTable of Delphi, i.e. remove all records leaving the dataset structure. But this seems to remove field definitions as well. Or, it does nothing.
When I tested,
BufDataSet1.Open;
BufDataSet1.Clear;
BufDataSet1.Open;
There are no change in data. The DBGrid is the same.
But if I do:
BufDataSet1.Close;
BufDataSet1.Clear;
BufDataSet1.Open;
Then the last command raise an error. No dataset exist or something.
Can anyone explain why to me?