Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
INSERT INTO enhancements
Message
 
À
09/10/2002 20:02:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00709624
Message ID:
00709636
Vues:
20
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform