Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create a table from a table of a structure
Message
From
24/07/2008 17:03:12
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
 
To
24/07/2008 16:33:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01333451
Message ID:
01333899
Views:
9
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform