Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Adding a Cursor Structure to a Database
Message
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 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01047482
Message ID:
01047491
Vues:
16
This message has been marked as the solution to the initial question of the thread.
>I have a program that generated a Cursor. I would now like to open a database and create a new table in the database with the same structure and indexes as the cursor. Then I would like to copy the data from the cursor into the new database table. Is there any commands out there that will aid me in doing this, instead of manually creating a table field by field.
>
>TIA.

You can use AFIELDS to create an array of the cursor info. Then use the CREATE TABLE FROM ARRAY command. Then APPEND FROM for the data. The indexes, AFAIK, you have to do manually, but there is the ATAGINFO() function that will create an array with the info you need.

UPDATE:

Try:

COPY TO TableName DATABASE MyDBC with CDX
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform