>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

Matthew,

To add to the other suggestions, make sure you follow J.Crescencio's advice and do a backup just in case your memo fields are larger than the character field's length limit. When you change to character it may truncate your data.

Renoir