>>If I have a remote table with a field name of 1st2ndDeathBenefit. How do I select from that table by aliasing the field name into something fox understands. I have tried:
>>
>>Select "1st2ndDeathbeneft" as DeathBenefit
>>Select '1st2ndDeathbeneft' as DeathBenefit
>>Select (1st2ndDeathbeneft) as DeathBenefit
>>Select Eval(1st2ndDeathbeneft) as DeathBenefit
>>Select &1st2ndDeathbeneft as DeathBenefit
>>
>>all to no avail. Does anyine have any ideas?
>>
>>Ashley
>>AssureSoft Ltd
>well, your first two attempts will create a file with 1 field (DeathBenefit) with '1st2ndDeathbeneft' as the contents.
>
>The third and fourth will send Fox looking for fieldnames of whatever is held in the variable '1st2ndDeathbeneft'.
>
>Have you tried "Select 1st2ndDeathbeneft as DeathBenefit...."?
There's one trick that may work - I've been experimenting with a view which had an Excel sheet as underlying table. The sheet's columns had rather descriptive titles, and the view designer digested all the funny names using syntax like this:
Select table_alias."whatever the expression" as whatever_the_expression, table_alias."3rd expression" as _rd_expression...
so in this case, it would probably work as
Select whateveralias."1st2ndDeathbeneft" as DeathBenefit