Advanced PowerBuilder

HomePrevious Lesson: Updating Through a Cursor
Next Lesson: Stored Procedures

Deleting Through a Cursor

To delete the current row in a cursor result set, the procedure is similar to updating:
DELETE FROM "product_master"
WHERE CURRENT OF lProductMasterCursor1 ;

As with updating through a cursor, deleting a row is not allowed if the SELECT list contains aggregate functions or uses a GROUP BY clause.
HomePrevious Lesson: Updating Through a Cursor
Next Lesson: Stored Procedures