Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can dbc store procedure change a variable from C# .Net
Message
 
 
À
07/05/2008 11:52:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Divers
Thread ID:
01315644
Message ID:
01315647
Vues:
22
>Hi, i have a program in C# .Net calling a store procedure in dbc, it works fine but i have 1 parameter that must be filled in that procedure then C# knows about that value.
>
>procedure getpages
>lparameters csql,npag
>local nmaxreg=10
>execscript(csql)
>npag=_tally/nmaxreg
>return setresultset("query")
>endproc
>
>I need that npag returns to C# with the value calculated here. Is it possible? T.I.A.

I haven't tried, but can you use ParameterDirection as shown here
http://msdn.microsoft.com/en-us/library/59x02y99.aspx ? I would assume it may work with OleDb.
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform