Running progress .r code from a client

system · January 22, 2009, 6:11am

This is great topic IMHO.

I added the button to Vantage (customisation) and I am able now to
launch 4GL procedure from Vantage. The question is... how can I aquire
the results from 4GL procedure into tt table in Vantage?.

I am running the procedure form UD form.

Grzegorz SzczepaÃ±ski

--- In vantage@yahoogroups.com, "Podlin, Michael" <michael.podlin@...>
wrote:

>
> You'll have to launch the progress program from a command line with

the -param "parameters" command.

>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On

Behalf Of mjhoney71

> Sent: Wednesday, January 21, 2009 7:14 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Running progress .r code from a client
>
>
>
> Vantage 8.03.407
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,

"Podlin, Michael"

> <michael.podlin@> wrote:
> >
> > Vantage 6.x and below or Vantage 8.x and above?
> >
> > -----Original Message-----
> > From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com

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

> Behalf Of mjhoney71
> > Sent: Tuesday, January 20, 2009 3:47 PM
> > To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> > Subject: [Vantage] Re: Running progress .r code from a client
> >
> >
> >
> > Is there a way to pass parameters to a progress program from inside
> > Vantage? Any good examples or even general references would be
> greatly
> > appreciated.
> >
> > Marc
> >
> >
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 13, 2009, 4:10pm

I'm not exactly sure what to ask but basically what I want is to be
able to run a progress .r program supplied to me from a workstation
that does'nt have a full version of progress installed, only the
network version. From what I understand, the .r file is a compiled
Progress program that "should" run from a client. In fact, if I simply
double click the file from Windows Explorer is launches some type of
progress interpreter but gives me a 1006 error basically stating it's
not connected to a database. This gives me the impression that if I
created a shortcut to the .r file and supplied the correct command line
parameters I might be in luck. Ideally I would like to connect to the
Progress database on our server through the ODBC connector on the
workstation.

Any pointers or clues are greatly appreciated.

Marc

system · January 13, 2009, 4:51pm

Marc,

You are correct in assuming that you can do this by creating a
shortcut and placing the correct parameters in it. When you create
the shortcut you will want to use:

TARGET:
\\DBservername\epicor\oe101b\bin\prowin32.exe -db
\\DBservername\epicor\mfgsys803\db\mfgsys.db -S 8300 -H DBServername
-N TCP -p "location and name of .r file" -s 200 -B 2000 -U sysprogress
-P sysprogress

This will all be in one long line. This will connect you to your LIVE
progress database running OpenEdge 10.1B. If the location/name of the
.r program you are trying to run contains spaces make sure you keep
the quotes around it.

This also assumes you chose the default folder locations when
installing Vantage and Progress. If you need any further help with
this let me know. I have different Progress reports that I have setup
using windows scheduler to run using this and it works great.

Robert Nupp
Laclede Chain Mfg.

--- In vantage@yahoogroups.com, "mjhoney71" <mhoney@...> wrote:
>
> I'm not exactly sure what to ask but basically what I want is to be
> able to run a progress .r program supplied to me from a workstation
> that does'nt have a full version of progress installed, only the
> network version. From what I understand, the .r file is a compiled
> Progress program that "should" run from a client. In fact, if I simply
> double click the file from Windows Explorer is launches some type of
> progress interpreter but gives me a 1006 error basically stating it's
> not connected to a database. This gives me the impression that if I
> created a shortcut to the .r file and supplied the correct command line
> parameters I might be in luck. Ideally I would like to connect to the
> Progress database on our server through the ODBC connector on the
> workstation.
>
> Any pointers or clues are greatly appreciated.
>
> Marc
>

system · January 13, 2009, 5:17pm

You can create an icon on the client desktop and then use full paths to
Progress, db, and program. This example is for Vantage 8.3 and Progress
10.1b.

Here is an example:

\\servername\epicor\oe101b\bin\prowin32.exe
<file:///\\servername\epicor\oe101b\bin\prowin32.exe> -db
\\servername\epicor\mfgsys803\db\mfgsys
<file:///\\servername\epicor\mfgsys803\db\mfgsys> -S 8300 (port of db) -H
server name -N TCP -p \\path <file:///\\path> of progress .r program
\programname.r -U sysprogress -P sysprogress (user and password default)

The .r will need to have been compiled under the same version that you
running with Vantage

This should work if you use the proper paths, servername, and port number.

Good luck,

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
mjhoney71
Sent: Tuesday, January 13, 2009 4:11 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Running progress .r code from a client

I'm not exactly sure what to ask but basically what I want is to be
able to run a progress .r program supplied to me from a workstation
that does'nt have a full version of progress installed, only the
network version. From what I understand, the .r file is a compiled
Progress program that "should" run from a client. In fact, if I simply
double click the file from Windows Explorer is launches some type of
progress interpreter but gives me a 1006 error basically stating it's
not connected to a database. This gives me the impression that if I
created a shortcut to the .r file and supplied the correct command line
parameters I might be in luck. Ideally I would like to connect to the
Progress database on our server through the ODBC connector on the
workstation.

Any pointers or clues are greatly appreciated.

Marc

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

system · January 14, 2009, 7:54am

Thank you very much, that is exactly what I was looking for, it
worked like a charm!

Marc

--- In vantage@yahoogroups.com, "robert.nupp" <robert.nupp@...> wrote:
>
> Marc,
>
> You are correct in assuming that you can do this by creating a
> shortcut and placing the correct parameters in it. When you create
> the shortcut you will want to use:
>
> TARGET:
> \\DBservername\epicor\oe101b\bin\prowin32.exe -db
> \\DBservername\epicor\mfgsys803\db\mfgsys.db -S 8300 -H DBServername
> -N TCP -p "location and name of .r file" -s 200 -B 2000 -U
sysprogress
> -P sysprogress
>
> This will all be in one long line. This will connect you to your
LIVE
> progress database running OpenEdge 10.1B. If the location/name of
the
> .r program you are trying to run contains spaces make sure you keep
> the quotes around it.
>
> This also assumes you chose the default folder locations when
> installing Vantage and Progress. If you need any further help with
> this let me know. I have different Progress reports that I have
setup
> using windows scheduler to run using this and it works great.
>
> Robert Nupp
> Laclede Chain Mfg.
>
>
> --- In vantage@yahoogroups.com, "mjhoney71" <mhoney@> wrote:
> >
> > I'm not exactly sure what to ask but basically what I want is to
be
> > able to run a progress .r program supplied to me from a
workstation
> > that does'nt have a full version of progress installed, only the
> > network version. From what I understand, the .r file is a
compiled
> > Progress program that "should" run from a client. In fact, if I
simply
> > double click the file from Windows Explorer is launches some type
of
> > progress interpreter but gives me a 1006 error basically stating
it's
> > not connected to a database. This gives me the impression that
if I
> > created a shortcut to the .r file and supplied the correct
command line
> > parameters I might be in luck. Ideally I would like to connect
to the
> > Progress database on our server through the ODBC connector on the
> > workstation.
> >
> > Any pointers or clues are greatly appreciated.
> >
> > Marc
> >
>

system · January 20, 2009, 6:36am

The shortcut is working good, but after the .r finish its execution it
lanuches an empty Procedure Editor. What could be a reason for that?

Grzegorz SzczepaÃ±ski

--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> You can create an icon on the client desktop and then use full paths to
> Progress, db, and program. This example is for Vantage 8.3 and Progress
> 10.1b.
>
> Here is an example:
>
> \\servername\epicor\oe101b\bin\prowin32.exe
> <file:///\\servername\epicor\oe101b\bin\prowin32.exe> -db
> \\servername\epicor\mfgsys803\db\mfgsys
> <file:///\\servername\epicor\mfgsys803\db\mfgsys> -S 8300 (port of
db) -H
> server name -N TCP -p \\path <file:///\\path> of progress .r program
> \programname.r -U sysprogress -P sysprogress (user and password default)
>
> The .r will need to have been compiled under the same version that you
> running with Vantage
>
> This should work if you use the proper paths, servername, and port
number.
>
> Good luck,
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> mjhoney71
> Sent: Tuesday, January 13, 2009 4:11 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Running progress .r code from a client
>
> I'm not exactly sure what to ask but basically what I want is to be
> able to run a progress .r program supplied to me from a workstation
> that does'nt have a full version of progress installed, only the
> network version. From what I understand, the .r file is a compiled
> Progress program that "should" run from a client. In fact, if I simply
> double click the file from Windows Explorer is launches some type of
> progress interpreter but gives me a 1006 error basically stating it's
> not connected to a database. This gives me the impression that if I
> created a shortcut to the .r file and supplied the correct command line
> parameters I might be in luck. Ideally I would like to connect to the
> Progress database on our server through the ODBC connector on the
> workstation.
>
> Any pointers or clues are greatly appreciated.
>
> Marc
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 20, 2009, 10:59am

Can be tricky.

Add the following to end of your code.

APPLY "CLOSE" to this-procedure.
quit.
return no-apply.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
tomojmail
Sent: Tuesday, January 20, 2009 6:36 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Running progress .r code from a client

The shortcut is working good, but after the .r finish its execution it
lanuches an empty Procedure Editor. What could be a reason for that?

Grzegorz SzczepaÃ±ski

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Carl
Peterson" <cpeterson@...> wrote:

>
> You can create an icon on the client desktop and then use full paths to
> Progress, db, and program. This example is for Vantage 8.3 and Progress
> 10.1b.
>
> Here is an example:
>
> \\servername\epicor\oe101b\bin\prowin32.exe
> <file:/// <file:///\\> \\servername\epicor\oe101b\bin\prowin32.exe> -db
> \\servername\epicor\mfgsys803\db\mfgsys
> <file:/// <file:///\\> \\servername\epicor\mfgsys803\db\mfgsys> -S 8300

(port of
db) -H

> server name -N TCP -p \\path <file:/// <file:///\\> \\path> of progress .r

program

> \programname.r -U sysprogress -P sysprogress (user and password default)
>
> The .r will need to have been compiled under the same version that you
> running with Vantage
>
> This should work if you use the proper paths, servername, and port

number.

>
> Good luck,
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

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

> mjhoney71
> Sent: Tuesday, January 13, 2009 4:11 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Running progress .r code from a client
>
> I'm not exactly sure what to ask but basically what I want is to be
> able to run a progress .r program supplied to me from a workstation
> that does'nt have a full version of progress installed, only the
> network version. From what I understand, the .r file is a compiled
> Progress program that "should" run from a client. In fact, if I simply
> double click the file from Windows Explorer is launches some type of
> progress interpreter but gives me a 1006 error basically stating it's
> not connected to a database. This gives me the impression that if I
> created a shortcut to the .r file and supplied the correct command line
> parameters I might be in luck. Ideally I would like to connect to the
> Progress database on our server through the ODBC connector on the
> workstation.
>
> Any pointers or clues are greatly appreciated.
>
> Marc
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · January 20, 2009, 4:47pm

Is there a way to pass parameters to a progress program from inside
Vantage? Any good examples or even general references would be greatly
appreciated.

Marc

system · January 20, 2009, 5:02pm

Well, you might be able to pass an argument to the Progress file with a
BAM. The below code is using a 4GL solution in Progress to export
parameters to an external .EXE program I wrote a long while back:

You should be able to do something similar so I would recommend looking
up Accepting Arguments in 4GL or having Declarations accept arguments.
I know how to do it in VB.NET but I doubt that helps.

/*Passes Jobnum when Labordtl.Complete is touched */

{V:\mfgsys\ud\GlbAlert.i &TableName = "LaborDtl"}

/*Plug in appropriate Operation number (integer), and WCCode (Textx5)*/

IF (LaborDtl.LaborQty >= 1) AND

(LaborDtl.WCCode = "0261") AND

(LaborDtl.COMPLETE = YES) THEN

DO:

/*Find Joboper.QtyCompleted*/

DEF VAR nQtyCompleted AS DECIMAL NO-UNDO.

FIND JobOper WHERE

JobOper.company = LaborDtl.Company AND

JobOper.Jobnum = LaborDtl.Jobnum AND

JobOper.AssemblySeq = LaborDtl.AssemblySeq AND

JobOper.OprSeq = LaborDtl.OprSeq

NO-LOCK NO-ERROR.

IF AVAILABLE JobOper THEN

nQtyCompleted = JobOper.QtyCompleted.

/*

MESSAGE LaborDtl.WCCode VIEW-AS ALERT-BOX.

*/

DOS VALUE("c:\BoxShopConsole.exe "

+ STRING(nQtyCompleted) + " "

+ LaborDtl.Jobnum + " "

+ string(LaborDtl.LaborQty) + " "

+ LaborDtl.Employeenum + " "

+ string(LaborDtl.LaborDtlSeq) + " "

+ string(LaborDtl.AssemblySeq) + " "

+ string(LaborDtl.WCCode))

.

END.

Christopher Ryhal

Senior Microsoft Consultant

Perpetual Technologies, Inc

chris.ryhal@... <mailto:chris.ryhal@...>

http://www.perptech.com

Office: (317) 824-0393

Mobile: (317) 364-2134

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mjhoney71
Sent: Tuesday, January 20, 2009 4:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Running progress .r code from a client

Is there a way to pass parameters to a progress program from inside
Vantage? Any good examples or even general references would be greatly
appreciated.

Marc

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

system · January 20, 2009, 5:19pm

Vantage 6.x and below or Vantage 8.x and above?

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of mjhoney71
Sent: Tuesday, January 20, 2009 3:47 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Running progress .r code from a client

Is there a way to pass parameters to a progress program from inside
Vantage? Any good examples or even general references would be greatly
appreciated.

Marc

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

system · January 21, 2009, 8:13am

Vantage 8.03.407

--- In vantage@yahoogroups.com, "Podlin, Michael"
<michael.podlin@...> wrote:

>
> Vantage 6.x and below or Vantage 8.x and above?
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On

Behalf Of mjhoney71

> Sent: Tuesday, January 20, 2009 3:47 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Running progress .r code from a client
>
>
>
> Is there a way to pass parameters to a progress program from inside
> Vantage? Any good examples or even general references would be

greatly

> appreciated.
>
> Marc
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

system · January 21, 2009, 8:28am

You'll have to launch the progress program from a command line with the -param "parameters" command.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of mjhoney71
Sent: Wednesday, January 21, 2009 7:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Running progress .r code from a client

Vantage 8.03.407

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Podlin, Michael"
<michael.podlin@...> wrote:

>
> Vantage 6.x and below or Vantage 8.x and above?
>
> -----Original Message-----
> From: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com [mailto: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com]On

Behalf Of mjhoney71

> Sent: Tuesday, January 20, 2009 3:47 PM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: Running progress .r code from a client
>
>
>
> Is there a way to pass parameters to a progress program from inside
> Vantage? Any good examples or even general references would be

greatly

> appreciated.
>
> Marc
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>

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

system · January 22, 2009, 5:37am

Thank you. :).

Grzegorz SzczepaÃ±ski

--- In vantage@yahoogroups.com, "Carl Peterson" <cpeterson@...> wrote:
>
> Can be tricky.
>
> Add the following to end of your code.
>
> APPLY "CLOSE" to this-procedure.
> quit.
> return no-apply.
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> tomojmail
> Sent: Tuesday, January 20, 2009 6:36 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Running progress .r code from a client
>
> The shortcut is working good, but after the .r finish its execution it
> lanuches an empty Procedure Editor. What could be a reason for that?
>
> Grzegorz SzczepaÃ±ski
>
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Carl
> Peterson" <cpeterson@> wrote:
> >
> > You can create an icon on the client desktop and then use full
paths to
> > Progress, db, and program. This example is for Vantage 8.3 and
Progress
> > 10.1b.
> >
> > Here is an example:
> >
> > \\servername\epicor\oe101b\bin\prowin32.exe
> > <file:/// <file:///\\>
\\servername\epicor\oe101b\bin\prowin32.exe> -db
> > \\servername\epicor\mfgsys803\db\mfgsys
> > <file:/// <file:///\\> \\servername\epicor\mfgsys803\db\mfgsys> -S
8300
> (port of
> db) -H
> > server name -N TCP -p \\path <file:/// <file:///\\> \\path> of
progress .r
> program
> > \programname.r -U sysprogress -P sysprogress (user and password
default)
> >
> > The .r will need to have been compiled under the same version that you
> > running with Vantage
> >
> > This should work if you use the proper paths, servername, and port
> number.
> >
> > Good luck,
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of
> > mjhoney71
> > Sent: Tuesday, January 13, 2009 4:11 PM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Running progress .r code from a client
> >
> > I'm not exactly sure what to ask but basically what I want is to be
> > able to run a progress .r program supplied to me from a workstation
> > that does'nt have a full version of progress installed, only the
> > network version. From what I understand, the .r file is a compiled
> > Progress program that "should" run from a client. In fact, if I
simply
> > double click the file from Windows Explorer is launches some type of
> > progress interpreter but gives me a 1006 error basically stating it's
> > not connected to a database. This gives me the impression that if I
> > created a shortcut to the .r file and supplied the correct command
line
> > parameters I might be in luck. Ideally I would like to connect to the
> > Progress database on our server through the ODBC connector on the
> > workstation.
> >
> > Any pointers or clues are greatly appreciated.
> >
> > Marc
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
> [Non-text portions of this message have been removed]
>

Topic		Replies	Views
Running a Progress Procedure Yahoo Archive	6	472	November 20, 2002
Visual Basic - Progress question Yahoo Archive	4	333	November 5, 2003
Call Progress Program From V8 Menu Yahoo Archive	5	603	November 10, 2008
4GL Baby steps Yahoo Archive	17	495	January 15, 2002
Progress stuck open after Export from a shortcut (was: 4GL Big Yahoo Archive	6	399	March 1, 2002

Running progress .r code from a client

Related Topics