>I am using the table sum function in the after row/col click event in a grid on the form and sending the results to variables
>
>Example:
>SUM TABLE.COLUMN TO RESULT
>
>It works fine but produces bleedthrough of the result to the form. Replacing the grey of the form with a small whit box containing the word sum and the relult.
>
>Is there a way to avoid this
Thomas,
It's 'set talk on' behaviour. 'Set talk' like some other 'set's are scoped to current datasession. In form.load or DE.beforeopentables add a 'set talk off'.
You would have another problem with summing on grid source, record pointer moves. Also if this is a parent-child situation summing many child records unnecessarily again and again in ARCC might be a performance penalty.
In a parent-child case consider :
-Tableupdates almost always done before parent record changes.
-Once a tableupdate is done SQL could return up-to-date data
-Subsequent summing could only be done on fields affecting the result w/o an actual sum but by subtracting old from sum and adding new value. This greatly improves performance IMHO.
Cetin