Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP6 - SQL Server UPDATE/Returned Cursors
Message
 
 
To
15/02/2002 21:34:43
Bob Thomsen
Fabtrol Systems, Inc
Eugene, Oregon, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00621043
Message ID:
00621045
Views:
15
>I have a stored procedure (called from FoxPro) that iterates through a cursor and executes a positioned UPDATE. It works, but appears to be returning a cursor for each UPDATE. How can I prevent this? I would like this process to run on the server until it is done, without any cursors being returned.
>
>mj

Try to add SET NOCOUNT ON at the beginning of the SP.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform