Re: Foxpro questions

I use VFP6. Which command will create a table from a list of field
names and which command will do the opposite? Thanks,
Cass

Dan
Mon Jul 21 17:31:06 CDT 2008

You create an array of field names for a table with Afields("myarray").

Go the other direction with CREATE TABLE (or cursor) tablename FROM ARRAY
myarray. The array can be created in code, but should be in the same format
as that created from Afields().

Dan

Cass Lewart wrote:
> I use VFP6. Which command will create a table from a list of field
> names and which command will do the opposite? Thanks,
> Cass

Anders
Mon Jul 21 17:45:59 CDT 2008


"Cass Lewart" <rlewart@shell.monmouth.com> wrote in message
news:g62skm$gpg$1@news.monmouth.com...
>I use VFP6. Which command will create a table from a list of field
> names and which command will do the opposite? Thanks,
> Cass
>
>
1 CREATE NewTable FROM TableStructX
2 COPY STRUCTURE EXTENDED TO TablestructX

See also
AFIELDS(aStruct, 'alias')
CREATE TABLE | CURSOR FROM ARRAY aStruct

-Anders