Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Getting
Message
From
03/10/2005 17:39:30
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
03/10/2005 16:40:57
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01055622
Message ID:
01055662
Views:
10
>? 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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform