>Sometimes it seems that the controls have not updated their controlsource by the time this event fires. I have a grid where I want to validate that the 4 fields add up to zero but not all time it works.
>
>Simplified code
>
>PROCEDURE BeforeRowColChange
>LPARAMETERS nColIndex
>
>ln_paid = payment + discount + writeoff
>IF ln_paid > ac_arapl->balance
> =MESSAGEBOX('out of balance')
> NODEFAULT
>ELSE
> =DODEFAULT(nColIndex)
>ENDIF
>
>
>When I trace though the table values are updated but if I let it run and debug out the ln_paid var it's like the last field I changed before I arrowed down into the next row isn't updated yet. I tried the FLUSH command but it didn't work either.
vfp design is wrong here.
vfp update the cell's controlsource after the BeforeRowColChange.
with NODEFAULT you stop the change activate cell, but you can leave the grid with a bad update.