Getting order information in BPM 4GL

Yahoo Archive
1
Hello David,

I saw a mention for Windows 2008 terminal server. We have this at our facility and use the "published app" feature that is new with 2008 Server. It's been a long time coming from Microsoft, but is very good and it works seamlessly with other applications on the local desktop. It does not require a VPN, although a simple SonicWall firewall with the remote client might suit you well and an "icon" on the desktop that is a remote desktop connection will work just fine and your users will appreciate the "seamless" integration.

You will have to login initially to the terminal server with each user and setup their profile and add printers if that is desired. After that initial log in, the user should never have to login to access Vantage. We've been doing this since around December of 08 and I travel all over the country and have access to Vantage whenever, wherever and as often as I need it.

I wouldn't waste the time or money on GoToMyPC or LogMeIn, etc...these are good solutions for users that are local and need access from home or occasional travel, but can often times become a problem. Besides, the cost per month per user is easily recouped in a few months with terminal server and you have a solution for the boss when they need to work remotely.

Hope this helps.

Jason Claggett
Microsoft Small Business Specialist
MCP #3856159
2W Technologies, LLC
312.533.4033 x8039
jason@...<mailto:jason@...>



[Non-text portions of this message have been removed]
2
I want to update some data whenever a change is made to a sales order. So, in the SalesOrder.Update method, I enable post-processing directives as a pre-processing directive. Then, in my post-processing directives, I am looking to actually take some action in some 4GL code. I know my code is running because the first line of code creates a message that is being written to the server log. Thence, the following code:

IF AVAILABLE ttOrderDtl THEN DO:
MESSAGE "Found ttOrderDtl".
END.

That particular message ("Found ttOrderDtl") never appears on the log. So, I conclude that the ttOrderDtl is not around at post-processing. The same holds true if I look for ttOrderRel, or ttOrderHed. What I really need is the order number, so I can go to work updating records in the OrderHed table for the order that was just updated. Is there another way in 4GL to determine what the order number is? I was hoping I could get it from one of the order tables, but that is apparently not going to happen.

Too bad it is Friday, or I might have it figured out already. :)

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>



[Non-text portions of this message have been removed]
3
In your 4gl code did you try setting your query to something like



Ttorderdtl = orderdtl



In the past when ive tried to update records in the post process with
4gl, even within tables in the 'current' data set ive had to treat it
like I was going outside the current data set... its Sunday nite..just
a stab at it.



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

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

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





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Thomas Rose
Sent: Friday, October 16, 2009 5:22 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Getting order information in BPM 4GL





I want to update some data whenever a change is made to a sales order.
So, in the SalesOrder.Update method, I enable post-processing directives
as a pre-processing directive. Then, in my post-processing directives, I
am looking to actually take some action in some 4GL code. I know my code
is running because the first line of code creates a message that is
being written to the server log. Thence, the following code:

IF AVAILABLE ttOrderDtl THEN DO:
MESSAGE "Found ttOrderDtl".
END.

That particular message ("Found ttOrderDtl") never appears on the log.
So, I conclude that the ttOrderDtl is not around at post-processing. The
same holds true if I look for ttOrderRel, or ttOrderHed. What I really
need is the order number, so I can go to work updating records in the
OrderHed table for the order that was just updated. Is there another way
in 4GL to determine what the order number is? I was hoping I could get
it from one of the order tables, but that is apparently not going to
happen.

Too bad it is Friday, or I might have it figured out already. :)

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

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





[Non-text portions of this message have been removed]
4
Working on Sunday night? You are working too hard. :)

I assume before I use the line ttOrderDtl = OrderDtl, I need to define ttOrderDtl. How should I define ttOrderDtl? It's not a variable, is it? I tried just throwing in ttOrderDtl = OrderDtl, but that would not validate.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Rob Bucek
Sent: Sunday, October 18, 2009 4:54 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Getting order information in BPM 4GL



In your 4gl code did you try setting your query to something like

Ttorderdtl = orderdtl

In the past when ive tried to update records in the post process with
4gl, even within tables in the 'current' data set ive had to treat it
like I was going outside the current data set... its Sunday nite..just
a stab at it.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

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

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf
Of Thomas Rose
Sent: Friday, October 16, 2009 5:22 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Getting order information in BPM 4GL

I want to update some data whenever a change is made to a sales order.
So, in the SalesOrder.Update method, I enable post-processing directives
as a pre-processing directive. Then, in my post-processing directives, I
am looking to actually take some action in some 4GL code. I know my code
is running because the first line of code creates a message that is
being written to the server log. Thence, the following code:

IF AVAILABLE ttOrderDtl THEN DO:
MESSAGE "Found ttOrderDtl".
END.

That particular message ("Found ttOrderDtl") never appears on the log.
So, I conclude that the ttOrderDtl is not around at post-processing. The
same holds true if I look for ttOrderRel, or ttOrderHed. What I really
need is the order number, so I can go to work updating records in the
OrderHed table for the order that was just updated. Is there another way
in 4GL to determine what the order number is? I was hoping I could get
it from one of the order tables, but that is apparently not going to
happen.

Too bad it is Friday, or I might have it figured out already. :)

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

[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]
5
Well, I don't have a good answer to this issue, but I did come up with a kludge. The sales order has a change date and change time field. If I have just updated a sales order, then the change date should be equal to today, and the change time should be shortly before now. So, I select records for any sales order that has been changed today within the last 60 seconds. There is a chance I will get more than one SO with this logic, but for what I am planning to do, no harm should be done in that situation. Here is the code in case anyone is interested:

FOR EACH OrderHed WHERE OrderHed.Company = "EM01" AND OrderHed.ChangeTime > (TIME - 60) AND OrderHed.ChangeDate = DATE(NOW).
[Additional Code goes here]
END.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Thomas Rose
Sent: Monday, October 19, 2009 7:56 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Getting order information in BPM 4GL



Working on Sunday night? You are working too hard. :)

I assume before I use the line ttOrderDtl = OrderDtl, I need to define ttOrderDtl. How should I define ttOrderDtl? It's not a variable, is it? I tried just throwing in ttOrderDtl = OrderDtl, but that would not validate.

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Rob Bucek
Sent: Sunday, October 18, 2009 4:54 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Getting order information in BPM 4GL

In your 4gl code did you try setting your query to something like

Ttorderdtl = orderdtl

In the past when ive tried to update records in the post process with
4gl, even within tables in the 'current' data set ive had to treat it
like I was going outside the current data set... its Sunday nite..just
a stab at it.

Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

FAX: (715)284-4084

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

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

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>] On Behalf
Of Thomas Rose
Sent: Friday, October 16, 2009 5:22 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Getting order information in BPM 4GL

I want to update some data whenever a change is made to a sales order.
So, in the SalesOrder.Update method, I enable post-processing directives
as a pre-processing directive. Then, in my post-processing directives, I
am looking to actually take some action in some 4GL code. I know my code
is running because the first line of code creates a message that is
being written to the server log. Thence, the following code:

IF AVAILABLE ttOrderDtl THEN DO:
MESSAGE "Found ttOrderDtl".
END.

That particular message ("Found ttOrderDtl") never appears on the log.
So, I conclude that the ttOrderDtl is not around at post-processing. The
same holds true if I look for ttOrderRel, or ttOrderHed. What I really
need is the order number, so I can go to work updating records in the
OrderHed table for the order that was just updated. Is there another way
in 4GL to determine what the order number is? I was hoping I could get
it from one of the order tables, but that is apparently not going to
happen.

Too bad it is Friday, or I might have it figured out already. :)

Thom Rose
Controller
Electric Mirror LLC
HOTEL LUXURY

"The World Leader in Back-lit Mirrors & Mirror TV Technology"

T 425 776-4946
A 11831 Beverly Park Rd, Bldg D, Everett, WA 98204 USA
www.electricmirror.com<http://www.electricmirror.com>

[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]



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