At 11:05 AM 1/16/2005, Mike Byerley wrote:
Scenario: The only active control on a row in a scrolling region is a dbCheckBox and the Form is in EDIT mode.
Goal: When Box is Checked/Unchecked, EEP fires on underlying table to sum another column based on the Checked/UnChecked condition of the dbCheckbox.
Problem: When the value of the dbCheckBox is changed, it is in the Edit Buffer and not the underlying table. Any attempt at Table REFRESH or SAVEROW in the EEP nullifies the attempted change of the dbCheckbox control. In other words, if you just clicked it to make it Checked, it refuses and remains UnChecked because as in the aforementioned because REFRESH just reloads the underlying value changing the Checked condition back to UnChecked and SaveRow obviously Fires before checking the condition of the dbCheckbox control.
I can only get the value of the underlying table if I move off the Row forcing the write.
I can think of a couple of workarounds, but the SAVEROW behavior seems out of sequence...
Mike,
How about an enhanced PROPERTY command, such as:
PROPERTY TABLE <tablename> 'UPDATE' SAVEROW RETURN
This will push the control buffer data to the virtual (form) buffer, then SAVEROW writes to the underlying recordset.
Would you like to try it? <g>
Build: 7.1.79.301xx 07:07 PM
Imagine the possibilities!
Very Best R:egards,
Razzak.
