Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table named with digits
Message
From
25/04/1998 12:46:24
 
 
To
25/04/1998 12:23:47
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00094892
Message ID:
00094895
Views:
24
>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform