Hi Friends,
Today we are going to create look up using code
1. Create a Form
2.Add a string Edit Control
3.In the methods of control write the following code
public void lookup()
{
//super();
// Declaration
Query LookupQuery = new Query();
QueryBuildDataSource LookupQueryBuildDataSource;
QueryBuildRange LookupQueryBuildRange;
SysTableLookup CustomSysTableLookup = SysTableLookup::newParameters(tableNum(CustTable), this);
;
// Add fields that you want in Lookups
CustomSysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));
CustomSysTableLookup.addLookupField(fieldNum(CustTable,Name));
LookupQueryBuildDataSource =
LookupQuery.addDataSource(tableNum(CustTable));
LookupQueryBuildRange=
LookupQueryBuildDataSource.addRange(fieldNum(CustTable,AccountNum));
//LookupQueryBuildRange.value(queryValue(NOYESCOMBO::Yes));
// Execute the Query
CustomSysTableLookup.parmQuery(LookupQuery);
CustomSysTableLookup.performFormLookup();
}
Vivek Chirumammila
Today we are going to create look up using code
1. Create a Form
2.Add a string Edit Control
3.In the methods of control write the following code
public void lookup()
{
//super();
// Declaration
Query LookupQuery = new Query();
QueryBuildDataSource LookupQueryBuildDataSource;
QueryBuildRange LookupQueryBuildRange;
SysTableLookup CustomSysTableLookup = SysTableLookup::newParameters(tableNum(CustTable), this);
;
// Add fields that you want in Lookups
CustomSysTableLookup.addLookupField(fieldNum(CustTable, AccountNum));
CustomSysTableLookup.addLookupField(fieldNum(CustTable,Name));
LookupQueryBuildDataSource =
LookupQuery.addDataSource(tableNum(CustTable));
LookupQueryBuildRange=
LookupQueryBuildDataSource.addRange(fieldNum(CustTable,AccountNum));
//LookupQueryBuildRange.value(queryValue(NOYESCOMBO::Yes));
// Execute the Query
CustomSysTableLookup.parmQuery(LookupQuery);
CustomSysTableLookup.performFormLookup();
}
Vivek Chirumammila
Hi,
ReplyDeleteHow to add more than one filter conditon from this above query?
i.e., i need to further filter the account numbers having currencies as INR..
Thanks
How should we make the first element to be displayed in the combo box through code ...
ReplyDelete