Share
ReportHI,
I have a requirement of creating a lookup for order account in purcahse form and purchase requestion form in EP. i wrote a static emthod in respective tables and called the same in datsetlookup method of dataset.
for purchase requestion it is working as expected, but for purchase form it is throwing error as "DataSet specified".
below is my code used in both EP forms
Query query;
TableId lookupTableNum;
lookupTableNum = tableNum(VendorDetails);
//set the fields to be shown in the lookup
_sysDataSetLookup.parmLookupFields(new List(Types::String));
_sysDataSetLookup.parmLookupFields().addEnd(fieldStr(VendorDetails,AccountNum));
_sysDataSetLookup.parmLookupFields().addEnd(fieldStr(VendorDetails,Name));
_sysDataSetLookup.parmLookupFields().addEnd(fieldStr(VendorDetails,VendGroup));
_sysDataSetLookup.parmSelectField(fieldStr(VendorDetails,Name));
query = purchtable::datasetLookupQuery();
_sysDataSetLookup.parmQuery(query);
_sysDataSetLookup.parmDataSet(SysDataSetBuilder::constructLookupDataSet(lookupTableNum).toDataSet());
The above code is working for purchase requestion vendaccount field but not for orderaccount field in purchase form.
Please help me on this.
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
16
