Stored Procedure Declare Select

[trenttc]

Why is it that when I specify 2 column names in the select stmt (vs select 1 column name or select *), I get "Cursor not open" ? I only want to FETCH 2 of many columns.
DECLARE cursorP CURSOR FOR
SELECT code,desc FROM products

 

[bborissov]

Because CURSORS must be opened before use them and also closed and released:

DECLARE cursorP
        CURSOR FOR
SELECT code,desc FROM products

[COLOR=red][b]
OPEN cursorP
[/b][/color red]
FETCH ....



[COLOR=red][b]
CLOSE cursorP
DEALLOCATE cursorP
[/b][/color red]

Can you post what you want to do/. Maybe there is a way to do it w/o cursor. Cursors are performance killers.


Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
MVP VFP

 

[trenttc]

It was a syntax error" he said sheepishly.