Hi Experts
I am building a On Demand App Generation in my project and have an issue with selections.
The selections that was made from Selection App is not capturing dynamically in Template App when I use variable, where as if I hard code specific field into the looping table is working as expected.
I would like use only one inline table to pass the selection by using variable for multiple fields instead of create more inline tables for multiple fields.
Script statement is not working if I pass variable into Inline table (OdagBinding)
it was not returning any values, you can see in 'pic 1' it should capture selections
SET WHERE_PART = '';
FOR EACH fldname IN 'Account', 'Currency'
trace filed names >>>> $(fldname);
Let $(fldname)='';
OdagBinding:
LOAD * INLINE [
VAL
$(odso_$(fldname)){"quote": "", "delimiter": ""}
](ansi, txt, delimiter is '|', embedded labels);
Let $(fldname)_COLNAME='$(fldname)';
CALL BuildValueList('$(fldname)', 'OdagBinding', 'VAL', 39);
LET vallist = $(fldname);
IF (IsNull(vallist)) THEN
LET vallist = '';
ENDIF
IF (len(vallist) > 0) THEN
CALL ExtendQVDWhere('$(fldname)','vallist');
// CALL ExtendSQLWhere('$(fldname)','vallist'); // use this version for SQL
ENDIF
NEXT fldname
below script working as expected as i manually enter column names refer 'pic 2'
SET WHERE_PART = '';
FOR EACH fldname IN 'Account', 'Currency'
trace filed names >>>> $(fldname);
SET Account='';
OdagBinding:
LOAD * INLINE [
VAL
$(odso_Account){"quote": "", "delimiter": ""}
](ansi, txt, delimiter is '|', embedded labels);
SET Account_COLNAME='Account';
CALL BuildValueList('Account', 'OdagBinding', 'VAL', 39);
SET Currency='';
OdagBinding:
LOAD * INLINE [
VAL
$(odso_Currency){"quote": "", "delimiter": ""}
](ansi, txt, delimiter is '|', embedded labels);
SET Currency_COLNAME='Currency';
CALL BuildValueList('Currency', 'OdagBinding', 'VAL', 39);
LET vallist = $(fldname);
IF (IsNull(vallist)) THEN
LET vallist = '';
ENDIF
IF (len(vallist) > 0) THEN
CALL ExtendQVDWhere('$(fldname)','vallist');
// CALL ExtendSQLWhere('$(fldname)','vallist'); // use this version for SQL
ENDIF
NEXT fldname
so my expectation is to capture Account, Currency fields and their selected values into 'OdagBinding' table and i dont want to use multiple 'OdagBinding' tables for each field, i need one table to iterate columns and dynamically pass into the tables.
let me know if you need more information
could you pls help as it is little urgent.
