Why not define these two as variables in the forms itself like this:
vPack = (sum(PackageQty)) in BOLRows WHERE Control# = .vControl AND BOLDate = .vBOLDate Recalc variables will do the rest I think Or does this approach influence the performance too negatively? Tony From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: maandag 21 juni 2010 12:37 To: RBASE-L Mailing List Subject: [RBASE-L] - tab form I am creating a tab form based on two tables which will allow the user to update specific fields. One field is the total package quantity field (Integer). In an On exit EEP (from a field) in the detail section I have this code. SAVEROW SELECT (SUM(PackageQty)), (SUM(PackageTotWgt)) INTO + vPackTot INDIC ivPackTot, + vBOLWeight INDIC ivBOLWeight, + FROM BOLRows WHERE Control# = .vControl AND BOLDate = .vBOLDate PROPERTY Comp_BOLWgt TEXTVALUE .vBOLWeight PROPERTY Comp_BOLPkg TEXTVALUE .vPackTot RECALC VARIABLES RETURN The BOLWeight column (REAL) in the Header updates properly when detail rows are changed . For some reason the BOLPkg column (INTEGER) will not update when the detail rows are changed. When I do a trace on the variables, both of them change whenever the information in the detail sections change. Anyone see something I may be doing wrong in this code? Jim
