I believe you can also get around this issue by going directly to the dbf file that holds the cursor data.
select * from employee into cursor MyCursor
replace name with 'new name'
select * from dbf('Mycursor')
I have never used code like this in a production system. You may want to give it a try, though.
>Hi,
>
>Just wanted to confirm that I wasn't missing out on a known 'trick' in order to get round this 'issue'.
>
>Seems strange to me that you can reference the record using a scan but the select doesn't pick up the uncommitted records!
>
>Thanks, Hector,
Hector Correa