database - Sybase cursor for delete -


In Cibes, using a cursor, you can delete the currently referenced row? If this is the end of reference to the cursor?

From the manual. Sybase.com -:

Using the current location of the deleted statement section, you can delete the row in the current cursor state. When you delete a line from the cursor's result set, the row is removed from the underlying database table. Using the cursor, you can only delete one line at a time.

After removing a line from the cursor, the cursor over the adaptive server cursor holds the cursor before the line after the deleted row in the result set. You must use Fetch to reach the next line if the deleted line cursor is the last line of the result set, then the adaptive server sets the cursor after the last line of the result.


Comments