Devart Forums

Posted: **Wed 16 Sep 2009 10:53**

Hello,

how do I use macros in a query without sticking to word boundaries?

I want to use a macro M_TAB=ATable and want to assemble column names by using the macro, i.e.

Code: Select all

select &(M_TAB)_ID ID, text from &M_TAB

should result in

Code: Select all

select ATable_ID ID, text from ATable

Currently the usage of brackets (or something similar) around the macro name does not seem to be possible

Posted: **Thu 17 Sep 2009 07:53**

Currently it is not possible.

We will investigate the possibility of implementing this feature.

Posted: **Thu 17 Sep 2009 07:57**

I would suggest to use the oracle mimic, stopping at the first ".".

In the syntax should be

Code: Select all

select &M_TAB._ID ID, text from &M_TAB

Kind regards
Jens

Devart Forums

Advanced usage of Macros

Advanced usage of Macros