loop error,pls

[ximen]

declare @product_code char(10),@rowNR int,@Mrow int
set     i=1
select product_code,row_number() over(order by parent_id) as rowNR,parent_id into #FT_1 from product_code where parent_id='cp'
//select * from #ft_1
//select @mrow=max(rowNR) from #ft_1 
//select @mrow      
while  i<=29 LOOP
    select @product_code=product_code from #ft_1 where i=rownr
select @product_code
set i=i+1
end loop

select * from #t1

error loop

[VolkerBarth]

What do you expect anyone to do now? - Your questions incomplete postings are really becoming a nuisance here, at least in my usually humble opinion:(

[ximen]

Please help me to correction ,I uploaded the pictures of the error thanks,So I'll pay attention next time under my ability of expression

[MarkCulp]

I think the problem that you are having is that you are mixing WATCOM SQL with TSQL. The WHILE ... LOOP statement is WATCOM SQL whereas the TSQL variant of a WHILE statement does not use the LOOP keyword. You have been using TSQL procedures so you need to use a WHILE statement - i.e. remove the LOOP and END LOOP and add in a BEGIN ... END.

OR alternatively, switch to using WATCOM SQL.

HTH

[ximen]

WATCOM SQL so I should go to where to find relevant learning materials

[MarkCulp]

My answer contains the two relevant links for the two variants of the WHILE statement. You can find all of the documentation for SQL Anywhere at http://dcx.sybase.com/index.html