Hi Abdulla,
take a look at message#
876903.
>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
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst