Is it possible to write in X++ select with conditional join using macro ?
I want to write select like this:
variable1 = value from database;
while
select Table1
#if.VARIABLE1(...) join Table2 where Table1.Field1== Table2.Field1 #endif
{
info(strFmt("%1 / %2", ....));
}
Ofcourse I can make query and write it with query = new query(....) but I have a lot places with code to change. My select is very complex (about 10-14 tables) and I thinking that is it possible to change it with macro. Conditional join depend on value from database (not from constant value !).
*This post is locked for comments
I have the same question (0)
