Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VB & ADO calling VFP stored proc to return a record set
Message
From
09/09/2004 04:05:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
VB & ADO calling VFP stored proc to return a record set
Miscellaneous
Thread ID:
00940510
Message ID:
00940510
Views:
85
I am using Visual Basic and ADO to run a Visual Foxpro 8 stored procedure but it doesn't return a record set. Can Foxpro return a record set from a stored procedure?

The connection string is as follows:
Provider=vfpoledb;Data Source=z:\Projects\Foxpro\VFP8\G1GoldMine.DBC;SourceType=DBC;Mode=ReadWrite|Share Deny None;Collating Sequence=MACHINE;Password=''

The stored procedure is:
PROCEDURE spGetConditions(tcAlias)
SELECT RC.BusID, TC.Description ;
FROM tblBuses AS RC ;
INNER JOIN tblConditions AS TC ON TC.ConditionID = RC.ConditionID
ENDPROC

Note: tcAlias is just a dummy parameter
Next
Reply
Map
View

Click here to load this message in the networking platform