Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Retrieving data from cursor
Message
From
13/02/2002 05:46:20
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
13/02/2002 03:59:00
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00619313
Message ID:
00619338
Views:
9
>Hi All,
>
>I'm creating an app using Crystal Reports 8.5 and VFP 7. Can I use VFP's cursor to fill data into a report ?
>There's a sample code in the CR's developers guide, but it's written in VB. Can anyone tell me the equivalent VFP code ?
>
>Dim CRXReport as New CrystalReport1
>Dim RS as New ADODB.Recordset
>
>rs.open "SELECT * from Customer",DSN=Xtreme Sample Database;",adOpenKeyset
>CRXReport.Database.SetDataSource rs
>
>
>TIA,
>
>Deddy

Would translate as :

#define adOpenKeySet 1
CRXReport = NewObject("CrystalReport1")
RS = NewObject("ADODB.Recordset")

rs.open( "SELECT * from Customer","DSN=Xtreme Sample Database;",adOpenKeyset)
CRXReport.Database.SetDataSource( rs )

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform