>Ok, apparently I have teh dumb today
>
>I'm trying to create a table structure in a program by building a list and then issuing the command
>Create table Table1 &FieldList
>
>and I keep getting a 'syntax error'.
>
>I'm building based of off values in a particular table column
>
>

>mflist = "'" + '(SCN C(7),'
>i = 1
>do while i <> 100
>  i = i + 1
>  if empty(idno)
>    skip
>    loop
>  endif
>  if i = 100
>    mflist = mflist + 'F' + alltrim(idno) + ' c(1))' + "'"
>  else
>    mflist = mflist + 'F' + alltrim(idno) + ' c(1), '
>  endif
>  skip
>enddo
>sele 0
>create table Table1 &mflist
>

>
>I'm putting an 'F' in front of the 'idno' fields because the value is a number (character)
>
>Now, I can go into the command window and say
>

>mflist = '(scn c(7), f200183 c(1), f9000091 c(1))'
>Create table Table1 &mflist 
>

> and it works just fine.
>
>Anyone see anything that I'm missing?

I think Naomi gave you the answer. Just want to point out that a FOR is faster than DO WHILE. In general, you should always use FOR or SCAN if they're appropriate and use DO WHILE only when you're really waiting for a condition to be true.

Tamar