How can I clear all the records from a TDataSource?

Question

I thought this would be simple but don't see a function that clears all records from the dataset of a TDataSource. Any ideas?

What kind of dataset? Some support that operation, some don't. — Ken White, Jul 17 '15 at 15:13

score 1 · Answer 1 · answered Oct 02 '14 at 16:52

1

There is no such function. You have to step through all records.

while ds.RecordCount>0 do
  ds.delete;

answered Oct 02 '14 at 16:52

user3640611

score 0 · Answer 2 · answered Jul 17 '15 at 14:38

0

try clear the DataSet with EmptyDataSet.. Example... ds.EmptyDataSet;

answered Jul 17 '15 at 14:38

1

This is only available for a `TClientDataSet`, and the poster has not indicated that a ClientDataSet is being used. – Ken White Jul 17 '15 at 15:22

2 Answers2