topic Re: Macro Definition Problem in Application Development and Automation Discussions

Macro Definition Problem

Former Member — Tue, 20 Nov 2007 18:53:20 GMT

How do I pass the contents of a field to a macro rather than the field name itself?

For example in the SUBT macro below, I want to pass the VALUE of setnode-subsetname to the SUBTOTAL macro, not the field name itself

DEFINE SUBT.

select * from setnode

where setclass = '0101'

and subclass = 'AAAA'.

and SETNAME = '&1'.

SUBTOTAL setnode-subsetname &1.

endselect.

END-OF-DEFINITION

Re: Macro Definition Problem

naimesh_patel — Tue, 20 Nov 2007 19:02:29 GMT

Parameters can be accessed with &. You don't need to use the single quotes.

DEFINE SUBT.

select * from setnode 
where setclass = '0101'
and subclass = 'AAAA'.
and SETNAME = &1.   " << &1 without quotes

SUBTOTAL setnode-subsetname &1.

endselect.

END-OF-DEFINITION

Use of macro:

SUBT 'TEST40'.

Regards,

Naimesh Patel