I have a dynamic cursor that I created from a table. I want to change a value in the dynamic cursor then use an update command to make the changes to the original table.

When I make the update the command is:

Update jobspread set jobstobook = temp.jobstobook where mydex = temp.mydex

Nothing happens. I can use the same commands for two tables and it works fine.

Jobspread is the original table that the cursor is created from. temp is the name of the cursor. Mydex is a unique key.

Thanks for any help you can give