BPM Key Word Blank Title 73299

system · January 23, 2009, 5:04pm

Thank you so much Andrew that works perfect.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
andrew.tapper
Sent: Friday, January 23, 2009 4:48 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Key Word

Charlie,

Change the code to the following:

find first ttOrderDtl where ttOrderDtl.RowMod = 'U' or
ttOrderDtl.RowMod = 'A' no-lock.
if available ttOrderDtl then do:
assign ttOrderDtl.Date10 = TODAY.
end.

Basically the first line of the original code changes to the first two
of the above. Again watch out for line wrapping if you copy and paste.

Andrew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:

>
> I believe I finally got the code correct but now when the BPM fires

I get

> the another user has changed this record refresh and make your

changes again

> message. Any help on what is causing this?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of

> andrew.tapper
> Sent: Friday, January 23, 2009 2:50 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> Yes.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > Are there suppose to be periods at the end of the first and third

line?

> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > andrew.tapper
> > Sent: Friday, January 23, 2009 1:50 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > I tried my code and it works, but I was able to recreate that error
> > message by putting a comma between no-lock & no-error. There should
> > only be a space between these two commands.
> >
> > Andrew
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > I typed your code in just as it appears and it gives an error
> > stating do not
> > > understand after no-lock.
> > >
> > >
> > >
> > > We need the check box to stay checked because we have a dash board
> > where we
> > > are doing some tracking based off it and once that check box and a
> > series of
> > > others are checked showing that a bunch of different operations have
> > been
> > > completed it falls off the dash board.
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > andrew.tapper
> > > Sent: Friday, January 23, 2009 9:32 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BPM Key Word
> > >
> > >
> > >
> > > I forgot about the canned condition of "the specified field has been
> > > changed from any to any". I have never tried it.
> > >
> > > I clear the check boxes so that I can retrigger the action easily.
> > > Just a standard that I have adopted.
> > >
> > > Andrew
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > "Charlie
> > > Wilson" <foamdesigncsw@>
> > > wrote:
> > > >
> > > > Can't I set up a condition that basically checks to see if the
> > check box
> > > > changed from false to true or null to true before executing your
> > > code? If it
> > > > is true and changes to true wouldn't the action not trigger or

am I

> > > missing
> > > > something?
> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com] On
> > > Behalf Of
> > > > andrew.tapper
> > > > Sent: Thursday, January 22, 2009 6:33 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: BPM Key Word
> > > >
> > > >
> > > >
> > > > Charlie,
> > > >
> > > > First let me tell you to stay away from orderdtl.date01 if you
> are on
> > > > 8.03.405a. (see my post #72101)
> > > >
> > > > Setup a pre-process method with the condition on you checkbox.

Then

> > > > for 4gl code try:
> > > >
> > > > find first ttOrderDtl no-lock no-error.
> > > > if available ttOrderDtl then do:
> > > > assign ttOrderDtl.Date10 = TODAY.
> > > > end.
> > > >
> > > > Finally you will probably want to add an action that unchecks the
> > > > checkbox, otherwise everytime the BPM gets triggered (I am

assuming

> > > > you are doing this to the Update method) the date will get

updated.

> > > >
> > > > BTW. I suggest retyping the above code into the 4GL editor. I
> have had
> > > > line wrapping problems with cutting and pasting.
> > > >
> > > > Good Luck,
> > > >
> > > > Andrew
> > > >
> > > > PS, Thank Nigel for this, since all I know I learned from him.
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com,

> > > "Charlie
> > > > Wilson" <foamdesigncsw@>
> > > > wrote:
> > > > >
> > > > > I have done very simple things in 4gl but mostly returning rows
> > > that get
> > > > > counted that kinda thing.
> > > > >
> > > > >
> > > > >
> > > > > Basically I need to set ttorderdtl.date01 too today's date

if the

> > > > > ttorderdtl.checkbox01 changed from false to true or from null to
> > > > true. Can
> > > > > anyone give me an example of something similar to this in 4gl?
> > > > >
> > > > >
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > _____
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> > .com] On
> > > > Behalf Of
> > > > > bw2868bond
> > > > > Sent: Thursday, January 22, 2009 10:59 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > > Subject: [Vantage] Re: BPM Key Word
> > > > >
> > > > >
> > > > >
> > > > > Sadly, that is one of the severe limitations of the 'canned'
> > actions.
> > > > > To be able to set fields to constants like DCD-USERID or system
> > > > > variables like Today, requires you to do it in 4gl code. Even
> > trying
> > > > > to include the user id in an email requires the entire email
> action
> > > > > be done in 4gl :-(
> > > > >
> > > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com,
> > > > "Charlie
> > > > > Wilson" <foamdesigncsw@>
> > > > > wrote:
> > > > > >
> > > > > > I'm using one of the canned actions called "set the specific
> > field
> > > > > of the
> > > > > > changed row to value". It tells me that today is not a valid
> > entry.
> > > > > >
> > > > > >
> > > > > >
> > > > > > ~Charlie
> > > > > >
> > > > > > _____
> > > > > >
> > > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com
> > > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> > > .com] On
> > > > > Behalf Of
> > > > > > Carl Peterson
> > > > > > Sent: Thursday, January 22, 2009 10:43 AM
> > > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > > > Subject: RE: [Vantage] BPM Key Word
> > > > > >
> > > > > >
> > > > > >
> > > > > > Datefield = today. You can also do math on today, too. Today
> - 1
> > > > > and so
> > > > > > on.
> > > > > >
> > > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com
> > > > > > [mailto:vantage@yahoogroups <mailto:vantage%
> > > > > 40yahoogroups.com> .com] On
> > > > > > Behalf Of
> > > > > > Charlie Wilson
> > > > > > Sent: Thursday, January 22, 2009 10:29 AM
> > > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > > > Subject: [Vantage] BPM Key Word
> > > > > >
> > > > > > All,
> > > > > >
> > > > > > I'm working on a bpm and I am using the action that allows
> you to
> > > > > set a
> > > > > > specific field to a value. I'm setting a date field and was
> > > > > wondering if
> > > > > > there was some sort of key word I could enter that would

set it

> > > > > today's
> > > > > > date.
> > > > > >
> > > > > > Thank you
> > > > > >
> > > > > > ~Charlie
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > > > No virus found in this incoming message.
> > > > > > Checked by AVG - http://www.avg <http://www.avg
> > > <http://www.avg <http://www.avg <http://www.avg

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

> com> com> com>
> > > > com> com
> > > > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release
> Date:
> > > > > 1/21/2009
> > > > > > 7:07 AM
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - http://www.avg <http://www.avg
> > <http://www.avg <http://www.avg <http://www.avg <http://www.avg.com>

com> com> com>

> > > com> com
> > > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release

Date:

> > > > 1/21/2009
> > > > > 7:07 AM
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - http://www.avg <http://www.avg
> <http://www.avg <http://www.avg <http://www.avg.com> com> com>
> > com> com
> > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > > 1/22/2009
> > > > 7:08 AM
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

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

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/23/2009
> > > 7:28 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg <http://www.avg.com>

com> com

> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/23/2009
> > 7:28 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/23/2009

> 7:28 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/23/2009
7:28 AM

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

system · January 22, 2009, 10:29am

All,

I'm working on a bpm and I am using the action that allows you to set a
specific field to a value. I'm setting a date field and was wondering if
there was some sort of key word I could enter that would set it today's
date.

Thank you

~Charlie

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

system · January 22, 2009, 10:43am

Datefield = today. You can also do math on today, too. Today - 1 and so
on.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Charlie Wilson
Sent: Thursday, January 22, 2009 10:29 AM
To: vantage@yahoogroups.com
Subject: [Vantage] BPM Key Word

All,

I'm working on a bpm and I am using the action that allows you to set a
specific field to a value. I'm setting a date field and was wondering if
there was some sort of key word I could enter that would set it today's
date.

Thank you

~Charlie

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

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

system · January 22, 2009, 10:50am

I'm using one of the canned actions called "set the specific field of the
changed row to value". It tells me that today is not a valid entry.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Carl Peterson
Sent: Thursday, January 22, 2009 10:43 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BPM Key Word

Datefield = today. You can also do math on today, too. Today - 1 and so
on.

From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of
Charlie Wilson
Sent: Thursday, January 22, 2009 10:29 AM
To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
Subject: [Vantage] BPM Key Word

All,

I'm working on a bpm and I am using the action that allows you to set a
specific field to a value. I'm setting a date field and was wondering if
there was some sort of key word I could enter that would set it today's
date.

Thank you

~Charlie

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

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

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/21/2009
7:07 AM

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

system · January 22, 2009, 10:58am

Sadly, that is one of the severe limitations of the 'canned' actions.
To be able to set fields to constants like DCD-USERID or system
variables like Today, requires you to do it in 4gl code. Even trying
to include the user id in an email requires the entire email action
be done in 4gl :-(

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:

>
> I'm using one of the canned actions called "set the specific field

of the

> changed row to value". It tells me that today is not a valid entry.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> Carl Peterson
> Sent: Thursday, January 22, 2009 10:43 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BPM Key Word
>
>
>
> Datefield = today. You can also do math on today, too. Today - 1

and so

> on.
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%

40yahoogroups.com> .com] On

> Behalf Of
> Charlie Wilson
> Sent: Thursday, January 22, 2009 10:29 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] BPM Key Word
>
> All,
>
> I'm working on a bpm and I am using the action that allows you to

set a

> specific field to a value. I'm setting a date field and was

wondering if

> there was some sort of key word I could enter that would set it

today's

> date.
>
> Thank you
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
>
> [Non-text portions of this message have been removed]
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/21/2009

> 7:07 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 22, 2009, 11:04am

I have done very simple things in 4gl but mostly returning rows that get
counted that kinda thing.

Basically I need to set ttorderdtl.date01 too today's date if the
ttorderdtl.checkbox01 changed from false to true or from null to true. Can
anyone give me an example of something similar to this in 4gl?

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
bw2868bond
Sent: Thursday, January 22, 2009 10:59 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Key Word

Sadly, that is one of the severe limitations of the 'canned' actions.
To be able to set fields to constants like DCD-USERID or system
variables like Today, requires you to do it in 4gl code. Even trying
to include the user id in an email requires the entire email action
be done in 4gl :-(

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:

>
> I'm using one of the canned actions called "set the specific field

of the

> changed row to value". It tells me that today is not a valid entry.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of

> Carl Peterson
> Sent: Thursday, January 22, 2009 10:43 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: RE: [Vantage] BPM Key Word
>
>
>
> Datefield = today. You can also do math on today, too. Today - 1

and so

> on.
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%

40yahoogroups.com> .com] On

> Behalf Of
> Charlie Wilson
> Sent: Thursday, January 22, 2009 10:29 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] BPM Key Word
>
> All,
>
> I'm working on a bpm and I am using the action that allows you to

set a

> specific field to a value. I'm setting a date field and was

wondering if

> there was some sort of key word I could enter that would set it

today's

> date.
>
> Thank you
>
> ~Charlie
>
> [Non-text portions of this message have been removed]
>
>
> [Non-text portions of this message have been removed]
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/21/2009

> 7:07 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/21/2009
7:07 AM

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

system · January 22, 2009, 6:32pm

Charlie,

First let me tell you to stay away from orderdtl.date01 if you are on
8.03.405a. (see my post #72101)

Setup a pre-process method with the condition on you checkbox. Then
for 4gl code try:

find first ttOrderDtl no-lock no-error.
if available ttOrderDtl then do:
assign ttOrderDtl.Date10 = TODAY.
end.

Finally you will probably want to add an action that unchecks the
checkbox, otherwise everytime the BPM gets triggered (I am assuming
you are doing this to the Update method) the date will get updated.

BTW. I suggest retyping the above code into the 4GL editor. I have had
line wrapping problems with cutting and pasting.

Good Luck,

Andrew

PS, Thank Nigel for this, since all I know I learned from him.

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:

>
> I have done very simple things in 4gl but mostly returning rows that get
> counted that kinda thing.
>
>
>
> Basically I need to set ttorderdtl.date01 too today's date if the
> ttorderdtl.checkbox01 changed from false to true or from null to

true. Can

> anyone give me an example of something similar to this in 4gl?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> bw2868bond
> Sent: Thursday, January 22, 2009 10:59 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> Sadly, that is one of the severe limitations of the 'canned' actions.
> To be able to set fields to constants like DCD-USERID or system
> variables like Today, requires you to do it in 4gl code. Even trying
> to include the user id in an email requires the entire email action
> be done in 4gl :-(
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > I'm using one of the canned actions called "set the specific field
> of the
> > changed row to value". It tells me that today is not a valid entry.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > Carl Peterson
> > Sent: Thursday, January 22, 2009 10:43 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] BPM Key Word
> >
> >
> >
> > Datefield = today. You can also do math on today, too. Today - 1
> and so
> > on.
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com] On
> > Behalf Of
> > Charlie Wilson
> > Sent: Thursday, January 22, 2009 10:29 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] BPM Key Word
> >
> > All,
> >
> > I'm working on a bpm and I am using the action that allows you to
> set a
> > specific field to a value. I'm setting a date field and was
> wondering if
> > there was some sort of key word I could enter that would set it
> today's
> > date.
> >
> > Thank you
> >
> > ~Charlie
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg.com> com
> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/21/2009
> > 7:07 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/21/2009

> 7:07 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 23, 2009, 7:17am

Can't I set up a condition that basically checks to see if the check box
changed from false to true or null to true before executing your code? If it
is true and changes to true wouldn't the action not trigger or am I missing
something?

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
andrew.tapper
Sent: Thursday, January 22, 2009 6:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Key Word

Charlie,

First let me tell you to stay away from orderdtl.date01 if you are on
8.03.405a. (see my post #72101)

Setup a pre-process method with the condition on you checkbox. Then
for 4gl code try:

find first ttOrderDtl no-lock no-error.
if available ttOrderDtl then do:
assign ttOrderDtl.Date10 = TODAY.
end.

Finally you will probably want to add an action that unchecks the
checkbox, otherwise everytime the BPM gets triggered (I am assuming
you are doing this to the Update method) the date will get updated.

BTW. I suggest retyping the above code into the 4GL editor. I have had
line wrapping problems with cutting and pasting.

Good Luck,

Andrew

PS, Thank Nigel for this, since all I know I learned from him.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:

>
> I have done very simple things in 4gl but mostly returning rows that get
> counted that kinda thing.
>
>
>
> Basically I need to set ttorderdtl.date01 too today's date if the
> ttorderdtl.checkbox01 changed from false to true or from null to

true. Can

> anyone give me an example of something similar to this in 4gl?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of

> bw2868bond
> Sent: Thursday, January 22, 2009 10:59 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> Sadly, that is one of the severe limitations of the 'canned' actions.
> To be able to set fields to constants like DCD-USERID or system
> variables like Today, requires you to do it in 4gl code. Even trying
> to include the user id in an email requires the entire email action
> be done in 4gl :-(
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > I'm using one of the canned actions called "set the specific field
> of the
> > changed row to value". It tells me that today is not a valid entry.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > Carl Peterson
> > Sent: Thursday, January 22, 2009 10:43 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: RE: [Vantage] BPM Key Word
> >
> >
> >
> > Datefield = today. You can also do math on today, too. Today - 1
> and so
> > on.
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%
> 40yahoogroups.com> .com] On
> > Behalf Of
> > Charlie Wilson
> > Sent: Thursday, January 22, 2009 10:29 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] BPM Key Word
> >
> > All,
> >
> > I'm working on a bpm and I am using the action that allows you to
> set a
> > specific field to a value. I'm setting a date field and was
> wondering if
> > there was some sort of key word I could enter that would set it
> today's
> > date.
> >
> > Thank you
> >
> > ~Charlie
> >
> > [Non-text portions of this message have been removed]
> >
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg <http://www.avg.com>

com> com

> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/21/2009
> > 7:07 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/21/2009

> 7:07 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/22/2009
7:08 AM

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

system · January 23, 2009, 9:32am

I forgot about the canned condition of "the specified field has been
changed from any to any". I have never tried it.

I clear the check boxes so that I can retrigger the action easily.
Just a standard that I have adopted.

Andrew

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:

>
> Can't I set up a condition that basically checks to see if the check box
> changed from false to true or null to true before executing your

code? If it

> is true and changes to true wouldn't the action not trigger or am I

missing

> something?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> andrew.tapper
> Sent: Thursday, January 22, 2009 6:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> Charlie,
>
> First let me tell you to stay away from orderdtl.date01 if you are on
> 8.03.405a. (see my post #72101)
>
> Setup a pre-process method with the condition on you checkbox. Then
> for 4gl code try:
>
> find first ttOrderDtl no-lock no-error.
> if available ttOrderDtl then do:
> assign ttOrderDtl.Date10 = TODAY.
> end.
>
> Finally you will probably want to add an action that unchecks the
> checkbox, otherwise everytime the BPM gets triggered (I am assuming
> you are doing this to the Update method) the date will get updated.
>
> BTW. I suggest retyping the above code into the 4GL editor. I have had
> line wrapping problems with cutting and pasting.
>
> Good Luck,
>
> Andrew
>
> PS, Thank Nigel for this, since all I know I learned from him.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > I have done very simple things in 4gl but mostly returning rows

that get

> > counted that kinda thing.
> >
> >
> >
> > Basically I need to set ttorderdtl.date01 too today's date if the
> > ttorderdtl.checkbox01 changed from false to true or from null to
> true. Can
> > anyone give me an example of something similar to this in 4gl?
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > bw2868bond
> > Sent: Thursday, January 22, 2009 10:59 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > Sadly, that is one of the severe limitations of the 'canned' actions.
> > To be able to set fields to constants like DCD-USERID or system
> > variables like Today, requires you to do it in 4gl code. Even trying
> > to include the user id in an email requires the entire email action
> > be done in 4gl :-(
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > I'm using one of the canned actions called "set the specific field
> > of the
> > > changed row to value". It tells me that today is not a valid entry.
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > Carl Peterson
> > > Sent: Thursday, January 22, 2009 10:43 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: RE: [Vantage] BPM Key Word
> > >
> > >
> > >
> > > Datefield = today. You can also do math on today, too. Today - 1
> > and so
> > > on.
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%
> > 40yahoogroups.com> .com] On
> > > Behalf Of
> > > Charlie Wilson
> > > Sent: Thursday, January 22, 2009 10:29 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] BPM Key Word
> > >
> > > All,
> > >
> > > I'm working on a bpm and I am using the action that allows you to
> > set a
> > > specific field to a value. I'm setting a date field and was
> > wondering if
> > > there was some sort of key word I could enter that would set it
> > today's
> > > date.
> > >
> > > Thank you
> > >
> > > ~Charlie
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

<http://www.avg.com>

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/21/2009
> > > 7:07 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg.com> com
> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/21/2009
> > 7:07 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/22/2009

> 7:08 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 23, 2009, 10:42am

I typed your code in just as it appears and it gives an error stating do not
understand after no-lock.

We need the check box to stay checked because we have a dash board where we
are doing some tracking based off it and once that check box and a series of
others are checked showing that a bunch of different operations have been
completed it falls off the dash board.

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
andrew.tapper
Sent: Friday, January 23, 2009 9:32 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Key Word

I forgot about the canned condition of "the specified field has been
changed from any to any". I have never tried it.

I clear the check boxes so that I can retrigger the action easily.
Just a standard that I have adopted.

Andrew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:

>
> Can't I set up a condition that basically checks to see if the check box
> changed from false to true or null to true before executing your

code? If it

> is true and changes to true wouldn't the action not trigger or am I

missing

> something?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of

> andrew.tapper
> Sent: Thursday, January 22, 2009 6:33 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> Charlie,
>
> First let me tell you to stay away from orderdtl.date01 if you are on
> 8.03.405a. (see my post #72101)
>
> Setup a pre-process method with the condition on you checkbox. Then
> for 4gl code try:
>
> find first ttOrderDtl no-lock no-error.
> if available ttOrderDtl then do:
> assign ttOrderDtl.Date10 = TODAY.
> end.
>
> Finally you will probably want to add an action that unchecks the
> checkbox, otherwise everytime the BPM gets triggered (I am assuming
> you are doing this to the Update method) the date will get updated.
>
> BTW. I suggest retyping the above code into the 4GL editor. I have had
> line wrapping problems with cutting and pasting.
>
> Good Luck,
>
> Andrew
>
> PS, Thank Nigel for this, since all I know I learned from him.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > I have done very simple things in 4gl but mostly returning rows

that get

> > counted that kinda thing.
> >
> >
> >
> > Basically I need to set ttorderdtl.date01 too today's date if the
> > ttorderdtl.checkbox01 changed from false to true or from null to
> true. Can
> > anyone give me an example of something similar to this in 4gl?
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > bw2868bond
> > Sent: Thursday, January 22, 2009 10:59 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > Sadly, that is one of the severe limitations of the 'canned' actions.
> > To be able to set fields to constants like DCD-USERID or system
> > variables like Today, requires you to do it in 4gl code. Even trying
> > to include the user id in an email requires the entire email action
> > be done in 4gl :-(
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > I'm using one of the canned actions called "set the specific field
> > of the
> > > changed row to value". It tells me that today is not a valid entry.
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > Carl Peterson
> > > Sent: Thursday, January 22, 2009 10:43 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: RE: [Vantage] BPM Key Word
> > >
> > >
> > >
> > > Datefield = today. You can also do math on today, too. Today - 1
> > and so
> > > on.
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%
> > 40yahoogroups.com> .com] On
> > > Behalf Of
> > > Charlie Wilson
> > > Sent: Thursday, January 22, 2009 10:29 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] BPM Key Word
> > >
> > > All,
> > >
> > > I'm working on a bpm and I am using the action that allows you to
> > set a
> > > specific field to a value. I'm setting a date field and was
> > wondering if
> > > there was some sort of key word I could enter that would set it
> > today's
> > > date.
> > >
> > > Thank you
> > >
> > > ~Charlie
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

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

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/21/2009
> > > 7:07 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg <http://www.avg.com>

com> com

> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/21/2009
> > 7:07 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/22/2009

> 7:08 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/23/2009
7:28 AM

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

system · January 23, 2009, 1:50pm

I tried my code and it works, but I was able to recreate that error
message by putting a comma between no-lock & no-error. There should
only be a space between these two commands.

Andrew

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:

>
> I typed your code in just as it appears and it gives an error

stating do not

> understand after no-lock.
>
>
>
> We need the check box to stay checked because we have a dash board

where we

> are doing some tracking based off it and once that check box and a

series of

> others are checked showing that a bunch of different operations have

been

> completed it falls off the dash board.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> andrew.tapper
> Sent: Friday, January 23, 2009 9:32 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> I forgot about the canned condition of "the specified field has been
> changed from any to any". I have never tried it.
>
> I clear the check boxes so that I can retrigger the action easily.
> Just a standard that I have adopted.
>
> Andrew
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > Can't I set up a condition that basically checks to see if the

check box

> > changed from false to true or null to true before executing your
> code? If it
> > is true and changes to true wouldn't the action not trigger or am I
> missing
> > something?
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > andrew.tapper
> > Sent: Thursday, January 22, 2009 6:33 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > Charlie,
> >
> > First let me tell you to stay away from orderdtl.date01 if you are on
> > 8.03.405a. (see my post #72101)
> >
> > Setup a pre-process method with the condition on you checkbox. Then
> > for 4gl code try:
> >
> > find first ttOrderDtl no-lock no-error.
> > if available ttOrderDtl then do:
> > assign ttOrderDtl.Date10 = TODAY.
> > end.
> >
> > Finally you will probably want to add an action that unchecks the
> > checkbox, otherwise everytime the BPM gets triggered (I am assuming
> > you are doing this to the Update method) the date will get updated.
> >
> > BTW. I suggest retyping the above code into the 4GL editor. I have had
> > line wrapping problems with cutting and pasting.
> >
> > Good Luck,
> >
> > Andrew
> >
> > PS, Thank Nigel for this, since all I know I learned from him.
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > I have done very simple things in 4gl but mostly returning rows
> that get
> > > counted that kinda thing.
> > >
> > >
> > >
> > > Basically I need to set ttorderdtl.date01 too today's date if the
> > > ttorderdtl.checkbox01 changed from false to true or from null to
> > true. Can
> > > anyone give me an example of something similar to this in 4gl?
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > bw2868bond
> > > Sent: Thursday, January 22, 2009 10:59 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BPM Key Word
> > >
> > >
> > >
> > > Sadly, that is one of the severe limitations of the 'canned'

actions.

> > > To be able to set fields to constants like DCD-USERID or system
> > > variables like Today, requires you to do it in 4gl code. Even

trying

> > > to include the user id in an email requires the entire email action
> > > be done in 4gl :-(
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > "Charlie
> > > Wilson" <foamdesigncsw@>
> > > wrote:
> > > >
> > > > I'm using one of the canned actions called "set the specific

field

> > > of the
> > > > changed row to value". It tells me that today is not a valid

entry.

> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com] On
> > > Behalf Of
> > > > Carl Peterson
> > > > Sent: Thursday, January 22, 2009 10:43 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: RE: [Vantage] BPM Key Word
> > > >
> > > >
> > > >
> > > > Datefield = today. You can also do math on today, too. Today - 1
> > > and so
> > > > on.
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > [mailto:vantage@yahoogroups <mailto:vantage%
> > > 40yahoogroups.com> .com] On
> > > > Behalf Of
> > > > Charlie Wilson
> > > > Sent: Thursday, January 22, 2009 10:29 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] BPM Key Word
> > > >
> > > > All,
> > > >
> > > > I'm working on a bpm and I am using the action that allows you to
> > > set a
> > > > specific field to a value. I'm setting a date field and was
> > > wondering if
> > > > there was some sort of key word I could enter that would set it
> > > today's
> > > > date.
> > > >
> > > > Thank you
> > > >
> > > > ~Charlie
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - http://www.avg <http://www.avg
> <http://www.avg <http://www.avg.com> com>
> > com> com
> > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > > 1/21/2009
> > > > 7:07 AM
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

<http://www.avg.com>

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/21/2009
> > > 7:07 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg.com> com
> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/22/2009
> > 7:08 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/23/2009

> 7:28 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 23, 2009, 1:59pm

Are there suppose to be periods at the end of the first and third line?

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
andrew.tapper
Sent: Friday, January 23, 2009 1:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Key Word

I tried my code and it works, but I was able to recreate that error
message by putting a comma between no-lock & no-error. There should
only be a space between these two commands.

Andrew

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:

>
> I typed your code in just as it appears and it gives an error

stating do not

> understand after no-lock.
>
>
>
> We need the check box to stay checked because we have a dash board

where we

> are doing some tracking based off it and once that check box and a

series of

> others are checked showing that a bunch of different operations have

been

> completed it falls off the dash board.
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of

> andrew.tapper
> Sent: Friday, January 23, 2009 9:32 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> I forgot about the canned condition of "the specified field has been
> changed from any to any". I have never tried it.
>
> I clear the check boxes so that I can retrigger the action easily.
> Just a standard that I have adopted.
>
> Andrew
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > Can't I set up a condition that basically checks to see if the

check box

> > changed from false to true or null to true before executing your
> code? If it
> > is true and changes to true wouldn't the action not trigger or am I
> missing
> > something?
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > andrew.tapper
> > Sent: Thursday, January 22, 2009 6:33 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > Charlie,
> >
> > First let me tell you to stay away from orderdtl.date01 if you are on
> > 8.03.405a. (see my post #72101)
> >
> > Setup a pre-process method with the condition on you checkbox. Then
> > for 4gl code try:
> >
> > find first ttOrderDtl no-lock no-error.
> > if available ttOrderDtl then do:
> > assign ttOrderDtl.Date10 = TODAY.
> > end.
> >
> > Finally you will probably want to add an action that unchecks the
> > checkbox, otherwise everytime the BPM gets triggered (I am assuming
> > you are doing this to the Update method) the date will get updated.
> >
> > BTW. I suggest retyping the above code into the 4GL editor. I have had
> > line wrapping problems with cutting and pasting.
> >
> > Good Luck,
> >
> > Andrew
> >
> > PS, Thank Nigel for this, since all I know I learned from him.
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > I have done very simple things in 4gl but mostly returning rows
> that get
> > > counted that kinda thing.
> > >
> > >
> > >
> > > Basically I need to set ttorderdtl.date01 too today's date if the
> > > ttorderdtl.checkbox01 changed from false to true or from null to
> > true. Can
> > > anyone give me an example of something similar to this in 4gl?
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > bw2868bond
> > > Sent: Thursday, January 22, 2009 10:59 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BPM Key Word
> > >
> > >
> > >
> > > Sadly, that is one of the severe limitations of the 'canned'

actions.

> > > To be able to set fields to constants like DCD-USERID or system
> > > variables like Today, requires you to do it in 4gl code. Even

trying

> > > to include the user id in an email requires the entire email action
> > > be done in 4gl :-(
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > "Charlie
> > > Wilson" <foamdesigncsw@>
> > > wrote:
> > > >
> > > > I'm using one of the canned actions called "set the specific

field

> > > of the
> > > > changed row to value". It tells me that today is not a valid

entry.

> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com] On
> > > Behalf Of
> > > > Carl Peterson
> > > > Sent: Thursday, January 22, 2009 10:43 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: RE: [Vantage] BPM Key Word
> > > >
> > > >
> > > >
> > > > Datefield = today. You can also do math on today, too. Today - 1
> > > and so
> > > > on.
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > [mailto:vantage@yahoogroups <mailto:vantage%
> > > 40yahoogroups.com> .com] On
> > > > Behalf Of
> > > > Charlie Wilson
> > > > Sent: Thursday, January 22, 2009 10:29 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] BPM Key Word
> > > >
> > > > All,
> > > >
> > > > I'm working on a bpm and I am using the action that allows you to
> > > set a
> > > > specific field to a value. I'm setting a date field and was
> > > wondering if
> > > > there was some sort of key word I could enter that would set it
> > > today's
> > > > date.
> > > >
> > > > Thank you
> > > >
> > > > ~Charlie
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - http://www.avg <http://www.avg
> <http://www.avg <http://www.avg <http://www.avg.com> com> com>
> > com> com
> > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > > 1/21/2009
> > > > 7:07 AM
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

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

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/21/2009
> > > 7:07 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg <http://www.avg.com>

com> com

> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/22/2009
> > 7:08 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/23/2009

> 7:28 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/23/2009
7:28 AM

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

system · January 23, 2009, 2:23pm

Does anyone know the variable to use in a BPM to get the current date
and time?

Dale

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

system · January 23, 2009, 2:50pm

Yes.

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:

>
> Are there suppose to be periods at the end of the first and third line?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> andrew.tapper
> Sent: Friday, January 23, 2009 1:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> I tried my code and it works, but I was able to recreate that error
> message by putting a comma between no-lock & no-error. There should
> only be a space between these two commands.
>
> Andrew
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > I typed your code in just as it appears and it gives an error
> stating do not
> > understand after no-lock.
> >
> >
> >
> > We need the check box to stay checked because we have a dash board
> where we
> > are doing some tracking based off it and once that check box and a
> series of
> > others are checked showing that a bunch of different operations have
> been
> > completed it falls off the dash board.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > andrew.tapper
> > Sent: Friday, January 23, 2009 9:32 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > I forgot about the canned condition of "the specified field has been
> > changed from any to any". I have never tried it.
> >
> > I clear the check boxes so that I can retrigger the action easily.
> > Just a standard that I have adopted.
> >
> > Andrew
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > Can't I set up a condition that basically checks to see if the
> check box
> > > changed from false to true or null to true before executing your
> > code? If it
> > > is true and changes to true wouldn't the action not trigger or am I
> > missing
> > > something?
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > andrew.tapper
> > > Sent: Thursday, January 22, 2009 6:33 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BPM Key Word
> > >
> > >
> > >
> > > Charlie,
> > >
> > > First let me tell you to stay away from orderdtl.date01 if you

are on

> > > 8.03.405a. (see my post #72101)
> > >
> > > Setup a pre-process method with the condition on you checkbox. Then
> > > for 4gl code try:
> > >
> > > find first ttOrderDtl no-lock no-error.
> > > if available ttOrderDtl then do:
> > > assign ttOrderDtl.Date10 = TODAY.
> > > end.
> > >
> > > Finally you will probably want to add an action that unchecks the
> > > checkbox, otherwise everytime the BPM gets triggered (I am assuming
> > > you are doing this to the Update method) the date will get updated.
> > >
> > > BTW. I suggest retyping the above code into the 4GL editor. I

have had

> > > line wrapping problems with cutting and pasting.
> > >
> > > Good Luck,
> > >
> > > Andrew
> > >
> > > PS, Thank Nigel for this, since all I know I learned from him.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > "Charlie
> > > Wilson" <foamdesigncsw@>
> > > wrote:
> > > >
> > > > I have done very simple things in 4gl but mostly returning rows
> > that get
> > > > counted that kinda thing.
> > > >
> > > >
> > > >
> > > > Basically I need to set ttorderdtl.date01 too today's date if the
> > > > ttorderdtl.checkbox01 changed from false to true or from null to
> > > true. Can
> > > > anyone give me an example of something similar to this in 4gl?
> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com] On
> > > Behalf Of
> > > > bw2868bond
> > > > Sent: Thursday, January 22, 2009 10:59 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: BPM Key Word
> > > >
> > > >
> > > >
> > > > Sadly, that is one of the severe limitations of the 'canned'
> actions.
> > > > To be able to set fields to constants like DCD-USERID or system
> > > > variables like Today, requires you to do it in 4gl code. Even
> trying
> > > > to include the user id in an email requires the entire email

action

> > > > be done in 4gl :-(
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com,

> > > "Charlie
> > > > Wilson" <foamdesigncsw@>
> > > > wrote:
> > > > >
> > > > > I'm using one of the canned actions called "set the specific
> field
> > > > of the
> > > > > changed row to value". It tells me that today is not a valid
> entry.
> > > > >
> > > > >
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > _____
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> > .com] On
> > > > Behalf Of
> > > > > Carl Peterson
> > > > > Sent: Thursday, January 22, 2009 10:43 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > > Subject: RE: [Vantage] BPM Key Word
> > > > >
> > > > >
> > > > >
> > > > > Datefield = today. You can also do math on today, too. Today

- 1

> > > > and so
> > > > > on.
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > > [mailto:vantage@yahoogroups <mailto:vantage%
> > > > 40yahoogroups.com> .com] On
> > > > > Behalf Of
> > > > > Charlie Wilson
> > > > > Sent: Thursday, January 22, 2009 10:29 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > > Subject: [Vantage] BPM Key Word
> > > > >
> > > > > All,
> > > > >
> > > > > I'm working on a bpm and I am using the action that allows

you to

> > > > set a
> > > > > specific field to a value. I'm setting a date field and was
> > > > wondering if
> > > > > there was some sort of key word I could enter that would set it
> > > > today's
> > > > > date.
> > > > >
> > > > > Thank you
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - http://www.avg <http://www.avg
> > <http://www.avg <http://www.avg <http://www.avg.com> com> com>
> > > com> com
> > > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release

Date:

> > > > 1/21/2009
> > > > > 7:07 AM
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - http://www.avg <http://www.avg
> <http://www.avg <http://www.avg.com> com>
> > com> com
> > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > > 1/21/2009
> > > > 7:07 AM
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

<http://www.avg.com>

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/22/2009
> > > 7:08 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg.com> com
> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/23/2009
> > 7:28 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/23/2009

> 7:28 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 23, 2009, 2:52pm

Refer to my current thread with Charlie "Re: BPM Key Word".

Andrew

--- In vantage@yahoogroups.com, "Dale R. Kalsow" <dale.r.kalsow@...>
wrote:

>
> Does anyone know the variable to use in a BPM to get the current date
> and time?
>
>
>
> Dale
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 23, 2009, 4:04pm

I believe I finally got the code correct but now when the BPM fires I get
the another user has changed this record refresh and make your changes again
message. Any help on what is causing this?

~Charlie

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
andrew.tapper
Sent: Friday, January 23, 2009 2:50 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Key Word

Yes.

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Charlie
Wilson" <foamdesigncsw@...>
wrote:

>
> Are there suppose to be periods at the end of the first and third line?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

[mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
Behalf Of

> andrew.tapper
> Sent: Friday, January 23, 2009 1:50 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> I tried my code and it works, but I was able to recreate that error
> message by putting a comma between no-lock & no-error. There should
> only be a space between these two commands.
>
> Andrew
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > I typed your code in just as it appears and it gives an error
> stating do not
> > understand after no-lock.
> >
> >
> >
> > We need the check box to stay checked because we have a dash board
> where we
> > are doing some tracking based off it and once that check box and a
> series of
> > others are checked showing that a bunch of different operations have
> been
> > completed it falls off the dash board.
> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > andrew.tapper
> > Sent: Friday, January 23, 2009 9:32 AM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > I forgot about the canned condition of "the specified field has been
> > changed from any to any". I have never tried it.
> >
> > I clear the check boxes so that I can retrigger the action easily.
> > Just a standard that I have adopted.
> >
> > Andrew
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > Can't I set up a condition that basically checks to see if the
> check box
> > > changed from false to true or null to true before executing your
> > code? If it
> > > is true and changes to true wouldn't the action not trigger or am I
> > missing
> > > something?
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > andrew.tapper
> > > Sent: Thursday, January 22, 2009 6:33 PM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BPM Key Word
> > >
> > >
> > >
> > > Charlie,
> > >
> > > First let me tell you to stay away from orderdtl.date01 if you

are on

> > > 8.03.405a. (see my post #72101)
> > >
> > > Setup a pre-process method with the condition on you checkbox. Then
> > > for 4gl code try:
> > >
> > > find first ttOrderDtl no-lock no-error.
> > > if available ttOrderDtl then do:
> > > assign ttOrderDtl.Date10 = TODAY.
> > > end.
> > >
> > > Finally you will probably want to add an action that unchecks the
> > > checkbox, otherwise everytime the BPM gets triggered (I am assuming
> > > you are doing this to the Update method) the date will get updated.
> > >
> > > BTW. I suggest retyping the above code into the 4GL editor. I

have had

> > > line wrapping problems with cutting and pasting.
> > >
> > > Good Luck,
> > >
> > > Andrew
> > >
> > > PS, Thank Nigel for this, since all I know I learned from him.
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > "Charlie
> > > Wilson" <foamdesigncsw@>
> > > wrote:
> > > >
> > > > I have done very simple things in 4gl but mostly returning rows
> > that get
> > > > counted that kinda thing.
> > > >
> > > >
> > > >
> > > > Basically I need to set ttorderdtl.date01 too today's date if the
> > > > ttorderdtl.checkbox01 changed from false to true or from null to
> > > true. Can
> > > > anyone give me an example of something similar to this in 4gl?
> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com] On
> > > Behalf Of
> > > > bw2868bond
> > > > Sent: Thursday, January 22, 2009 10:59 AM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: BPM Key Word
> > > >
> > > >
> > > >
> > > > Sadly, that is one of the severe limitations of the 'canned'
> actions.
> > > > To be able to set fields to constants like DCD-USERID or system
> > > > variables like Today, requires you to do it in 4gl code. Even
> trying
> > > > to include the user id in an email requires the entire email

action

> > > > be done in 4gl :-(
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com,

> > > "Charlie
> > > > Wilson" <foamdesigncsw@>
> > > > wrote:
> > > > >
> > > > > I'm using one of the canned actions called "set the specific
> field
> > > > of the
> > > > > changed row to value". It tells me that today is not a valid
> entry.
> > > > >
> > > > >
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > _____
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> > .com] On
> > > > Behalf Of
> > > > > Carl Peterson
> > > > > Sent: Thursday, January 22, 2009 10:43 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > > Subject: RE: [Vantage] BPM Key Word
> > > > >
> > > > >
> > > > >
> > > > > Datefield = today. You can also do math on today, too. Today

- 1

> > > > and so
> > > > > on.
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > > [mailto:vantage@yahoogroups <mailto:vantage%
> > > > 40yahoogroups.com> .com] On
> > > > > Behalf Of
> > > > > Charlie Wilson
> > > > > Sent: Thursday, January 22, 2009 10:29 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > > Subject: [Vantage] BPM Key Word
> > > > >
> > > > > All,
> > > > >
> > > > > I'm working on a bpm and I am using the action that allows

you to

> > > > set a
> > > > > specific field to a value. I'm setting a date field and was
> > > > wondering if
> > > > > there was some sort of key word I could enter that would set it
> > > > today's
> > > > > date.
> > > > >
> > > > > Thank you
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - http://www.avg <http://www.avg
> > <http://www.avg <http://www.avg <http://www.avg <http://www.avg.com>

com> com> com>

> > > com> com
> > > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release

Date:

> > > > 1/21/2009
> > > > > 7:07 AM
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - http://www.avg <http://www.avg
> <http://www.avg <http://www.avg <http://www.avg.com> com> com>
> > com> com
> > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > > 1/21/2009
> > > > 7:07 AM
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

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

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/22/2009
> > > 7:08 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg <http://www.avg.com>

com> com

> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/23/2009
> > 7:28 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg <http://www.avg.com> com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/23/2009

> 7:28 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

No virus found in this incoming message.
Checked by AVG - http://www.avg.com
Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date: 1/23/2009
7:28 AM

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

system · January 23, 2009, 4:48pm

Charlie,

Change the code to the following:

find first ttOrderDtl where ttOrderDtl.RowMod = 'U' or
ttOrderDtl.RowMod = 'A' no-lock.
if available ttOrderDtl then do:
assign ttOrderDtl.Date10 = TODAY.
end.

Basically the first line of the original code changes to the first two
of the above. Again watch out for line wrapping if you copy and paste.

Andrew

--- In vantage@yahoogroups.com, "Charlie Wilson" <foamdesigncsw@...>
wrote:

>
> I believe I finally got the code correct but now when the BPM fires

I get

> the another user has changed this record refresh and make your

changes again

> message. Any help on what is causing this?
>
>
>
> ~Charlie
>
> _____
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On

Behalf Of

> andrew.tapper
> Sent: Friday, January 23, 2009 2:50 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Key Word
>
>
>
> Yes.
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Charlie

> Wilson" <foamdesigncsw@>
> wrote:
> >
> > Are there suppose to be periods at the end of the first and third

line?

> >
> >
> >
> > ~Charlie
> >
> > _____
> >
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com] On
> Behalf Of
> > andrew.tapper
> > Sent: Friday, January 23, 2009 1:50 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: BPM Key Word
> >
> >
> >
> > I tried my code and it works, but I was able to recreate that error
> > message by putting a comma between no-lock & no-error. There should
> > only be a space between these two commands.
> >
> > Andrew
> >
> > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> "Charlie
> > Wilson" <foamdesigncsw@>
> > wrote:
> > >
> > > I typed your code in just as it appears and it gives an error
> > stating do not
> > > understand after no-lock.
> > >
> > >
> > >
> > > We need the check box to stay checked because we have a dash board
> > where we
> > > are doing some tracking based off it and once that check box and a
> > series of
> > > others are checked showing that a bunch of different operations have
> > been
> > > completed it falls off the dash board.
> > >
> > >
> > >
> > > ~Charlie
> > >
> > > _____
> > >
> > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com] On

> > Behalf Of
> > > andrew.tapper
> > > Sent: Friday, January 23, 2009 9:32 AM
> > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > Subject: [Vantage] Re: BPM Key Word
> > >
> > >
> > >
> > > I forgot about the canned condition of "the specified field has been
> > > changed from any to any". I have never tried it.
> > >
> > > I clear the check boxes so that I can retrigger the action easily.
> > > Just a standard that I have adopted.
> > >
> > > Andrew
> > >
> > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
> > "Charlie
> > > Wilson" <foamdesigncsw@>
> > > wrote:
> > > >
> > > > Can't I set up a condition that basically checks to see if the
> > check box
> > > > changed from false to true or null to true before executing your
> > > code? If it
> > > > is true and changes to true wouldn't the action not trigger or

am I

> > > missing
> > > > something?
> > > >
> > > >
> > > >
> > > > ~Charlie
> > > >
> > > > _____
> > > >
> > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com] On
> > > Behalf Of
> > > > andrew.tapper
> > > > Sent: Thursday, January 22, 2009 6:33 PM
> > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > Subject: [Vantage] Re: BPM Key Word
> > > >
> > > >
> > > >
> > > > Charlie,
> > > >
> > > > First let me tell you to stay away from orderdtl.date01 if you
> are on
> > > > 8.03.405a. (see my post #72101)
> > > >
> > > > Setup a pre-process method with the condition on you checkbox.

Then

> > > > for 4gl code try:
> > > >
> > > > find first ttOrderDtl no-lock no-error.
> > > > if available ttOrderDtl then do:
> > > > assign ttOrderDtl.Date10 = TODAY.
> > > > end.
> > > >
> > > > Finally you will probably want to add an action that unchecks the
> > > > checkbox, otherwise everytime the BPM gets triggered (I am

assuming

> > > > you are doing this to the Update method) the date will get

updated.

> > > >
> > > > BTW. I suggest retyping the above code into the 4GL editor. I
> have had
> > > > line wrapping problems with cutting and pasting.
> > > >
> > > > Good Luck,
> > > >
> > > > Andrew
> > > >
> > > > PS, Thank Nigel for this, since all I know I learned from him.
> > > >
> > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com,

> > > "Charlie
> > > > Wilson" <foamdesigncsw@>
> > > > wrote:
> > > > >
> > > > > I have done very simple things in 4gl but mostly returning rows
> > > that get
> > > > > counted that kinda thing.
> > > > >
> > > > >
> > > > >
> > > > > Basically I need to set ttorderdtl.date01 too today's date

if the

> > > > > ttorderdtl.checkbox01 changed from false to true or from null to
> > > > true. Can
> > > > > anyone give me an example of something similar to this in 4gl?
> > > > >
> > > > >
> > > > >
> > > > > ~Charlie
> > > > >
> > > > > _____
> > > > >
> > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> > .com] On
> > > > Behalf Of
> > > > > bw2868bond
> > > > > Sent: Thursday, January 22, 2009 10:59 AM
> > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > > > > Subject: [Vantage] Re: BPM Key Word
> > > > >
> > > > >
> > > > >
> > > > > Sadly, that is one of the severe limitations of the 'canned'
> > actions.
> > > > > To be able to set fields to constants like DCD-USERID or system
> > > > > variables like Today, requires you to do it in 4gl code. Even
> > trying
> > > > > to include the user id in an email requires the entire email
> action
> > > > > be done in 4gl :-(
> > > > >
> > > > > --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com,
> > > > "Charlie
> > > > > Wilson" <foamdesigncsw@>
> > > > > wrote:
> > > > > >
> > > > > > I'm using one of the canned actions called "set the specific
> > field
> > > > > of the
> > > > > > changed row to value". It tells me that today is not a valid
> > entry.
> > > > > >
> > > > > >
> > > > > >
> > > > > > ~Charlie
> > > > > >
> > > > > > _____
> > > > > >
> > > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com
> > > > > [mailto:vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> > > .com] On
> > > > > Behalf Of
> > > > > > Carl Peterson
> > > > > > Sent: Thursday, January 22, 2009 10:43 AM
> > > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > > > Subject: RE: [Vantage] BPM Key Word
> > > > > >
> > > > > >
> > > > > >
> > > > > > Datefield = today. You can also do math on today, too. Today
> - 1
> > > > > and so
> > > > > > on.
> > > > > >
> > > > > > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>
> .com
> > > > > > [mailto:vantage@yahoogroups <mailto:vantage%
> > > > > 40yahoogroups.com> .com] On
> > > > > > Behalf Of
> > > > > > Charlie Wilson
> > > > > > Sent: Thursday, January 22, 2009 10:29 AM
> > > > > > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com>

.com

> > > > > > Subject: [Vantage] BPM Key Word
> > > > > >
> > > > > > All,
> > > > > >
> > > > > > I'm working on a bpm and I am using the action that allows
> you to
> > > > > set a
> > > > > > specific field to a value. I'm setting a date field and was
> > > > > wondering if
> > > > > > there was some sort of key word I could enter that would

set it

> > > > > today's
> > > > > > date.
> > > > > >
> > > > > > Thank you
> > > > > >
> > > > > > ~Charlie
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > > >
> > > > > >
> > > > > > No virus found in this incoming message.
> > > > > > Checked by AVG - http://www.avg <http://www.avg
> > > <http://www.avg <http://www.avg <http://www.avg

<http://www.avg.com>

> com> com> com>
> > > > com> com
> > > > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release
> Date:
> > > > > 1/21/2009
> > > > > > 7:07 AM
> > > > > >
> > > > > >
> > > > > >
> > > > > >
> > > > > > [Non-text portions of this message have been removed]
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > > No virus found in this incoming message.
> > > > > Checked by AVG - http://www.avg <http://www.avg
> > <http://www.avg <http://www.avg <http://www.avg.com> com> com>
> > > com> com
> > > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release

Date:

> > > > 1/21/2009
> > > > > 7:07 AM
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > [Non-text portions of this message have been removed]
> > > > >
> > > >
> > > >
> > > >
> > > > No virus found in this incoming message.
> > > > Checked by AVG - http://www.avg <http://www.avg
> <http://www.avg <http://www.avg.com> com>
> > com> com
> > > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > > 1/22/2009
> > > > 7:08 AM
> > > >
> > > >
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > No virus found in this incoming message.
> > > Checked by AVG - http://www.avg <http://www.avg

<http://www.avg.com>

> com> com
> > > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> > 1/23/2009
> > > 7:28 AM
> > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > No virus found in this incoming message.
> > Checked by AVG - http://www.avg <http://www.avg.com> com
> > Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:
> 1/23/2009
> > 7:28 AM
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> No virus found in this incoming message.
> Checked by AVG - http://www.avg.com
> Version: 8.0.176 / Virus Database: 270.10.10/1905 - Release Date:

1/23/2009

> 7:28 AM
>
>
>
>
> [Non-text portions of this message have been removed]
>

Topic		Replies	Views
BPM Help! Blank Title 70527 Yahoo Archive	4	350	November 18, 2010
BPM Question - Date Comparison Yahoo Archive	8	509	March 9, 2009
BPM QuoteDtl Blank Title 73062 Yahoo Archive	1	308	January 16, 2009
Date field update w/BPM Yahoo Archive	17	629	December 24, 2008
Learning the basics of a BPM Yahoo Archive	4	532	March 19, 2010

BPM Key Word Blank Title 73299

Related Topics