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