>Hello Naomy
>
>your SELECT is OK, but i need to replace on mynewcursor column vencido the value:
>i write :
>select tempccf
>SELECT * FROM tempccf into cursor myNewCursor
>select mynewcursor
>scan
>replace mynewcursor.vencido with 'Vencido'
>endscan
>
>at this point , i have an error : " Cannot update the cursor MYNEWCURSOR, since it is read-only."
>
>and after this step , i need to delete all the information of my original cursor tempccf and append all the content of mynewcursor.
>
>Thanks,
>Luis Santos
Try instead:
select allColumnsExceptVencido, 'Vencido' as vencido from TempCcf into cursor myNewCursor READWRITE
Here you need to list all the columns except the one you want a constant value for.
If it's not broken, fix it until it is.
My Blog