BPM that can delete a Record

system · February 11, 2011, 4:27pm

Yes Call teh Business Object Delete from the BPM.

*Jose C Gomez*
*Software Engineer*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>

*Quis custodiet ipsos custodes?*

On Fri, Feb 11, 2011 at 4:16 PM, scottinct78 <spare@...>wrote:

>
>
> Is it possible for BPM to delete a record? I want to delete all 25,000+
> records in one of my UD## tables. Of if there is a better way to do it I am
> all ears?
>
>
>

[Non-text portions of this message have been removed]

system · February 9, 2011, 9:20pm

Is it possible for a BPM to delete a record? I tried to create an Pre action with 4GL code that was something like this.

for each UD01 where ud01.company = cur-comp.
run lib\updatetablebuffer.p(input BUFFER UD01:HANDLE, 'RowMod','d').
END.

I was able to get this code to set checkbox01 to true for every record, but it would not delete the records.

Is this possible? I was trying to clean up 29,000 records in UD01, and Service Connect is a slow pain in the butt.

Any suggestions would be helpful.

system · February 10, 2011, 9:53am

You could delete these directly via ODBC (Progress) or SQL Admin
Studio (delete from dbo.ud01 where company = 'whatever'). The UD tables
are completely safe to manipulate in this way.

If you have the updated Progress 'development kit' license (which you
can get free from your CAM) you can also issue a DELETE statement in
4GL.

-bws

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of scottinct78
Sent: Wednesday, February 09, 2011 9:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM that can delete a Record

Is it possible for a BPM to delete a record? I tried to create an Pre
action with 4GL code that was something like this.

for each UD01 where ud01.company = cur-comp.
run lib\updatetablebuffer.p(input BUFFER UD01:HANDLE,
'RowMod','d').
END.

I was able to get this code to set checkbox01 to true for every record,
but it would not delete the records.

Is this possible? I was trying to clean up 29,000 records in UD01, and
Service Connect is a slow pain in the butt.

Any suggestions would be helpful.

------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links

system · February 10, 2011, 9:58am

If you call a Business Object from your BPM you can delete the record
without even having to bypass the business logic.

On Thu, Feb 10, 2011 at 9:53 AM, Brian W. Spolarich <
bspolarich@...> wrote:

>
>
> You could delete these directly via ODBC (Progress) or SQL Admin
> Studio (delete from dbo.ud01 where company = 'whatever'). The UD tables
> are completely safe to manipulate in this way.
>
> If you have the updated Progress 'development kit' license (which you
> can get free from your CAM) you can also issue a DELETE statement in
> 4GL.
>
> -bws
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of scottinct78
> Sent: Wednesday, February 09, 2011 9:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BPM that can delete a Record
>
> Is it possible for a BPM to delete a record? I tried to create an Pre
> action with 4GL code that was something like this.
>
> for each UD01 where ud01.company = cur-comp.
> run lib\updatetablebuffer.p(input BUFFER UD01:HANDLE,
> 'RowMod','d').
> END.
>
> I was able to get this code to set checkbox01 to true for every record,
> but it would not delete the records.
>
> Is this possible? I was trying to clean up 29,000 records in UD01, and
> Service Connect is a slow pain in the butt.
>
> Any suggestions would be helpful.
>
> ------------------------------------
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
> and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
>
>
>

[Non-text portions of this message have been removed]

system · February 10, 2011, 10:02am

It can if you have the proper progress license installed. Do you have
an SQL database? If its just a UD table I wouldn't hesitate to use an
SQL statement to nuke the records. Or if you want to dump the entire
table, just truncate it.

Rob Bucek

Production Control Manager

PH: (715) 284-5376 ext 311

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of scottinct78
Sent: Wednesday, February 09, 2011 8:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM that can delete a Record

Is it possible for a BPM to delete a record? I tried to create an Pre
action with 4GL code that was something like this.

for each UD01 where ud01.company = cur-comp.
run lib\updatetablebuffer.p(input BUFFER UD01:HANDLE, 'RowMod','d').
END.

I was able to get this code to set checkbox01 to true for every record,
but it would not delete the records.

Is this possible? I was trying to clean up 29,000 records in UD01, and
Service Connect is a slow pain in the butt.

Any suggestions would be helpful.

[Non-text portions of this message have been removed]

system · February 10, 2011, 10:09am

I'd second your mention of UD tables. I'd be VERY hesitant to start zapping
records on any of the Epicor tables without using a BO. Things can get ugly
very quickly if you miss something.

On Thu, Feb 10, 2011 at 9:26 AM, Rob Bucek <rbucek@...> wrote:

>
>
> It can if you have the proper progress license installed. Do you have
> an SQL database? If its just a UD table I wouldn't hesitate to use an
> SQL statement to nuke the records. Or if you want to dump the entire
> table, just truncate it.
>
> Rob Bucek
>
> Production Control Manager
>
> PH: (715) 284-5376 ext 311
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of scottinct78
> Sent: Wednesday, February 09, 2011 8:21 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] BPM that can delete a Record
>
> Is it possible for a BPM to delete a record? I tried to create an Pre
> action with 4GL code that was something like this.
>
> for each UD01 where ud01.company = cur-comp.
> run lib\updatetablebuffer.p(input BUFFER UD01:HANDLE, 'RowMod','d').
> END.
>
> I was able to get this code to set checkbox01 to true for every record,
> but it would not delete the records.
>
> Is this possible? I was trying to clean up 29,000 records in UD01, and
> Service Connect is a slow pain in the butt.
>
> Any suggestions would be helpful.
>
> [Non-text portions of this message have been removed]
>
>
>

[Non-text portions of this message have been removed]

system · February 10, 2011, 11:17am

I have a process that will use the get rows that meet criteria, save them for log output, then delete them (archive and delete process) - for UD02. I do this each week. I just checked the time in service connect and for 34 records it took 9 seconds...

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of scottinct78
Sent: Wednesday, February 09, 2011 8:21 PM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM that can delete a Record

Is it possible for a BPM to delete a record? I tried to create an Pre action with 4GL code that was something like this.

for each UD01 where ud01.company = cur-comp.
run lib\updatetablebuffer.p(input BUFFER UD01:HANDLE, 'RowMod','d').
END.

I was able to get this code to set checkbox01 to true for every record, but it would not delete the records.

Is this possible? I was trying to clean up 29,000 records in UD01, and Service Connect is a slow pain in the butt.

Any suggestions would be helpful.

[Non-text portions of this message have been removed]

system · February 11, 2011, 4:16pm

Is it possible for BPM to delete a record? I want to delete all 25,000+ records in one of my UD## tables. Of if there is a better way to do it I am all ears?