cant not run stored procedure from input file (with cursor)

jzh...@easycare.com

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

cant not run stored procedure from input file (with cursor)

I try to run stored procedure under MS sql7, the stored procedure runs fine,
but with the exact same procedure, if I try to run from input file, it only
returned one row, then return me the error mesg: 'Cursor is not open'

I had several cursor declared in the stored procedure. and using
command line:
c:\mssql7\binn\isql.exe /SServer /Uuser /Ppassward /i \\server\sproc.sql

the sproc.sql is the stored procedure file.

Please advise.

-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Other Threads

1. Changing the mouse to crDefault cursor while running Stored Procedure

2. why i cant list the store procedure ?

3. First input parameter goes missing when calling a stored procedure with ado

4. Input parameter to Stored procedure from Delphi 5

5. Problem Stored Procedure with output and input value

6. SQL 2000 Stored Procedure Input Parameter Problem?

7. Stored Procedure with input values

8. Stored Procedure - Passing Argument in to a Stored Procedure

9. Calling a stored procedure in another stored procedure in SQL Server 7.0

10. Stored Procedures.......Help Needed For A Stored Procedure {*word*269}