VFP & FPD2.6 operating on same tables 1

[cricket]

I have a reasonably complex application running uder FPD2.6.
I would like to use the reports capability of VFP8 on the databases/(tables), and not to disturb the FPD2.6 application.

the code need only be as complex as this in VFP:
SET VIEW TO report && achaic, I know, but VIEW set up in FPD
REPO FORM vfprepo TO PRINT

I am concerned with things like FOXUSER, and codepages.

What are the pitfalls if any?

 

[Mike Lewis]

Hi Cricket,

You are right that code pages could be an issue. By default, the first time you open a FPD table in VFP, you will be prompted to assign a code page to the table. Obviously, you don't want your users to see that prompt. The solution is to execute SET CPDIALOG OFF before running the report. (I'm not sure, but you might need to do that after you have restored your view.)

Resource files aren't really an issue. If you don't want a resource file to be created, you can add RESOURCE=OFF to your Config file, bit you can probably get away with just ignoring the issue.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[nestorbj]

Years ago I have some experience with the same issue.
Foxpro for DOS use codepage 437 and Visual Foxpro use codepage 1252 for default. You could reset the tables to use only one codepade.

Another issue is you cannot use Database Container, because tables in DBC cannot read by Foxpro for DOS. So you could only use Free Tables.

 

[alvechurchdata]

Another issue is you cannot use Database Container, because tables in DBC cannot read by Foxpro for DOS. So you could only use Free Tables.

I too am speaking from memory but I believe you can create a View against a FoxDOS table and so gain access to the features of the dbc.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[pthalacker]

Just to reiterate what Geoff said. We shared tables between a Fox 2x app and a VFP app for serveral years. Just create VFP8 views in a DBC of the Fox 2x free tables. Use the views to support your reports and leave the tables as they are. You can read from and write to Fox 2x tables in VFP all day as long as you don't modify their structures.

pamela

 

[nestorbj]

I 100% agree with Geoff and Pamela in that case. But what I mean is on the contrary: if you want to read VFP DBC tables in Foxpro for DOS.
Like Geoff and Pamela, I suggested you read FoxPro for DOS tables in VFP.

 

[alvechurchdata]

So you could only use Free Tables

VFP free tables are different from the tables used in FP 2.6 and before. Even though they are not associated with a dbc they still have space reserved for the name of the dbc.

Geoff Franklin

http://www.alvechurchdata.co.uk

 

[DSummZZZ]

Cricket,
I think your best bet would be to write a report server application of some sort and send jobs to it from your 2.6 app.
You could pass the data using parameters, or you could append them to a print job table and let the VFP server do the report work.


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm