Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table named with digits
Message
De
25/04/1998 12:46:24
 
 
À
25/04/1998 12:23:47
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00094892
Message ID:
00094895
Vues:
25
>One of our table is named with 81500018.dbf. How can we select it using a variable. Assuming lcTable='81500018' and the table is open, the following won't work:
>
>SELECT(lcTable)
>
>As the first character is a digit, Visual FoxPro will try to select the area number instead and not use the table name.

I suppose the correct alias name should be [A], [B], [C]...
Try:
=Aused(UsedAlias)
For iX = 1 to Alen(UsedAlias)/2
  if [8150018] $ DBF(UsedAlias[iX,1])
    CorrectAliasName = UsedAlias[iX,1]
    Exit
  endif
ENDFOR
Of cos, I still advise you to avoid using digit as tablename because still many places need recode. change the name and then easy to maintain!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform