Validate double entry

[Bill Parker]

I may be missing something obvious, but I don't find in Help or msg board how to compare 2 fields on a dialog to validate they are the same.

I have email and email2 fields on the same dialog component. On email2 field I want to do a custom validation that
CurrentValue = ? (email)

Can't use {email} as is used in templates.

Bill.

[Phil Rolf]

Re: Validate double entry

Bill,
This might help, it compares the 2 emails, I thought the easiest way was to send a jpg of the parameters.
Good Luck

[Steve Wood]

Re: Validate double entry

Bill,

Here's a bunch of example error trapping for the Validate event of a dialog. The model you want is in the first elseif statement.

if (session.Changepassword = "") .or. (session.Changepassword2 = "") then 
    currentform.has_error = .t. 
    currentform.error_message = "All fields must be filled."
elseif session.Changepassword <> session.Changepassword2 then 
 	currentform.has_error = .t. 
  	currentform.error_message = "Passwords do not match."
elseif session.Customer_ID = "demo" then
  	currentform.has_error = .t. 
  	currentform.error_message = "You can't change the Demo password."
elseif len(session.Changepassword) < 5 then
  	currentform.has_error = .t. 
  	currentform.error_message = "Password must have a length of at least five and have at least one alpha character."
elseif isnumber(session.Changepassword) = .t. then
  	currentform.has_error = .t. 
  	currentform.error_message = "Password must have a length of at least five and have at least one alpha character."
elseif *any(session.Changepassword, session.Customer_ID) = .t. then 
  	currentform.has_error = .t. 
  	currentform.error_message = "Password cannot contain the Customer ID."
end if	

if currentform.has_error = .t. then

else 
... your code
end if

[Bill Parker]

Re: Validate double entry

Thanks Phil. You got my rusty brain moving. Using your approach with a Heading, I could display the error but could not trap it to stop the submit button.

Also thanks to steve. So since I had moved away from the email2 field validate, that got me to using the form Validate event which lets me trap the error. Then I saw Steve's reply, and now I need some tips on the finer points of the syntax. I used

if CurrentForm.Controls.Email <> CurrentForm.Controls.Email2
	CurrentForm.Controls.Email2.Has_Error = .t.
	CurrentForm.Controls.Email2.Error_Message = "Emails do not match"
end if

How does that differ from your use of Session.(fieldname)?

Also just so I am clear, custom validation on a dialog control itself can compare with a constant or with an external table (cross file validation), but not from a value in another control on the current form? That must be done in form validation.

Bill.

[Steve Wood]

Re: Validate double entry

The only difference between session.fieldname and just fieldname is how you set the scope in the properties for each field on the dialog. They are either local or session.

Yes on your last paragraph. You can however use some javascript to validate client-side as they type. But you'd have to research that. You can see where it says "client side validation' for each of the dialog controls. I haven't used that.

[Phil Rolf]

Re: Validate double entry

My approach would catch the error on the spot. I am going to include some of the same checks Steve had so if the user ignored my error message then it would catch it on the submit.

By the way Steve, when going thru your code I was looking to see if were checking the amount of water in the sink. You didn't miss anything with your checks. Job well done....

[Bill Parker]

Re: Validate double entry

Ah yes, client side vs. server side. Us desktop guys need to put a sign on the monitor!

Bill.