Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Getting
Message
De
03/10/2005 17:39:30
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
03/10/2005 16:40:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01055622
Message ID:
01055662
Vues:
15
>? lvRetVal.Fields(0).Value
>gives me
>"Member FIELDS does not evaluate to an object" error.
>
>>I never thought second is supposed to work. Where does it say it should work?
>Microsoft ADO help file "C:\Program Files\Common Files\Microsoft Shared\OFFICE11\1033\ADO210.CHM"
>Connection Object - bottom of the page
>"Execute a stored procedure as a native method of a Connection object
>
>To execute a stored procedure, issue a statement where the stored procedure name is used as if it were a method on the Connection object, followed by any parameters. ADO will make a "best guess" of parameter types. For example:
>
>Dim cnn As New ADODB.Connection
>...
>'Your stored procedure name and any parameters.
>cnn.sp_yourStoredProcedureName "parameter"
>"

In your stored procedure:
replace return 33 with select 33 and it should work.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform