Updating Multiple Rows
Go Up to Updating Data (Embedded SQL Guide)
There are two basic methods for modifying rows:
- The searched update method, where the same changes are applied to a number of rows, is most useful for automated updating of rows without a cursor.
- The positioned update method, where rows are retrieved through a cursor and updated row by row, is most useful for enabling users to enter different changes for each row retrieved.
A searched update is easier to program than a positioned update, but also more limited in what it can accomplish.