This update would use only values from the current record in your cursor and if the cursor is on EOF nothing would happend at all.
>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
--sb--