Delete a record from a UD table with a BPM

Yahoo Archive
1
Look into BPMs. If you search this list you should find some examples of
code to delete records via BPM.

You just need to attach the BPM to the Update and Delete methods on the
Quote/Order etc and have it remove the related records.

On Thu, Jun 7, 2012 at 4:25 PM, gregatnorgren <grodzewicz@...>wrote:

> **
>
>
> The company I am working at is using a UD table to hold workflow records
> for quotes and sales orders. Things like manager approvals for discounts
> and the like. There is a workflow and logic built around it that says
> certain types of approvals can't happen until others have occured. The
> problem we are running into is when a user deletes a line from the quote or
> sales order and there was a record associated with that line that record is
> still just sitting there. Some times this causes other approvals in the
> workflow to become hung up waiting on an approval for a line that doesn't
> exist any more. I am primarily a .NET programmer just learning 4GL. I need
> a method to remove these records from the UD table when an associated
> QuoteDtl or OrderDtl are deleted. Any help would be greatly appreciated. We
> are using Vantage 8.03.409c
>
>
>



--
*John Driggers*
*High End Dev, System Design, Profit Drinking*
*
**:: 904.404.9233*
*:: waffqle@...*
*:: NO FAXES*

*

*


[Non-text portions of this message have been removed]
2
The company I am working at is using a UD table to hold workflow records for quotes and sales orders. Things like manager approvals for discounts and the like. There is a workflow and logic built around it that says certain types of approvals can't happen until others have occured. The problem we are running into is when a user deletes a line from the quote or sales order and there was a record associated with that line that record is still just sitting there. Some times this causes other approvals in the workflow to become hung up waiting on an approval for a line that doesn't exist any more. I am primarily a .NET programmer just learning 4GL. I need a method to remove these records from the UD table when an associated QuoteDtl or OrderDtl are deleted. Any help would be greatly appreciated. We are using Vantage 8.03.409c