Try calling validation in BeforeRowColChange Event.
Aashish
BeforeRowColChange Event
>Hi everyone,
>I have built a stored procedure for record validation. In my dbc I use the field level validation rule to call it. This table is used in a grid. In my grid before I save the form I loop thru the items and set the fieldstate to 2. I expected the field validation to fire but it doesnt fire until after the record pointer is moved to the next record. I wanted it to fire before moving off the record because it sets an image to red in the last column of the grid and then refreshes it. LIke so:
>SELECT table
>SCAN for matching key
> DO beforesave (changes fieldstates - hoping to trigger field val.)
> THISgrid.refresh (changes button to red or green appropriately)
> THISgrid.displayerrors (displays a messagebox with all the problems)
>ENDSCAN
>
>save parent record here.
>
>
>The field validation fires when you get to the endscan. I want it to fire before the gridrefresh.
>
>TIA,
>
>Sandi Cassidy
>
scassidy@canaccount.com