Deleting records linked to a UDU

[Former Member]

Hi

I have developed an SBO 2005 application using a UDO. This UDO has one main table and 3 other tables linked to it.

I have a matrix which is linked to one of these transactions tables. All works well apart from when someone deletes a row from the matrix it deletes all the records including the master record.

Can any anyone suggest how I stop this please ?

Regards Andy

[Gianluigi · Accepted solution]

when you say

"when someone deletes a row from the matrix"

you mean using B1 or accessing directly the DB ?

[Former Member · Accepted solution]

Hi Gianluigi

I mean when someone selects the row, right mouse click and delete.

Regards Andy

[barend_morkel2 · Accepted solution]

Hi Andy,

There are a couple ways to disable this functionality,

but what about:

<b>If pVal.EventType = SAPbouiCOM.BoEventTypes.et_RIGHT_CLICK Then

BubbleEvent = False

End If</b>

this way you disable the showing of the right click menu.

[Former Member · Accepted solution]

Hi Barend

That's useful info but what I really want is for them to delete the record in the matrix but stop SAP from deleting the other records and also the header record.

That's my problem

Regards Andy

[barend_morkel2 · Accepted solution]

Hi Andy,

Right so what you want to do is intercept the delete command and manually perform the delete and not let the UDO delete the stuff:

If pVal.EventType = SAPbouiCOM.BoEventTypes.et_CLICK Then

'AND if this is the delete command on the right click menu

BubbleEvent = False

'No here you do the delete and the UDO will do nothing

End If

[Former Member · Accepted solution]

Hi Barend

Thanks for your advice

Regards Andy