storing table info in tables

2007-01-07 Thread Jeff
I need to be able to recreate free tables using information stored in tables. I know how to create tables using SQL statements but how would I pull the field [column - hate that about VFP!] information [column name, type, character/column length,... - all stored for reporting] to create a new

RE: storing table info in tables

2007-01-07 Thread Bill Arnold
Jeff, Use tablex copy to temp structure extended create newtab from temp Bill I need to be able to recreate free tables using information stored in tables. I know how to create tables using SQL statements but how would I pull the field [column - hate that about VFP!] information

RE: storing table info in tables

2007-01-07 Thread Sietse Wijnker
, Sietse Wijnker -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Sent: zondag 7 januari 2007 16:50 To: [EMAIL PROTECTED] Subject: storing table info in tables I need to be able to recreate free tables using information stored in tables. I know

Re: storing table info in tables

2007-01-07 Thread Ted Roche
On 1/7/07, Jeff [EMAIL PROTECTED] wrote: I need to be able to recreate free tables using information stored in tables. I know how to create tables using SQL statements but how would I pull the field [column - hate that about VFP!] information [column name, type, character/column length,... -

Re: storing table info in tables

2007-01-07 Thread Chet Gardiner
If I understand your request, you want to build a table of column names, types, lengths, etc. for a bunch of free tables in order to rebuild them. Ed was correct, your best bet is to use AFIELDS() to get an array of field information. You can then store the array into a structures' table along