Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Foxpro for DOS 2.6 using R&R report writer

Posted on 2013-10-24
5
Medium Priority
?
1,500 Views
Last Modified: 2013-11-04
I have to rewrite an application in FoxPro for DOS 2.6 using FoxPro files and indexes with R&R report writer.

The reports have already been created all I have to do is tie them into the app.

If anyone has done any of this can I get some hints or things that may have gone wrong. The app has to run in XP 32 bit.

How do I make calls to the R&R Report writer from Fox Pro 2.6. Which versions of R&R Report writer can I use.
0
Comment
Question by:Idarac
  • 2
  • 2
5 Comments
 
LVL 43

Assisted Solution

by:pcelba
pcelba earned 1000 total points
ID: 39598920
You don't need to call the R&R reports from you FoxPro application. You'll deliver two independent applications each one having its own EXE icon in Windows:
1) FoxPro application
2) R&R writer application with appropriate run-time license

They will both read FoxPro data in shared mode.

You may use the latest R&R Report Works. More info e.g. here: http://www.hallogram.com/rr/

The only possibility how to call Windows (R&R) app from DOS FoxPro app is RUN command which calls a batch file (.BAT) containing the Windows app EXE call.

BTW, I would highly recommend to port the application into the latest Visual FoxPro 9 version.
0
 
LVL 1

Author Comment

by:Idarac
ID: 39599019
Thanx for the info.

The client wants it in FoxPro for dos 2.6.

Don't know why. But its billable...
0
 
LVL 2

Accepted Solution

by:
GEOFS earned 1000 total points
ID: 39600199
The code snippet below comes from a VFP9 app that I built a while back.  You can find the definitions of the contents of the parameter switches and variables in the R&R docs.

pcExecName = SYS(16)
pcExecPath = ADDBS(JUSTPATH(pcExecName)) + "\"
cRRExec = pcExecPath + "RRWRUN.EXE"
cParams = cRRFile + " " + cRptNumber ;
            + " /R" + cRRPath + " /D" + cDataPath + " /B"                        
nResult = ShellExecute( 0, "OPEN", cRRExec, cParams, cRRPath, 1 )
0
 
LVL 43

Expert Comment

by:pcelba
ID: 39600248
Hmm...  FoxPro 2.6/DOS cannot call ShellExecute but it can create the .BAT file which is then used in RUN command.
0
 
LVL 1

Author Closing Comment

by:Idarac
ID: 39622949
Thank you
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

One of my most closely kept secrets is revealed in this discussion How to output text on the same line This question was recently posted in EE by Simon336697 (http://www.experts-exchange.com/Programming/Languages/Scripting/Shell/Batch/Q_2459…
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
Video by: ITPro.TV
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month8 days, 17 hours left to enroll

876 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question