You would create a pre-processing BPM on the update method, the query would be for RowMod = "A" only, since you can't change an existing part number no need to trap "U". As part of the query you would test if the part number is too long or has other issues. Part of your query could use the length() function "where length(ttpart.partnum) > 12", the lookup() function can be used in a similar fashion to locate characters you want to avoid such as "&" or "*".
If you just want to tell the user they have exceeded the rules you would then use an action of "raise exception". This would stop the record from being saved until the user corrected the issues.
If you want to transform the part number than use the action "execute ABL" choice and add code to transform the part number.
Jim Kinneman
Encompass Solutions, Inc.
If you just want to tell the user they have exceeded the rules you would then use an action of "raise exception". This would stop the record from being saved until the user corrected the issues.
If you want to transform the part number than use the action "execute ABL" choice and add code to transform the part number.
Jim Kinneman
Encompass Solutions, Inc.
--- In vantage@yahoogroups.com, Bhavik Rathod wrote:
>
> Hi,
>
> Here there is fix 13 digit part code.
> There are many parts wherein its 12 digit or 13 digit but with space...which is creating problem.
>
> I want to set BPM/Customization for part length and trim function.
>
> Can anybody let me know how to do it.
> I tried the data directive with condition "number of rows in designed..." but didn't success.
>
> Please share me idea in what way I can achieve it.
>
> Thanks & Regards,
>
> Bhavik M Rathod
>
> [Non-text portions of this message have been removed]
>