Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Create a table from a table of a structure
Message
De
24/07/2008 17:03:12
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
24/07/2008 16:33:10
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
Divers
Thread ID:
01333451
Message ID:
01333899
Vues:
8
>Dragan
>
>please explain to me
>
>I have myTable1 (id i, name c(10), adres m)
>
>select myTable1
>copy struc extended to myTable1.xyz

Here you get "File is not open." error. It's trying to create mytable1.fpt, which already exists and is open by your own process. This is where you're trying to have two instances of the same file, and Fox won't let you.


>create myTable2 from myTable1.xyz
>
>I end up with myTable2 (id i, name c(10), adres m)

Are you sure? I just pasted what you wrote here (replaced "I have" with "create table") and I got the error. Besides, try to open mytable1.dbf and mytable1.xyz now, and see which one of them owns mytable1.fpt.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform