>>I have a Create table statement which creates a table of about 200 fields. I keep getting a syntax error and I'm guessing it is because the line is so long. How do I use create table when I have a long list of fields?
>
>
>Not saying that you have not checked, but in a create statement that long are you sure you have not missed a comma between fields or somthing like that. I only ask because I know it's happened to me...
>
>HTH
>Jeff

:). Yes. I checked. I was putting one field per lines, so this macro was about 200 lines long. I guess foxpro didn't like that too much ;). Two alternatives I have found thanks to the great input here on UT is to just copy each line into an array and use 'create table from array' or create only the first field with create table and do a loop for each additional field using the 'alter table add' command.

Thanks everyone!