Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table name in a variable syntax issue
Message
 
To
18/09/2012 13:59:56
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01553159
Message ID:
01553162
Views:
69
>I have a need to access some tables using:
>
>USE (m.TableTo Use) IN 1
>
>I am trying refer to a field in the table this way:
>
>Variable = (m.TableToUse).fieldname  && Is not working for me.
>Variable = (m.TableToUse.fieldname)  && Is also not working for me.
>
>How is it done, please?


First you should be using an alias, then a macro, execscript or STORE


USE (m.TableTo Use) IN 1 ALIAS myTable
STORE Evaluate("myTable.fieldName") TO Variable

"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform