Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to convert a cursor to a DBF table
Message
De
29/01/2007 06:45:11
 
 
À
28/01/2007 23:26:49
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 6 SP5
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01189961
Message ID:
01189994
Vues:
10
>with the help of SQL i extract data from various tables and store these rows of data in a CURSOR.
>
>i want to now convert this cursor into a simple DBF file.
>
>How may i do so ?
>
>With sincere thanks in advance.
SELECT fieldA, fieldB FROM MyTable INTO CURSOR MyCursor
* with all the joins you want.
* once you have the cursor:
SELECT MyCursor
COPY TO C:\MyFolder\MyTable
this will copy the cursor to a DBF on disk.


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform