>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
1. Try to use NOFILTER when selecting your temp cursor.
2. Try to save values of fields in temp cursor to a memory before calling update
local m_jobstobook, m_mydex
m_jobstobook = temp.jobstobook
m_mydex = temp.mydex
Update jobspread set jobstobook = m_jobstobook where mydex = m_mydex