Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding data to a table from a cursor
Message
 
À
25/09/1997 16:40:53
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00051665
Message ID:
00052305
Vues:
39
1) The table doesn't have to exist, but the cursor can't be simply a filter on a larger table (use either CREATE CURSOR or SELECT .. NOFILTER to guarantee this). 2) It doesn't have to match exactly, only for the fields that you want to append. 3) That would require going through each row in the cursor, checking datestamps, etc. and can't be done from a simple APPEND (but it is possible). 4) APPEND FROM cCursorAlias won't work because the APPEND FROM looks for a real filename, rather than an alias name. APPEND FROM &cCursorDBF works. >Does the table exist? >Does it have the same structure as the cursor? >Do you want to synchronize information between them? Or replace >records? > >How about: > >SELECT myTable >APPEND FROM myCursor > >>Could someone please tell me how to add data to a table from a >cursor?
Paul Russell
EMail: prussell@fox.nstn.ca
Phone: (902) 499-5043
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform