Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Save As the data
Message
From
24/09/2006 06:55:27
 
 
To
24/09/2006 05:41:40
Vadhlee Peace_ces
Educational Administrator
Banda Aceh, Indonesia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 7
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156684
Message ID:
01156763
Views:
24
>Thank you very much Tore for quick respons, I'll try by using ALTER TABLE because I'm wanna save data as new table...
>
>thank you
>
>VadhLee

Then I misunderstood you. The easiest way to do this, is as follows
Select youroldtable
Scatter name dataholder && creates an object with all the fields as properties
dataholder.field1=yournewdata && if yo need to change the data
dataholder.field2=yournewdata && repeat for all necessary fields
..
Select * from youroldtable into table yournewtable where .F. && Creates a new empty table
Insert into yournewtable from name dataholder
Previous
Reply
Map
View

Click here to load this message in the networking platform