Set up the button on the UD table so that it changes a field to a specific value and then saves.
Then create a BPM that is triggered off that value to delete all the records.
Example:
When button is clicked change UD01.Number20 to equal 10.
Save.
Then the BPM goes:
For each ttUD01 no-lock where
ttUD01.Number20 = 10:
for each UD01 where
/*Criteria*/
If avail UD01 then do:
Delete UD01.
End.
End.
End.
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov@...>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of vantagewow
Sent: Tuesday, May 22, 2012 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Delete all button
What I want to do is ad a button to a UD table I created so it will delete all the data in my UD table at the same time.
Then create a BPM that is triggered off that value to delete all the records.
Example:
When button is clicked change UD01.Number20 to equal 10.
Save.
Then the BPM goes:
For each ttUD01 no-lock where
ttUD01.Number20 = 10:
for each UD01 where
/*Criteria*/
If avail UD01 then do:
Delete UD01.
End.
End.
End.
Marco Vissuet
Systems Engineering
Pacific Contours Corporation
Office (619) 670-3900
Fax (619) 670-1643
marcov@...<mailto:marcov@...>
http://www.pacificcontours.com/
"The information contained herein may be subject to the International Traffic in Arms Regulations (ITAR) Warning: - This document contains data whose export is restricted by the Arms Export Control Act (Title 22, U.S.C., Sec 2751, et seq.) as amended, or the Export Administration Act (Title 50, U.S.C., App 2401 et seq.) as amended. Violations of these export laws are subject to severe criminal and civil penalties. Disseminate in accordance with provisions of DoD Directive 5230.25.
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of vantagewow
Sent: Tuesday, May 22, 2012 10:26 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Delete all button
What I want to do is ad a button to a UD table I created so it will delete all the data in my UD table at the same time.
--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@...<mailto:jose@...>> wrote:
>
> What version are you on? 9XX??
> That code needs to be placed either on a BPM or on a .P file that gets
> excecuted, if you put it on a BPM you'd want to keep it disabled and only
> enable it when you want to run it.
>
> Tell us what your version is
>
>
>
> *Jose C Gomez*
> *Software Engineer*
> *
> *
> *checkout my new blog <http://www.usdoingstuff.com> *
> *
> *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/>
> <http://www.usdoingstuff.com>
>
> *Quis custodiet ipsos custodes?*
>
>
>
> On Tue, May 15, 2012 at 4:45 PM, John Driggers <waffqle@...<mailto:waffqle@...>> wrote:
>
> > Can you copy/paste the code you're using for us?
> > Also, where are you running it from? Straight from the open edge client? If
> > so you'll need to connect to the DB first.
> >
> > On Tue, May 15, 2012 at 4:41 PM, vantagewow <jsmith@...<mailto:jsmith@...>> wrote:
> >
> > > **
> > >
> > >
> > > When trying the for each code, I get this when tesing.
> > >
> > > Error: CS0116 - line 53 (405) - A namespace does not directly contain
> > > members such as fields or methods
> > >
> > > ** Compile Failed. **
> > >
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "vantagewow" <jsmith@> wrote:
> > > >
> > > > Progress
> > > >
> > > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek <rbucek@> wrote:
> > > > >
> > > > > Are you progress or sql on the back end?
> > > > >
> > > > > Rob Bucek
> > > > > Production Control Manager
> > > > > PH: (715) 284-5376 ext 311
> > > > > Mobile: (715)896-0590
> > > > > FAX: (715)284-4084
> > > > >
> > > > > (Click the logo to view our site)
> > > > >
> > > > >
> > > > > -----Original Message-----
> > > > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
> > > Behalf Of John Driggers
> > > > > Sent: Tuesday, May 15, 2012 12:44 PM
> > > > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > > > Subject: Re: [Vantage] Re: Delete all button
> > > > >
> > > > > A .P is just a progress script. They are written in ABL, Progress's
> > > proprietary language. There are a couple docs on their support site if
> > you
> > > want to learn it. It's pretty basic. If you can handle SQL, it's a walk
> > in
> > > the park.
> > > > > The code Jose gave you will work as is, just change the UDXX to the
> > UD
> > > table you're using.
> > > > >
> > > > > You can just write it in notepad, although you should also have an
> > > OpenEdge Client on your server that you can use.
> > > > >
> > > > > If you search the list there are several threads that detail how to
> > > place it on a schedule. In a nutshell you just create a new task through
> > > taskmgr and call:
> > > > > prowin.exe <some magical arguments I can't recall off the top of my
> > > head> <path to your .p>
> > > > >
> > > > > On Tue, May 15, 2012 at 1:36 PM, vantagewow <jsmith@> wrote:
> > > > >
> > > > > > **
> > > > > >
> > > > > >
> > > > > > That is kind of beyond me. Wouldn't know where to start writing a
> > .P
> > > > > > or how to even schedule?? Sorry for being so illiterate. Can you
> > > offer
> > > > > > some further details? We are progress, does that make a difference?
> > > > > >
> > > > > > Thanks
> > > > > >
> > > > > >
> > > > > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Jose Gomez <jose@> wrote:
> > > > > > >
> > > > > > > Write a simple. P that you can schedule to run
> > > > > > >
> > > > > > > For each udxx:
> > > > > > > Delete udxx.
> > > > > > > End.
> > > > > > > On May 15, 2012 1:00 PM, "vantagewow" <jsmith@> wrote:
> > > > > > >
> > > > > > > > **
> > > > > > > >
> > > > > > > >
> > > > > > > > Hello all!
> > > > > > > > I've searched high and low for this answer and was told I would
> > > > > > > > need
> > > > > > code
> > > > > > > > to create my delete all button.
> > > > > > > >
> > > > > > > > We have a custom UD table used to dump 26,000 lines of
> > > information
> > > > > > which
> > > > > > > > we can then run custom reports on to create forecasting
> > details.
> > > > > > > > Our customer updates this once a week so I don't want to have
> > to
> > > > > > > > manually delete 26,000 rows of records everyweek. Is there a
> > way
> > > > > > > > to create a
> > > > > > delete
> > > > > > > > all button? If so, could someone help me with the code?
> > > > > > > >
> > > > > > > > Thank you :)
> > > > > > > >
> > > > > > > >
> > > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > [Non-text portions of this message have been removed]
> > > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > --
> > > > > *John Driggers*
> > > > > *High End Dev, System Design, Profit Drinking*
> > > > > *
> > > > > **:: 904.404.9233*
> > > > > *:: waffqle@*
> > >
> > > > > *:: NO FAXES*
> > > > >
> > > > > *
> > > > >
> > > > > *
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > > > ------------------------------------
> > > > >
> > > > > 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/.<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
> > > > >
> > > >
> > >
> > >
> > >
> >
> >
> >
> > --
> > *John Driggers*
> > *High End Dev, System Design, Profit Drinking*
> > *
> > **:: 904.404.9233*
> > *:: waffqle@...*<mailto:waffqle@...*>
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > ------------------------------------
> >
> > 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/.<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]
>
[Non-text portions of this message have been removed]