Joe,
The VFP ODBC drivers doesn't support stored procedure calling.
You have two solutions.
1) Using trigers on a procedure table.
2) Building a COM Object
Marcel
>I need to call a stored procedure in a FoxPro version 5.0 database from Microsoft Visual Basic version 5.0. Any ideas on how this can be done? My stored procedure works fine when I am running VFP and call the procedure, but I cannot figure out how to call the procedure from the VB code after establishing a connection with the database.
>
>I'm connecting to the database from the client using an ODBC driver across the network, but I don't think this is going to be a problem.
>
>Joe
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement