Yes you can, but it take another line of code.
Try Use DBF('yourcursorname') IN 0 AGAIN ALIAS newcursorname
HTH
Jeff
>Hello Everyone,
>
>Is it possible to use a sql select to create a cursor and then do a replace in a field in the cursor. I tried this as below but get a 'CANNOT UPDATE THE CURSOR' error message.
>
>
>select name, section from tablename into cursor mycursor
>select mycursor
>replace all section with "A" for section = "V"
>
>I only want to change the values in the cursor, not the original table, and I intend to use the cursor for a report form.
>
>Can anyone help me with this issue?
>
>Thanks,
>
>Jim Harvey
>
jharvey@netrax.net
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com