Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Access Spt Cursor in Vfp
Message
From
19/02/2006 03:00:05
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
How to Access Spt Cursor in Vfp
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01097380
Message ID:
01097380
Views:
55
Dear experts,

I want to store Result to a Cursor Based on certain Condition from Sql Server
using Sql Stored Procedure and result should be accessible in Vfp.
I tried in this way but no result

CREATE PROCEDURE dbo.TrsTbl1

@JobCur CURSOR VARYING OUTPUT

As
SET @JobCur = CURSOR FOR
Select * From TrsTbl
OPEN @JobCur
GO
----------------------------------------
x=SQLExec(ConHnd,'{call dbo.TrsTbl1((?@lcValue1 output)}')

Thanks in advance

Abdulla
Next
Reply
Map
View

Click here to load this message in the networking platform