Share
Report
15Hello,
when I select a record in the form "bfpprodmastertable" in the table "bfpTmpProdMasterTable" there are for exemple two lines in the production order which includes two lines of field "inventsizeid" in the "Inventdim" table. My object is when I select this record and I gi to my form"demordredefermeture" which exists my new table"demordrelinetable" I want to retrieve automatically in my field "demsize" two line only of "inventsizeid" which includes the values of field "inventsizeid" I try with this code but everytime I enter in my new form the number of lines of this fields is repeated. My goal is to display just once only the list of this field "inventsizeid"
public void init()
{
super();
FormRun formrun=element.args().caller();
bfpTmpProdMasterTable bfpTmpProdMasterTable =formrun.dataSource("bfpProdMasterTableTmp").cursor() as bfpTmpProdMasterTable;
ttsbegin;
while select ProdTable where ProdTable.bfpprodmasterId==bfpTmpProdMasterTable.prodmasterId
{
select InventDim1 where InventDim1.inventdimId == ProdTable.InventDimId;
dEMOrdredefermetureLineTable1.DEMSizeEJB=InventDim1.InventSizeId;
dEMOrdredefermetureLineTable1.insert();
}
ttscommit;
I need help plz
All responses (
Answers (
