clear ado dataset

[kumori25]

hi,
i'm using adoqery to extract database data (using adoquery)for display in a dbgrid. this grid has to be refreshed each time new documents are added.
the problem that i have is that i allow users to add multiple documents (say 5), which are saved in a a cached dataset, and the 5 documents are updated to the database at one shot with updatebatch command. But i can't seem to clear the dataset with the commitupdate command. so my data in the datagrid shows not just the 5 recently added documents does anyone have any idea?

 

[svanels]

I would refire the query after the update. Unless you are using a table the dataset doesn't catch when the data on the server is updated

Steven van Els
SAvanEls@cq-link.sr

 

[kumori25]

hi
thanks for your help. i tried to do it but there was still an error.
also, when i fire the update command, the data cannot be inserted into the database at all, there is always an error

 

[yomyom]

Just a wild thought.
If your datasource has a time added field or if you add a time added field (set a field and add the time stamp)then you can filter your query based on excluding items before a certain time . This also means you can include items after a certain time.
Hope this helps.
Yomi.