Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can you add records to a cursor?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00252128
Message ID:
00252143
Vues:
9
>>
>>A cursor created by SELECT - SQL is read-only. However, you can issue a USE...AGAIN on the cursor; this renders it read-write, where you can perform nearly all table-related operations.
>>
>>There's an article in the Knowledgebase FAQs on this.
>
>Thanks to Evan Delay for posting that FAQ!

Jeff,

Be carefull! VFP may simply use the dbf again and set a fitler to provide your cursor. If it does this and you USE DBF("CursorName") AGAIN you will be appending into the actual source table and not some temp table that will be destroyed. Be sure you use the NOFILTER option on the SELECT command to force VFP to create a disk file for the cursor.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform