saludos foristas
miren tengo este cursor
DECLARE @factura varchar(7),@subsal float,
@cargo float,@abonofloat
DECLARE saldo_cursor scroll cursor
FOR SELECT NO_FACTURA,sum(cargo)as cargo,sum(abono) as abono
FROM ANTSALDOS
group by no_factura
order by no_factura
for update of subsaldo
OPEN saldo_cursor
WHILE @@FETCH_STATUS = 0
BEGIN
fetch next from saldo_cursor
INTO @factura,@cargo,@abono
update antsaldos
set subsaldo = @cargo-@abono
where CURRENT OF saldo_cursor
PERO ME MANDA ESTE ERROR
Warning: Null value is eliminated by an aggregate or other SET operation.
Msg 16929, Level 16, State 1, Procedure temp4, Line 27
The cursor is READ ONLY.
The statement has been terminated.
Msg 16929, Level 16, State 1, Procedure temp4, Line 27
The cursor is READ ONLY.
ESPERO PUEDAN AYUDARME
GRACIAS
Leer las respuestas