Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Stored Procedure Good/Bad? How?
Message
De
12/01/2001 13:27:06
 
 
À
12/01/2001 13:15:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00463078
Message ID:
00463094
Vues:
14
Hi John,

> I'm confused...is your back-end (server) database VFP?

Yes the database is an '.DBC'

> Anyway, you call the stored proc by replacing "mysqlstatement" below with the stored proc name.

I Tried the following:
nconhandle = sqlExec(nhandle, myprocedure(dweek_act), mycursor')
I get 'File myprocedure.prg does not exist'
nconhandle = sqlExec(nhandle, 'myprocedure(dweek_act)', mycursor')
Here nconhandle = -1

If in developement I type ?myprocedure(dweek_act) in the command window with the database open, I get a cursor. How do I translate that into my program?

TIA
Mike
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform