Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

Help-Code Conversion

21 views
Skip to first unread message

farsh...@gmail.com

unread,
Nov 17, 2012, 11:19:01 AM11/17/12
to csharp...@googlegroups.com
Hi 
I'm a Beginner., How can I use the following code SQLite? 
Thank you 

declare @id int, @price int,@price1 int, @sum int 
set @sum = 0 
DECLARE sum_cursor Cursor 
FOR SELECT id, Pay,Cash FROM T1 ORDER BY SDate 
OPEN sum_cursor 
FETCH NEXT FROM sum_cursor 
INTO @id, @price,@price1 
WHILE @@FETCH_STATUS= 0 
BEGIN 
select @sum = @sum + (@Price-@Price1) 
update T1 set RE = @sum where Id = @Id 
FETCH NEXT FROM sum_cursor 
INTO @id, @price,@price1 
END 
CLOSE sum_cursor 
DEALLOCATE sum_cursor 
select*from T1 ORDER BY SDate
Reply all
Reply to author
Forward
0 new messages