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?
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place