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

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 Sietse Wijnker
Hi Jeff, You can use SAVE TO MEMO to store any variables into a memo field So if you have a tblDefinitions table that has a cName and a mStruct field You can do the following to fill the table: LOCAL laFields[1] SELECT 0 USE tblSource1 AFIELDS(laFields, "tblSource1") SELECT tblDefinitions INSERT

Re: storing table info in tables

2007-01-07 Thread Ed Leafe
On Jan 7, 2007, at 10:50 AM, Jeff 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 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 >