Hi,

I have a a BO with related records and at some point I would like to delete all records in the BO pretty much like a VFP DELETE ALL or ZAP, how to do this?

I have tried using the BO's GetEnumerable() I saw in thread like this:

But the above code is not deleting all rows in the BO, so I must be missing something here.

Edhy Rijo

Be careful with using Truncate.  It is handled differently in Log Operations.   If the table has a FOREIGN KEY constraint you cannot use truncate.  In addition, no Triggers will be fired as it is a non-logged operation.   I generally frown on the use of Truncate in any operational code for those two reasons.

Richard

We never use TRUNCATE in code either...except when the table truly needs to be cleared out and reset, and which time the code should accomodate this.  The context of this post is more in regards to the replacement method of ZAP in FoxPro for a similar method in SQL Server.  This would be the method in this case.

Thanks to all for the posting.

I decided to use the following code in this particular case...

This is very fast and will only do one trip to the database to remove all deleted records.

Edhy Rijo

That is a good solution.  You could also just do a while as well:

Thanks you Trent,

I am learning a lot every day. 

So far this project is coming out pretty good, and I fall in love with the new Enhanced ListView, those enhancements are really a time saver for developers and I am glad you incorporated them.  

If possible please, let me know when will be the next beta release that will include the added property to handle the delete flag.

Edhy Rijo

Yeah, I plan on posting a new build soon...but I have the DDT torn up a little bit right now, so I need to get "Humpty Dumpty" put back together again before I post a new build .  I am using it every day so it isn't necessarily the functionality, but rather the UI.  The DDT is getting a face lift that will continue over the next several updates so that we can incorporate some new functionality that we have planned.

Thanks for the info.

No rush on my part, so far I am using my temporary fix, so I can live with it until the next release.

Edhy Rijo