Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro Substitution in a Report?
Message
From
12/04/1999 15:49:40
 
 
To
12/04/1999 15:18:34
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00207535
Message ID:
00207545
Views:
12
If you know the order of the fields, (the key field is always field #1) you could use EVAL(FIELD(1))

>>I have a program that needs to report on information from a table, but the system will not be informed of the layout of the table until runtime. I have tried everything I know to set it up so that the reporting routine works regardles of the name of the fiels using macro susbstitution. So far nothing has worked. Any hints?
>>
>>Thanks in advance...
>>
>>
>>John Dennis
>
>I guess you may use UDFs. For example, use as field expression "GetMyField1":
>FUNCTION GetMyField1
>DO CASE
>CASE Alias()="TABLE1"
> Return table1.field5
>CASE Alias()="TABLE2"
> Return table2.field8
>*** etc.
>ENDCASE
>
>Instead of Alias(), you may check something else, e.g. FCOUNT(), whatever is more appropriate for your design, some pre-set variable in ultimate case.
--Todd Sherman
-Wake Up! Smell the Coffee!
Previous
Reply
Map
View

Click here to load this message in the networking platform