Database Search

[soniix]

do i ever have to clear the table contents in my dataset if i do a new search? becaus if i use

 

adap.fill(ds,"table1)

 

it fills the table with the search results, but if i search again it doesnt empty the table1, its adding the new resulst to the end of the table, so i get more and more data in the table but not the last search results?

 

i tried this to clear the table out

 

ds.tables("table1").clear()

 

is there another way to populate a datatable only with the results no more no less?

[hog]

Any time I refresh a dataset I always use the clear method on it first.

[soniix]

thnx for ur help,seems thats the only way to do it :)