"where current of @" unrecognized at @local_variable cursor
Posted: Wed 12 Jun 2013 12:58
SQL Complete 4.0.78.1 throws error "'Identifier' expected" and "''conversation'' expected" when using "where current of" like:
When written like below, formatting works as excpected
Both are valid T-SQL batches. Could you please fix this?
Code: Select all
declare @Tab table ( ID int not null primary key, Data varchar(10) null);
insert into @Tab(ID) values (1);
declare @Cursor cursor
, @ID int;
set @Cursor = cursor local for select ID from @Tab;
open @Cursor;
while 1 = 1
begin
fetch next from @Cursor into @ID;
if @@fetch_status <> 0 break;
update @Tab set Data = 'Data' where current of @Cursor; --> @local_variable @Cursor is probably unexpected here...
end;
select * from @Tab;
close @Cursor;
deallocate @Cursor;Code: Select all
declare @Tab table ( ID int not null primary key, Data varchar(10) null);
insert into @Tab(ID) values (1);
declare @ID int;
declare Cur cursor local for select ID from @Tab;
open Cur;
while 1 = 1
begin
fetch next from Cur into @ID;
if @@fetch_status <> 0 break;
update @Tab set Data = 'Data' where current of Cur;
end;
select * from @Tab;
close Cur;
deallocate Cur;