Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Create Table From array
Message
 
 
To
04/06/2002 07:09:36
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00664370
Message ID:
00664422
Views:
19
You can use a query command
SELECT name , type , len , decimals ;
   FROM table1 ;
   INTO TABLE table2
>Hi
>
>I have a table1 with 169 records . The table has the fields , name , type , len , decimals , and others fields .
>
>Now , i want create a table2 , with the structure : 169 records the table1.
>Each record in table1 , will go to a field in table2 .
>
>I use the code , but don´t work :
>
>DIMENSION Array1(169,4)
>
>close data all
>use Table1
>sele Table1
>go top
>
>Copy To Array Array1 Fields name , type , len , decimals
>
>Create Table Table2 From Array Array1
>
>
>Can You Help me ?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform