Hi Gerard,

Why are you using the 2 overloads?  are you checking security for deleting the record? if not, just use one parameter of True to mark the record as deleted without saving it to the database.

Edhy Rijo

Hi Edhy.

I put following code into the BeforeDeleteEvent:

e.BusinessObject.DeleteCurrentRow(true, true);
e.Cancel = true;

It goes round in an infinite loop with following question: Are you sure you wish to delete the current record ? where I can select a yes or No button. My table only has about 10 records .

This is on a Standard maintenance form and I dont have any other code in there.

Hi Gerard,



You can handle the BO.BeforeDelete event and manipulate the delete routine as you wish and then set the e.Cancel to True as shown in the code below:

    Private Sub BizVendor1_BeforeDelete(e As MicroFour.StrataFrame.Business.BeforeDeleteEventArgs) Handles BizVendor1.BeforeDelete
         e.BusinessObject.DeleteCurrentRow(True)
         e.Cancel = True
     End Sub

Edhy Rijo

Hi Ivan. Tnaks for replying.

How do I access the DeleteCurrentRow method with the various over-rides from a SF Maintanace Form ?

Hi Gerard.

Have a look at the following:

DeleteCurrentRow() - There are three overloads to this method. Depending on the parameters passed, this method will behave differently.

• DeleteCurrentRow() - When this overload is called, the record being deleted is immediately removed from the server and the internal data table is updated.

• DeleteCurrentRow(OnlyMarkAsDeleted) - When OnlyMarkAsDeleted is given a value of True, the current row is deleted within the internal data table only and a Save() must be executed before the changes are reflected back to the server. This is recommended when deleting a large number of records.

• DeleteCurrentRow(CheckSecurity, OnlyMarkAsDeleted) - When a value of True is passed to the CheckSecurity parameter, a security check will be forced by raising the CheckSecurity event on the business object, allowing the developer to place any Security on Delete code. The OnlyMarkAsDeleted parameter behaves identically to the DeleteCurrentRow(OnlyMarkAsDeleted) overload described above.

Note: All deletion methods return the number of records affected by the deletion. If a zero is returned, no records were deleted from the server.

When I delete a row from within a Maintanance Form, I notice it deletes from the Database immediaitely, unlike when I edit rows, I can Undo before I save.

Is there a way of 'Holding' the deletes until I click on Save, so that any Deletes/ Edits are all done at the same time , an I am also given an option to 'Undo', for deletes