Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table name in a variable syntax issue
Message
From
27/09/2012 14:31:02
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
18/09/2012 13:59:56
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01553159
Message ID:
01553780
Views:
62
>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?

Hi Grady

I agree with Hugo, alias is first - macro - third or 4th place worst approach.

m.TableToUse = 'monday'

use (m.TableToUse) alias TheTable

Var = TheTable.fieldname

What are you really trying to do? Breaking tables by weekday sounds fishy to me.

Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform