General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Stored Procedure and Validation
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only