Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
INSERT INTO enhancements
Message
 
To
09/10/2002 20:02:41
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00709624
Message ID:
00709636
Views:
19
>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.

Good thinking 99.

I actually have an intellisense shortcut that puts in :
SELECT MyTableName
APPEND BLANK
GATHER NAME MyObject

because I got sick of typing it in all the time ! :)
Cheers,
Jamie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform