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