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
>
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,...
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
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,..
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
5 matches
Mail list logo