BeforeValidateNewRecords basic question

[WindForce]

Hi
I have a grid where the user fills in many rows at a time . The grid serves only for adding new records.
Before saving, i would like to validate the rows, i.e there are some fields that must be filled if a row has been edited.
How do i do that in the BeforeValidateNewRecords event? Also, what happens if there is only one "wrong" row and the rest are ok?

Thanks
Jaime

[Mike Reed]

Hi Jaime,

Here is some from a grid. It doesn't do validation, but I'll an example of that. In the code below, you need to have the first two lines. They are already in the 'CanUpdateRecord' event, just make sure your code is after these two lines. This is where I do all validation that is not handled by the field rules.

Result.Cancel = .f.
Result.ErrorHTML = ""

'update session variables if needed. If user is logged, then variables will be assigned
dim session.userid as c
dim session.userip as c
if session.userid = "" then
session.userid = api_getusername()
end if
if session.userip = "" then
session.userip = api_getmachinename()
end if

'set fields values
DataSubmitted.modified = now()
DataSubmitted.modby = session.userid
DataSubmitted.modip = session.userip

'update the field fone1 to use this stored format. xxx-xxx-xxxx
if DataSubmitted.fone1 <> "" then
DataSubmitted.fone1 = left(remspecial(DataSubmitted.fone1),3)+"-" + substr(remspecial(DataSubmitted.fone1),4,3)+"-"+right(remspecial(DataSubmitted.fone1),4)
end if

''In the code above we simply assigned values to the fields modified, moody and modip. We record the date/time, userid and userip address for any changes made to a record. This code is also in the "CanInsertRecord' event and also has this code: (we also record the date/time, user and userip for each record when it added.)
DataSubmitted.added = now()
DataSubmitted.addby = session.userid
DataSubmitted.addip = session.userip

'In the fone1 field we simply store the phone number is a certain format. The field rules already make sure that it is 10 digits long and contains no letters or spaces

'if you wanted to validate the fone1 you could do something like this:

if DataSubmitted.fone1 = "" then
Result.Cancel = .f.
Result.ErrorHTML = "Phone 1 cannot be blank"
end if

Now having said that, you can also do the data validation in the Field Rules. When you have a field highlighted, then look at Display Settings, Validation XBasic. There is some sample code there to show you how. The advantage for this is that the error will appear next to the field. The event validation shows all errors at the top of the screen.
You might also consider checking the 'Immediate validation' box. That will validate the field as soon as the user leaves the field.

Hope that helps.

[WindForce]

Many thanks Mike
I do field validation of course. My issue is when the user just edits one field in one of the rows, does not fill "imperative" fields in that row, then submits all rows at once, so BeforeValidateNewRecords seems the right place. Will debug the event to see exactly what's exposed

[madtowng]

Makes you wonder if you can use the on blur event to return the user to the column not completed.

[WindForce]

Thanks guys.
The issue was fixed by entering my code into CanInsertRecord. I wonder what use is there for BeforeValidateNewRecords :-)