>Hello comunity
>
>i need the correct syntax to copy my current cursor to another new one for changing some values and after that i wnat to replace the primary cursor values with the new ones.
>Exemple:
>my current cursor name is tempccf and i have one column value call vencido (varchar), the value in there is "Vencido !?", i want to create a new cursor named Mycurs like this:
>1.copy the structure of tempccf
>2.copy all the values of tempccf to my new cursor Mycurs
>3.update Mycurs.vencido with 'Vencido'
>4.replace all the records of my tempccf cursor with all the records of my new cursor Mycurs.
>
>I put just a simple field column, because if i understand the correct way to do that , i can change all kind of values.
>
>Note : if i type
>select tempccf
>brow
>
>I see all the records on my original cursor.
>
>Anyone could help me, because i try some coding , like:
>select tempccf
>copy stru to mycrs
>use mycrs
>append blan
>brow
>
>i VFP give me an error "File is in use" line 3.
>
>Best regards,
>Luis Santos

SELECT * FROM myOldCursor into cursor myNewCursor READWRITE && Copies structure and inserts all records