Updating the record using cursor online dating me blog

' '
updating the record using cursor-57updating the record using cursor-64updating the record using cursor-77

They only operate on one row at a time so to access the data returned by the database we must Move the cursor Next or Previous, First or Last.

You can make things a little more obvious by explicitly stating that the cursor is to be used for updating, as shown below: This cursor can be used to update any field from the underlying data set.

To make things even more specific you can list which columns from the data set you would like to make updatable, as shown below: The code above ensures that only one field from the underlying data set can be updated.

Microsoft is conducting an online survey to understand your opinion of the Technet Web site.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

21

Leave a Reply