Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programatically create Fox 2x Table
Message
From
15/05/2007 11:28:01
 
 
To
15/05/2007 11:22:31
Bill Drew
Independent Consultant
Chicago, Illinois, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01225578
Message ID:
01225596
Views:
21
>>FPD is not aware of codepages so 'type foxplus' is enough.
>>
>>>In the running of a program I need to create a table that can be accessed by a modern application and by legacy applications written in Fox Dos.
>>>
>>>We found that that command copy to ("abc.dbf") type foxplus for .f. would make the structure. Is there any issue with the code page that I need to worry about? Should I also run some code from cpzero to change the codepage to 437 from 1252? Does a change to 437 in itself allow the fox dos application to access it or is the key thing the 'type foxplus' argument. What about 'type fox2x'? Would that work?
>>>
>>>Thnkx
>Sergey,
>
>Is there any way to get this file to be created instantly. Because I noticed a slowdown with the "For .f." argument, I suspect that any time you put "for" foxpro is being asked to evaluate all records and with larger files this could be unacceptable in performance.
>
>Thanks

You could use
SELECT sourcetable
COPY STRUCTURE To temptable
SELECT temptable
COPY TO yourtable TYPE ...
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform