The Meeting Place for aXes users to ask questions, supply answers and provide tips and techniques about different ways to use aXes.
https://axes.lansa.com.au/
Code: Select all
var r = [];
var t = "CUSTP"; //動的テーブル名
TABLEMANAGER.loadDynamicTable(
t,
USERENV.dynamicTablesFile,
{
/*Optional for SQLVariables*/
},
false
);
var q = TABLEMANAGER.getTable(t);
/*
* itemsプロパティの caption として取得
*/
r.push({"caption": ""});
for ( var i = 0; i < q.childCount(); i ++ ){
r.push(
{
"caption": q.child(i).value + ":" + q.child(i).text
}
)
}
ENV.returnValue = r;
Code: Select all
var t = "CUSTP"; //動的テーブル名
var q = TABLEMANAGER.getTable(t);
/*
* ENV.itemNumber... 1, 2, 3, ..., n
* q.child.......... 0, 1, 2, ..., n
*/
if ( ENV.itemNumber <= 1 ){
FIELD.setValue("");
}else{
FIELD.setValue(q.child(ENV.itemNumber-2).value);
}