I haven't been able to find much information on Fetch for Update. Does 8.3
support this command??
If so, could someone please point out my error in the following?
Bob
BEGIN
SELECT count (p_id.pid.process_id) INTO Proccount
FROM p_id.p_id
WHERE process_id = new.process_id;
Declare
procgraphic cursor for
select process_id
from p_id.p_id
where p_id.p_id.p_id_id = proc_count.p_id_id;
Begin
Fetch first in procgraphic for update
Update p_id.p_id
set proc_graphic_position = one
From graphics.proc_position
where graphics.proc_position.proc_count = proccount;