>Hi Ed,
>
>What "trickery" were you talking about?
I'm certain you're far too saavy to need such simple practices, but for the benefit of people who aren't, you can take a cursor from a SQL Select statement and make it writable by reopening the file in a different area. It requires that the cursor be an actual cursor and not a filtered view of the base table:
SELECT foo, bar, baz, bletch ;
FROM widget;
INNER JOIN doodad ;
ON widget.key = doodad.key ;
WHERE color = "Purple" ;
INTO CURSOR TEMP
USE (DBF()) AGAIN IN 0 ALIAS PurpleWidgets
PurpleWidgets is writable.