General information
Category:
Coding, syntax & commands
>>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.
Thanks, I will take a look at the udf idea.
jd
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only