Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitution
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00735756
Message ID:
00735848
Views:
25
>Hi,
>how do I write the code for the following example in order to use name expression and to avoid macro substitution?
>
>I have the names of tables named like tablename1, tablename2 etc. The names are created by lcDbf="tablename"+ALLTRIM(STR(i)), where i is a number 1,2 etc. In each table I have a field named "cfield". the referenced field is stored in the variable lcField=lcDbf+".cfield". Further I have the following string in a form lcString="Thisform.Check"+ALLTRIM(STR(i))+".Caption"
>To set the caption I use &lcString=&lcDir, which works. I have tried to avoid macro substitution by doing the following:
>
>&lcString=(lcDir), does not work
>&lcString=EVALUATE(lcDir), works (but EVALUATE() is not a name expression?)
>(lcString)=EVALUATE(lcDir), generates the error "unrecognized command verb"
>EVALUATE(lcString))=EVALUATE(lcDir), generates the error "syntax error"
>
>In this case it looks like you can not entirely avoid macro substitution, or do you have any sugestion?

Others have given solutions on how to write it without macro substitution. So, it's possible. But IMO macro substitution is a very legitimate technique.
Groet,
Peter de Valença

Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform