BPM Help! Get Dates

Yahoo Archive
1
Thank you clearing that up for me Mr.Heins. I really appreciate it.

now that the code makes sense it wont trigger the alert. maybe im not using the correct Conditon?

I am using, "number of rows in the designed query is not less than 1"

--- In vantage@yahoogroups.com, Christopher Heins <cheins@...> wrote:
>
> Be careful with your AND's & OR's ... Progress gives AND higher precedence that OR (See Table 36 in V10 ABL Reference.)
>
> Rob's parentheses straighten that out but they appeared very late in this "thread".
>
> As originally written you would be getting ANY of the rowmod "A" (regardless of date) but only the "U" rowmod records within the date constraint.
>
> You might try:
>
> FOR EACH ttPOHeader NO-LOCK
> WHERE (ttPOHeader.RowMod = 'A' OR ttPOHeader.RowMod = 'U')
> AND ABSOLUTE(ttPOHeader.OrderDate - TODAY) > 10:
> /* show date out of range error? */
> END.
>
> I usually eliminate the OR with WHERE CAN-DO("A,U", ttPoHeader.RowMod) AND ...
>
> Minor stylistic point - although ABL permits a period at the end of a FOR EACH statement, I like to use ":" on block header statements such as DO, FOR, REPEAT, PROCEDURE etc. Old habits die hard!
>
> Happy Thanksgiving,
>
> Christopher Heins
> Sr. Progress Programmer/Analyst
> [cid:image001.png@...]
> Desk# 973-560-5370
> Cell# 908-256-3662
> Skype: cheins.nj
> cheins@...<mailto:cheins@...>
>
>
> ________________________________
> NOT INTENDED AS A SUBSTITUTE FOR A WRITING
> NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.
>
> This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
>
>
> [Non-text portions of this message have been removed]
>
2
I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate > DATEADD(DAY, -10, GETDATE())

I get this error "** Unable to Understand after _ "OrderDate > DATEADD".(247)"
I dont know much about Progress 4gl code and am not sure how to do it.

please help,

thank you very much.
3
Try this:

WHERE POHeader.OrderDate > TODAY -10.

On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@...>wrote:

> **
>
>
> I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> DATEADD(DAY, -10, GETDATE())
>
> I get this error "** Unable to Understand after _ "OrderDate >
> DATEADD".(247)"
> I dont know much about Progress 4gl code and am not sure how to do it.
>
> please help,
>
> thank you very much.
>
>
>



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

*

*


[Non-text portions of this message have been removed]
4
Thanks for your reply. I tried that and it gets me the same error "** Unable to understand after -- "no-lock where". (247)"


--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> Try this:
>
> WHERE POHeader.OrderDate > TODAY -10.
>
> On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@...>wrote:
>
> > **
> >
> >
> > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > DATEADD(DAY, -10, GETDATE())
> >
> > I get this error "** Unable to Understand after _ "OrderDate >
> > DATEADD".(247)"
> > I dont know much about Progress 4gl code and am not sure how to do it.
> >
> > please help,
> >
> > thank you very much.
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
5
Can you post your whole block of code? Wondering if it's a block statement syntax issue...

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<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 vacortes21
Sent: Tuesday, November 22, 2011 3:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Help! Get Dates



Thanks for your reply. I tried that and it gets me the same error "** Unable to understand after -- "no-lock where". (247)"

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Waffqle <waffqle@...> wrote:
>
> Try this:
>
> WHERE POHeader.OrderDate > TODAY -10.
>
> On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@...>wrote:
>
> > **
> >
> >
> > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > DATEADD(DAY, -10, GETDATE())
> >
> > I get this error "** Unable to Understand after _ "OrderDate >
> > DATEADD".(247)"
> > I dont know much about Progress 4gl code and am not sure how to do it.
> >
> > please help,
> >
> > thank you very much.
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
6
Here is my code:

for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod = 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock


--- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
>
> Can you post your whole block of code? Wondering if it's a block statement syntax issue...
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<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 vacortes21
> Sent: Tuesday, November 22, 2011 3:33 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BPM Help! Get Dates
>
>
>
> Thanks for your reply. I tried that and it gets me the same error "** Unable to understand after -- "no-lock where". (247)"
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Waffqle <waffqle@> wrote:
> >
> > Try this:
> >
> > WHERE POHeader.OrderDate > TODAY -10.
> >
> > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
> >
> > > **
> > >
> > >
> > > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > > DATEADD(DAY, -10, GETDATE())
> > >
> > > I get this error "** Unable to Understand after _ "OrderDate >
> > > DATEADD".(247)"
> > > I dont know much about Progress 4gl code and am not sure how to do it.
> > >
> > > please help,
> > >
> > > thank you very much.
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>
7
FOR EACH ttPOHeader WHERE (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod =
'U'and ttPOHeader.OrderDate > TODAY ) NO-LOCK.
END.

drop the comma, added a period.

On Tue, Nov 22, 2011 at 4:54 PM, vacortes21 <vcortes@...>wrote:

> **
>
>
> Here is my code:
>
> for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod =
> 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock
>
>
> --- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
> >
> > Can you post your whole block of code? Wondering if it's a block
> statement syntax issue...
> >
> > Rob Bucek
> > Production Control Manager
> > PH: (715) 284-5376 ext 311
> > Mobile: (715)896-0590
> > FAX: (715)284-4084
> > [Description: cid:1.234354861@...]<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 vacortes21
> > Sent: Tuesday, November 22, 2011 3:33 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BPM Help! Get Dates
> >
> >
> >
> > Thanks for your reply. I tried that and it gets me the same error "**
> Unable to understand after -- "no-lock where". (247)"
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> Waffqle <waffqle@> wrote:
> > >
> > > Try this:
> > >
> > > WHERE POHeader.OrderDate > TODAY -10.
> > >
> > > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
>
> > >
> > > > **
> > > >
> > > >
> > > > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > > > DATEADD(DAY, -10, GETDATE())
> > > >
> > > > I get this error "** Unable to Understand after _ "OrderDate >
> > > > DATEADD".(247)"
> > > > I dont know much about Progress 4gl code and am not sure how to do
> it.
> > > >
> > > > please help,
> > > >
> > > > thank you very much.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > *Waffqle Driggers*
> > > *High End Dev, System Design, Profit Drinking
> > > *
> > > *:: 904.962.2887*
> > > *:: waffqle@*
>
> > > *:: NO FAXES*
> > >
> > > *
> > >
> > > *
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



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

*

*


[Non-text portions of this message have been removed]
8
Did you try removing the coma before no-lock and adding a period after no-lock? If youre executing 4gl add and END. On line after.. if youre executing designed query you wont need the end. statment

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<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 vacortes21
Sent: Tuesday, November 22, 2011 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Help! Get Dates



Here is my code:

for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod = 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek <rbucek@...> wrote:
>
> Can you post your whole block of code? Wondering if it's a block statement syntax issue...
>
> Rob Bucek
> Production Control Manager
> PH: (715) 284-5376 ext 311
> Mobile: (715)896-0590
> FAX: (715)284-4084
> [Description: cid:1.234354861@...]<http://www.dsmfg.com/>
> (Click the logo to view our site)<http://www.dsmfg.com/>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of vacortes21
> Sent: Tuesday, November 22, 2011 3:33 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Re: BPM Help! Get Dates
>
>
>
> Thanks for your reply. I tried that and it gets me the same error "** Unable to understand after -- "no-lock where". (247)"
>
> --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>, Waffqle <waffqle@> wrote:
> >
> > Try this:
> >
> > WHERE POHeader.OrderDate > TODAY -10.
> >
> > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
> >
> > > **
> > >
> > >
> > > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > > DATEADD(DAY, -10, GETDATE())
> > >
> > > I get this error "** Unable to Understand after _ "OrderDate >
> > > DATEADD".(247)"
> > > I dont know much about Progress 4gl code and am not sure how to do it.
> > >
> > > please help,
> > >
> > > thank you very much.
> > >
> > >
> > >
> >
> >
> >
> > --
> > *Waffqle Driggers*
> > *High End Dev, System Design, Profit Drinking
> > *
> > *:: 904.962.2887*
> > *:: waffqle@*
> > *:: NO FAXES*
> >
> > *
> >
> > *
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
9
Nice jump W :)

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@yahoogroups.com] On Behalf Of Waffqle
Sent: Tuesday, November 22, 2011 4:01 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BPM Help! Get Dates

FOR EACH ttPOHeader WHERE (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod = 'U'and ttPOHeader.OrderDate > TODAY ) NO-LOCK.
END.

drop the comma, added a period.

On Tue, Nov 22, 2011 at 4:54 PM, vacortes21 <vcortes@...>wrote:

> **
>
>
> Here is my code:
>
> for each ttPOHeader where (ttPOHeader.RowMod = 'A' or
> ttPOHeader.RowMod = 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock
>
>
> --- In vantage@yahoogroups.com, Rob Bucek <rbucek@...> wrote:
> >
> > Can you post your whole block of code? Wondering if it's a block
> statement syntax issue...
> >
> > Rob Bucek
> > Production Control Manager
> > PH: (715) 284-5376 ext 311
> > Mobile: (715)896-0590
> > FAX: (715)284-4084
> > [Description: cid:1.234354861@...]<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 vacortes21
> > Sent: Tuesday, November 22, 2011 3:33 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Re: BPM Help! Get Dates
> >
> >
> >
> > Thanks for your reply. I tried that and it gets me the same error
> > "**
> Unable to understand after -- "no-lock where". (247)"
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> Waffqle <waffqle@> wrote:
> > >
> > > Try this:
> > >
> > > WHERE POHeader.OrderDate > TODAY -10.
> > >
> > > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
>
> > >
> > > > **
> > > >
> > > >
> > > > I am trying to do the fallowing in a BPM WHERE
> > > > POHeader.OrderDate > DATEADD(DAY, -10, GETDATE())
> > > >
> > > > I get this error "** Unable to Understand after _ "OrderDate >
> > > > DATEADD".(247)"
> > > > I dont know much about Progress 4gl code and am not sure how to
> > > > do
> it.
> > > >
> > > > please help,
> > > >
> > > > thank you very much.
> > > >
> > > >
> > > >
> > >
> > >
> > >
> > > --
> > > *Waffqle Driggers*
> > > *High End Dev, System Design, Profit Drinking
> > > *
> > > *:: 904.962.2887*
> > > *:: waffqle@*
>
> > > *:: NO FAXES*
> > >
> > > *
> > >
> > > *
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>



--
*Waffqle Driggers*
*High End Dev, System Design, Profit Drinking
*
*:: 904.962.2887*
*:: 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/.
(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
10
Thank You so much. This seems to work but when I add -10 to the date I get the error. My goal is to not let the Order date be <> 10 days.
this is what im talking about.

for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod = 'U'and ttPOHeader.OrderDate > TODAY -10) no-lock. end

--- In vantage@yahoogroups.com, Waffqle <waffqle@...> wrote:
>
> FOR EACH ttPOHeader WHERE (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod =
> 'U'and ttPOHeader.OrderDate > TODAY ) NO-LOCK.
> END.
>
> drop the comma, added a period.
>
> On Tue, Nov 22, 2011 at 4:54 PM, vacortes21 <vcortes@...>wrote:
>
> > **
> >
> >
> > Here is my code:
> >
> > for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod =
> > 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock
> >
> >
> > --- In vantage@yahoogroups.com, Rob Bucek <rbucek@> wrote:
> > >
> > > Can you post your whole block of code? Wondering if it's a block
> > statement syntax issue...
> > >
> > > Rob Bucek
> > > Production Control Manager
> > > PH: (715) 284-5376 ext 311
> > > Mobile: (715)896-0590
> > > FAX: (715)284-4084
> > > [Description: cid:1.234354861@]<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 vacortes21
> > > Sent: Tuesday, November 22, 2011 3:33 PM
> > > To: vantage@yahoogroups.com
> > > Subject: [Vantage] Re: BPM Help! Get Dates
> > >
> > >
> > >
> > > Thanks for your reply. I tried that and it gets me the same error "**
> > Unable to understand after -- "no-lock where". (247)"
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>,
> > Waffqle <waffqle@> wrote:
> > > >
> > > > Try this:
> > > >
> > > > WHERE POHeader.OrderDate > TODAY -10.
> > > >
> > > > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > > > > DATEADD(DAY, -10, GETDATE())
> > > > >
> > > > > I get this error "** Unable to Understand after _ "OrderDate >
> > > > > DATEADD".(247)"
> > > > > I dont know much about Progress 4gl code and am not sure how to do
> > it.
> > > > >
> > > > > please help,
> > > > >
> > > > > thank you very much.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> >
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>
11
Try this...

for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod = 'U') and ttPOHeader.OrderDate > (today - 10) no-lock.
end.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<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 vacortes21
Sent: Tuesday, November 22, 2011 4:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Help! Get Dates



Thank You so much. This seems to work but when I add -10 to the date I get the error. My goal is to not let the Order date be <> 10 days.
this is what im talking about.

for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod = 'U'and ttPOHeader.OrderDate > TODAY -10) no-lock. end

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Waffqle <waffqle@...> wrote:
>
> FOR EACH ttPOHeader WHERE (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod =
> 'U'and ttPOHeader.OrderDate > TODAY ) NO-LOCK.
> END.
>
> drop the comma, added a period.
>
> On Tue, Nov 22, 2011 at 4:54 PM, vacortes21 <vcortes@...>wrote:
>
> > **
> >
> >
> > Here is my code:
> >
> > for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod =
> > 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock
> >
> >
> > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Rob Bucek <rbucek@> wrote:
> > >
> > > Can you post your whole block of code? Wondering if it's a block
> > statement syntax issue...
> > >
> > > Rob Bucek
> > > Production Control Manager
> > > PH: (715) 284-5376 ext 311
> > > Mobile: (715)896-0590
> > > FAX: (715)284-4084
> > > [Description: cid:1.234354861@]<http://www.dsmfg.com/>
> >
> > > (Click the logo to view our site)<http://www.dsmfg.com/>
> > >
> > > From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On
> > Behalf Of vacortes21
> > > Sent: Tuesday, November 22, 2011 3:33 PM
> > > To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: BPM Help! Get Dates
> > >
> > >
> > >
> > > Thanks for your reply. I tried that and it gets me the same error "**
> > Unable to understand after -- "no-lock where". (247)"
> > >
> > > --- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>,
> > Waffqle <waffqle@> wrote:
> > > >
> > > > Try this:
> > > >
> > > > WHERE POHeader.OrderDate > TODAY -10.
> > > >
> > > > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > I am trying to do the fallowing in a BPM WHERE POHeader.OrderDate >
> > > > > DATEADD(DAY, -10, GETDATE())
> > > > >
> > > > > I get this error "** Unable to Understand after _ "OrderDate >
> > > > > DATEADD".(247)"
> > > > > I dont know much about Progress 4gl code and am not sure how to do
> > it.
> > > > >
> > > > > please help,
> > > > >
> > > > > thank you very much.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> >
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>



[Non-text portions of this message have been removed]
12
You need a space between the" -" and the "10".



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of vacortes21
Sent: Tuesday, November 22, 2011 6:07 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BPM Help! Get Dates





Thank You so much. This seems to work but when I add -10 to the date I
get the error. My goal is to not let the Order date be <> 10 days.
this is what im talking about.

for each ttPOHeader where (ttPOHeader.RowMod = 'A' or ttPOHeader.RowMod
= 'U'and ttPOHeader.OrderDate > TODAY -10) no-lock. end

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Waffqle <waffqle@...> wrote:
>
> FOR EACH ttPOHeader WHERE (ttPOHeader.RowMod = 'A' or
ttPOHeader.RowMod =
> 'U'and ttPOHeader.OrderDate > TODAY ) NO-LOCK.
> END.
>
> drop the comma, added a period.
>
> On Tue, Nov 22, 2011 at 4:54 PM, vacortes21 <vcortes@...>wrote:
>
> > **
> >
> >
> > Here is my code:
> >
> > for each ttPOHeader where (ttPOHeader.RowMod = 'A' or
ttPOHeader.RowMod =
> > 'U'and ttPOHeader.OrderDate > TODAY ) , no-lock
> >
> >
> > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
Rob Bucek <rbucek@> wrote:
> > >
> > > Can you post your whole block of code? Wondering if it's a block
> > statement syntax issue...
> > >
> > > Rob Bucek
> > > Production Control Manager
> > > PH: (715) 284-5376 ext 311
> > > Mobile: (715)896-0590
> > > FAX: (715)284-4084
> > > [Description: cid:1.234354861@]<http://www.dsmfg.com/>
> >
> > > (Click the logo to view our site)<http://www.dsmfg.com/>
> > >
> > > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> > Behalf Of vacortes21
> > > Sent: Tuesday, November 22, 2011 3:33 PM
> > > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > > Subject: [Vantage] Re: BPM Help! Get Dates
> > >
> > >
> > >
> > > Thanks for your reply. I tried that and it gets me the same error
"**
> > Unable to understand after -- "no-lock where". (247)"
> > >
> > > --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>,
> > Waffqle <waffqle@> wrote:
> > > >
> > > > Try this:
> > > >
> > > > WHERE POHeader.OrderDate > TODAY -10.
> > > >
> > > > On Tue, Nov 22, 2011 at 12:47 PM, vacortes21 <vcortes@>wrote:
> >
> > > >
> > > > > **
> > > > >
> > > > >
> > > > > I am trying to do the fallowing in a BPM WHERE
POHeader.OrderDate >
> > > > > DATEADD(DAY, -10, GETDATE())
> > > > >
> > > > > I get this error "** Unable to Understand after _ "OrderDate >
> > > > > DATEADD".(247)"
> > > > > I dont know much about Progress 4gl code and am not sure how
to do
> > it.
> > > > >
> > > > > please help,
> > > > >
> > > > > thank you very much.
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > --
> > > > *Waffqle Driggers*
> > > > *High End Dev, System Design, Profit Drinking
> > > > *
> > > > *:: 904.962.2887*
> > > > *:: waffqle@*
> >
> > > > *:: NO FAXES*
> > > >
> > > > *
> > > >
> > > > *
> > > >
> > > >
> > > > [Non-text portions of this message have been removed]
> > > >
> > >
> > >
> > >
> > > [Non-text portions of this message have been removed]
> > >
> >
> >
> >
>
>
>
> --
> *Waffqle Driggers*
> *High End Dev, System Design, Profit Drinking
> *
> *:: 904.962.2887*
> *:: waffqle@...*
> *:: NO FAXES*
>
> *
>
> *
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
13
Be careful with your AND's & OR's ... Progress gives AND higher precedence that OR (See Table 36 in V10 ABL Reference.)

Rob's parentheses straighten that out but they appeared very late in this "thread".

As originally written you would be getting ANY of the rowmod "A" (regardless of date) but only the "U" rowmod records within the date constraint.

You might try:

FOR EACH ttPOHeader NO-LOCK
WHERE (ttPOHeader.RowMod = 'A' OR ttPOHeader.RowMod = 'U')
AND ABSOLUTE(ttPOHeader.OrderDate - TODAY) > 10:
/* show date out of range error? */
END.

I usually eliminate the OR with WHERE CAN-DO("A,U", ttPoHeader.RowMod) AND ...

Minor stylistic point - although ABL permits a period at the end of a FOR EACH statement, I like to use ":" on block header statements such as DO, FOR, REPEAT, PROCEDURE etc. Old habits die hard!

Happy Thanksgiving,

Christopher Heins
Sr. Progress Programmer/Analyst
[cid:image001.png@01CCA9C9.370029E0]
Desk# 973-560-5370
Cell# 908-256-3662
Skype: cheins.nj
cheins@...<mailto:cheins@...>


________________________________
NOT INTENDED AS A SUBSTITUTE FOR A WRITING
NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO, SHALL CONSTITUTE A BINDING CONTRACT, OR ANY CONTRACTUAL OBLIGATION BY PNY, OR ANY INTENT TO ENTER INTO ANY BINDING OBLIGATIONS, NOTWITHSTANDING ANY ENACTMENT OF THE UNIFORM ELECTRONIC TRANSACTIONS ACT, THE FEDERAL E-SIGN ACT, OR ANY OTHER STATE OR FEDERAL LAW OF SIMILAR SUBSTANCE OR EFFECT. THIS EMAIL MESSAGE, ITS CONTENTS AND ATTACHMENTS ARE NOT INTENDED TO REPRESENT AN OFFER OR ACCEPTANCE OF AN OFFER TO ENTER INTO A CONTRACT. NOTHING IN THIS E-MAIL, IN ANY E-MAIL THREAD OF WHICH IT MAY BE A PART, OR IN ANY ATTACHMENTS THERETO SHALL ALTER THIS DISCLAIMER.

This e-mail message from PNY Technologies, Inc. is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


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