Solved

Foxpro for DOS 2.6 using R&R report writer

Posted on 2013-10-24
5
1,447 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 42

Assisted Solution

by:pcelba
pcelba earned 250 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 250 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 42

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

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

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

The following is a collection of cases for strange behaviour when using advanced techniques in DOS batch files. You should have some basic experience in batch "programming", as I'm assuming some knowledge and not further explain the basics. For some…
TOMORROW TOMORROW.BAT is inspired by a question I get asked over and over again; that is, "How can I use batch file commands to obtain tomorrow's date?" The crux of this batch file revolves around the XCOPY command - a technique I discovered w…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…

615 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