Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VB & ADO calling VFP stored proc to return a record set
Message
De
09/09/2004 04:05:05
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Titre:
VB & ADO calling VFP stored proc to return a record set
Divers
Thread ID:
00940510
Message ID:
00940510
Vues:
84
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform