Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Naming fields for tables imported programmatically
Message
From
28/06/2000 08:33:25
 
 
To
28/06/2000 03:49:11
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00385568
Message ID:
00385627
Views:
8
David,

>I guess the programmatic approach would be to IMPORT the file then modify the resulting table structure with ALTER TABLE commands. Best I can tell, that's what the wizard does.

Just do programmatically what the IMPORT Wizard does, but using the commands
CREATE TABLE ...
APPEND FROM ...
For example:
CREATE TABLE mytable ;
(myfield c(6), myname c(25), mynumber N(12,2) )
APPEND FROM somefile TYPE DELIMITED [or SDF, or other types]
David Stevenson, MCSD, 2-time VFP MVP / St. Petersburg, FL USA / david@topstrategies.com
Previous
Reply
Map
View

Click here to load this message in the networking platform