>Note: I am use a traslator.
>
> I have a grid in the one which you digitan numeric values, and the sum of all the values of all the registrations should stop to a field in which the sum of these was stored. To make it, I make a consultation SELEC. The problem is that I need that when the user changes the value in a registration, then be reflected automatically in the sum, without waiting to that this it is kept (since the SELEC doesn't take the change until he/she keeps the registration). Does some of you know as making this?
Running a select per value change is time consuming and also doesn't get buffered records as you said. Instead do only one SQL into array as parent changes. Add code to lostfocus of numeric fields that effect the sum. You only need ArrayValue + (Newvalue-Oldvalue). This approach is fast. ie:
scatter memvar
aSum[1] = aSum[1] + ;
(eval("m."+;
substr(this.controlsource,rat(".",this.controlsource)+1)) ;
- this.value )
Cetin