Hi Edhy -



Good Morning! I've learned a lot from your postings, so I thought I'd say Thanks while I am here.



Wouldn't the .Clear( ) only operate on the rows the BO retrieved?



________________

_____/ Regards,

____/ al




________________
_____/ Regards,
____/ al

Terry -



I am a relative newbie as well, so take this with a grain of salt. The BO's functionality would be limited to the data it has in it's datastore. As there were no records retrieved as a result of your Fill() the "other" rows (the 100 in the table on the backend) would not be affected by anything you do with the BO's data.



HTH



________________

_____/ Regards,

____/ al




________________
_____/ Regards,
____/ al

Hi Terry,

I believe BO.Clear will do the trick.

Edhy Rijo

I'm a newbie and trying to get my head around all of this. If I do a fill on a BO like the Following:" Select * from stock where 1 = 2" and do a BO.Count it is obviously 0 even though the table has 100 records. That is OK but why when I do BO.Save() does all of the records remain? I think it has to do with no changes in BO but if I really want to remove all of the previous records in the table what is the quickest way? No relationships to worry about just a table that hold previous data and now needs to get all new data???? TIA.