Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating a table, fieldnames in a list
Message
De
27/06/2012 16:31:02
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Creating a table, fieldnames in a list
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 7
Database:
Visual FoxPro
Divers
Thread ID:
01547094
Message ID:
01547094
Vues:
102
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
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform