Mike, Changing the var type does not make any difference. Both variables change when the info changes. The PROPERTY command for the weight COMP_BOLWgt works fine. The PROPERTY command for the quantity COMP_BOLPkg is not working. I am sure I am missing something simple.
Jim -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Monday, June 21, 2010 6:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: tab form Remember, convert all number/numeric values to TEXT before using them with PROPERTY statement. ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, June 21, 2010 6:37 AM 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
