Hi All,
Here's the scoop on the INSERT INTO enhancments talked about at DevCon and mentioned in the UT's conference report. The changes are:
INSERT INTO dbf_name FROM NAME ObjectName
and
INSERT INTO dbf_name [(fname1 [, fname2, ...])]
SELECT [(fname1 [, fname2, ...])] FROM tablename WHERE condition
The first enhancement allows you to append a record to a cursor from an object, maybe an object created from a SCATTER command or custom-created from the new Empty class.
The second enhancement is great for directly filling a cursor with records from another table; a very useful feature.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05