You can do this with SQL Server, DB2, etc.  Just call a truncate on a table.  Create a method on the BO that is called "DeleteAll" or something along those lines, then TRUNCATE the table.  This is akin to the VFP "ZAP" except far more efficient.

Note: This will delete ALL records within the table.  That is the same thing a ZAP used to do.  If you want to delete within a certain crtiera, then just create a command or a sproc (as Keith mentioned) to delete within that group or records.

I had to do this and with many records in the BO it was slow (ZAP was awesome!!) so I did the delete via a stored procedure on the server (if your using SQL/DB2/Oracle/etc).

MicroFour.StrataFrame.Data.DataBasics.DataSources("").ExecuteStoredProcedure("rentitems_deleteitemsfororder", MicroFour.StrataFrame.Data.DbCommandExecutionType.ExecuteNonQuery, New SqlClient.SqlParameter("@ordnum", Me.BO_Orders.ordernum))

Keith Chisarik

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