Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
COPY STRUCTURE EXTENDED and CREATE FROM
Message
De
13/11/2004 02:51:46
 
 
À
12/11/2004 18:08:57
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Divers
Thread ID:
00961060
Message ID:
00961111
Vues:
7
>COPY STRUCTURE EXTENDED and CREATE FROM:
>
>syntax for the CREATE FROM command shows that you can include a database to add the table to. I tried to do this, due to having some longer field names in the table I am creating.
>
>Heres the picture:
>
>I created tables on the fly that have the same structure as you get with a COPY STRUCTURE EXTENDED command. They are part of a data driven system I am developing to flexibly handle our need to import and export files in a variety of formats in our application. I made a form that allows user entry of a file format, as in field name, field type, size, dec. These are stored as definitions for the formats we would need to either import or to export our data into and send to clients.
>
>Then I use CREATE FROM, when I want to create an instance of a defined file format, import to it, and do other processing.
>
>In any case, the command allowing yo to add the created table to a database leads to:
>".DBC Internal consistency error."
>
>The command looks like this. It is executed from the folder containing the 'extended' file (in this case - cpmpbg.dbf)
>
>If I could use short field names this would not matter, but this big nasty one I am working on has like 120 separate fields, with similar names.
>
>
>CREATE cpmrawpbg database test from cpmpbg
>
Can you give us some sample code to see if we can reproduce it?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform