DELETE CURSOR Example
The following example deletes the row in the "employee" table to which the cursor is pointing:
## declare cursor cursor1 for
## retrieve (employee.empname, employee.empnum)
## open cursor1
loop until no more rows
## retrieve cursor cursor1 (name, idno)
if idno < 1000 then
print "deleting " name
## delete cursor cursor1
end if
end loop
Last modified date: 04/03/2024