>A straight SQL that doesn't go into a view would be fine, but then of course I don't think you can't edit the data in a temporary cursor.

SELECT ... INTO CURSOR MyCursor

SELECT 0
USE DBF([MyCursor]) AGAIN ALIAS MyTemporaryTable

REPLACE ...