Larry: Perfect! Many thanks.
On to the next head-scratcher. Bruce > -------- Original Message -------- > Subject: [RBASE-L] - Re: Fail: Computed Column Shows all Nulls (-0-) > From: Lawrence Lustig <[email protected]> > Date: Mon, February 13, 2012 10:25 am > To: [email protected] (RBASE-L Mailing List) > > > You will need to make sure you have > > SET ZERO ON > > in effect whenever you update this table. At that time the calculated value > will be recalculated and, with that setting in effect, the NULLs will count > as 0 (right now you're seeing the effect of NULL causing the calculation to > produce an undetermined results). > > To fix the problem in the short term: > > SET ZERO ON > UPDATE YourTable SET SomeColumn = SomeColumn > SET ZERO OFF > > -- > Larry > > > ________________________________ > From: Bruce Chitiea <[email protected]> > To: RBASE-L Mailing List <[email protected]> > Sent: Monday, February 13, 2012 1:19 PM > Subject: [RBASE-L] - Fail: Computed Column Shows all Nulls (-0-) > > All: TIA > > RBG91_64.EXE SU > Build: 9.1.5.20103 > Windows 7 Ultimate > > Problem: > The null (-0-) value appears in a computed column across ALL rows in a > browsed table, where the computed column has been added after the table > is populated with data. > > Creating the computed column: > 1. Create/insert a computed column in an existing data-populated table. > 2. Insert the computed column below all columns used in the calculation. > 3. All columns share the data type CURRENCY. > 4. Simple expression: "(col1 + col2 + col3 + col4 + col5 + col6)". > 5. There is at least one null (-0-) value in EACH row within the column > set [col1 ... col6]. > 6. There is no row with ALL null values in column set [col1 ... col6]. > > Thoughts? > > Bruce Chitiea > SafeSectors, Inc. > 909.238.9012 cell
