Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Basic data access question for crystal reports foxpro
Message
From
06/03/2005 08:13:38
 
 
To
05/03/2005 09:14:56
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00993004
Message ID:
00993094
Views:
12
Crystal Reports cannot access a VFP cursor. It can access VFP data in several ways:

- Fox2x tables, CR can use native access. With this method, the VFP program does all the data munging and SQL statements to collect the data, then creates the output data on disk.

- ODBC. This works just like ODBC to any data source. However, the Fox ODBC driver has not been updated for several versions.

- OLEDB. This works just like any OLEDB data source.

- ADO. The VFP application can create the ADO record source and pass it as a parameter to CR.

- XML. The VFP application does all the data munging and SQL statemens to collect the data, then creates the XML output file. CR uses ODBC to access this file.

There are several CR with Fox articles on my web site that may help you.

>I have never accessed data from a cursor in foxpro before.
>I must write a program that creates the cursor?
>How do I run the program from Crystal to get have the cursor formed and how do I access the cursor afterward.
>
>Thanks
>Jim
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Reply
Map
View

Click here to load this message in the networking platform