SAP SQL Anywhere

Question

Hello!

I have a small problem in SQL, I hope someone can help me.

I want a CURSOR - FETCH, but the code did not return anything.

I use ASE 15.0.3, SQL Advantage 11 and the following code:

create procedure sales
as
declare @sale_id tid
declare @product varchar(80)
declare sales_cur cursor for
select sale_id, product
from sales
where product = 1
open sales
fetch sales
into @sale_id, @product
while (@@sqlstatus = 0)
begin
select @sale_id, @product
end

But nothing happens ... what am I wrong?

Answer 1

0	This forum is for questions about SQL Anywhere. Please refer to the FAQ page and post your ASE question on the ASE forum (link is in the FAQ). permanent link answered 15 Apr '14, 02:39 Mark Culp 24.9k●10●141●297 accept rate: 41% flat view

SAP SQL Anywhere

[closed] CURSOR - FETCH Statement

The question has been closed for the following reason "Question is off-topic or not relevant" by Mark Culp 15 Apr '14, 02:39

Follow this question

Related questions