Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFPOLEDB.dll and Crystal Reports 8.5 RDC
Message
From
07/02/2002 17:22:37
Pamela DeMerchant
Eagle Global Logistics, Inc.
Houston, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFPOLEDB.dll and Crystal Reports 8.5 RDC
Miscellaneous
Thread ID:
00617057
Message ID:
00617057
Views:
98
Has anyone used the new VFP OLE DB driver with Crystal Reports 8.5 RDC yet? I cannot get the syntax right.

goCrxRp = Createobject("CrystalRuntime.Application")
goRp = goCrxRp.OpenReport(c:\TestCrystal\Reports\Test.rpt)
oConn = CREATEOBJECT("ADODB.Connection")
oConn.Open("Provider=vfpoledb.1;Data Source=c:\TestCrystal\data")
oRS = CREATEOBJECT("ADODB.Recordset")
lcTestData = "Select * from Test"
oRS = oConn.Execute(lcTestData)
goRp.Database.SetDataSource(oRS)

TIA,

Pam
Reply
Map
View

Click here to load this message in the networking platform