General information
Title:
VB & ADO calling VFP stored proc to return a record set
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only