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.

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

Hi Alex,

Thanks for the kind comments, I also learned a lot from others here and continue to do so everyday.

Yes, basically based on the comment in the SF source code, the BO.Clear method will do reset the data table with no records.

Edhy Rijo