Hi, I have a TmpFrmVirtual table and I want fill it and after link it to a ShipQuantity control. I use this code but it doesn’t work: while select * from _SalesLine { _tmpFrmVirtual.tableNum =_SalesLine.tableId; _tmpFrmVirtual.recordNo =_SalesLine.recID; _tmpFrmVirtual.ItemId =_SalesLine.SalesId; _tmpFrmVirtual.Qty =_SalesLine.invoicedInTotal(); _tmpFrmVirtual.write(); } qry=new query(); qbds_SalesLine=ds_SalesLine_DS.query().dataSourceName(“ds_SalesLine”); qbds_tmpFrmVirtual=ds_tmpFrmVirtual_DS.query().dataSourceName(“ds_tmpFrmVirtual”); qbds_SalesLine.addSortField(fieldnum(SalesLine,TableId)); qbds_SalesLine.addSortField(fieldnum(SalesLine,recID)); qbds_tmpFrmVirtual.joinMode(joinmode::InnerJoin); qbl=qbds_SalesLine.addLink(fieldnum(SalesLine,tableId),fieldnum(tmpFrmVirtual,tableNum)); qbl=qbds_SalesLine.addLink(fieldnum(SalesLine,recID),fieldnum(tmpFrmVirtual,recordNo)); ShipQuantity.dataSource(qbds_tmpFrmVirtual); ShipQuantity.dataField(fieldnum(tmpFrmVirtual,Qty)); And: If code works, what will I do to form to show ShipQuantity control’ changes? thanks for your consideration
Use: ds_tmpFrmVirtual.settmpdata(buffer);