Grid Component Logic Check (validation)

[Dan Blank]

I have a grid component where the user may check a box (Cert SDB). If the user checks that box I want them to also enter an NAICS code. If the user doesn't check the box then I don't care if the NAICS code field is filled in or not.

So where would I put the validation code for this? I have played with CanUpdateRecord, CanInsertRecord, BeforeValidate.... etc. I can't get the logic check to fire, nor display my message saying that the NAICS code is required.

Thanks,

Dan

[Pat Bremkamp]

Re: Grid Component Logic Check (validation)

Dan,

Sounds like a good place for Xbasic field validation in the field properties. Probably not necessary to use an event.

Pat

[Dan Blank]

Re: Grid Component Logic Check (validation)

Hi Pat,
Well tried that but no go. I even used the built in sample for that field being blank and I do not get an error message. The field name is Lfb1_pri_naics. Below is the code I used.

function validate_Lfb1_pri_naics as p (e as p)
'Sample validation function.
'Data for the current row is available in 'e.data'. For example, e.data.firstname, e.data.lastname
if e.data.Lfb1_pri_naics = " " then 
   validate_Lfb1_pri_naics.hasError = .t.
   validate_Lfb1_pri_naics.errorText = "NAICS cannot be blank."
end if	
end function

[Dan Blank]

Re: Grid Component Logic Check (validation)

Ok, I need to retract the last post. I re-published the whole application and now it is working. For some reason (strange) when I just published the component it wouldn't work. However, after repulbishing the entire app, it is working.


Thanks,

Dan

[Dan Blank]

Re: Grid Component Logic Check (validation)

Well, this feature works only every so often. Sometimes it works and others it just saves the record change. No Consistancy!

Surely there has to be a better way??

Anyone??

Thanks,
Dan

[Pat Bremkamp]

Re: Grid Component Logic Check (validation)

Blank does seem a bit spotty. I've had better luck with

if len(alltrim(e.data.Lfb1_pri_naics))=0 " " then

[chadbrown]

Re: Grid Component Logic Check (validation)

if e.data.Lfb1_pri_naics = " " then

Get Rid of the space between the quotes it may help.

Didn't you also say that another field is part of the validate but I don't see it in the code?

I think this is more what you are after

if e.data.certsdb=.t. .and. e.data.naics="" then

[Dan Blank]

Re: Grid Component Logic Check (validation)

Hi Chad, Yeah I was testing the first code just to see if that would work. That only works intermittently, not a good sign. My actual code is

if e.data.Lfb1_mindkc =.T. .and. e.data.Lfb1_pri_naics = "" then
   validate_Lfb1_pri_naics.hasError = .t.
   validate_Lfb1_pri_naics.errorText = "NAICS cannot be blank."
end if

Which doesn't work at all.

I am now trying Pat's suggestion, so my new code is

if e.data.Lfb1_mindkc =.T. .and. len(alltrim(e.data.Lfb1_pri_naics))=0 " " then
   validate_Lfb1_pri_naics.hasError = .t.
   validate_Lfb1_pri_naics.errorText = "NAICS cannot be blank."
end if

Which does not work either!!

[Pat Bremkamp]

Re: Grid Component Logic Check (validation)

Sorry, I neglected to remove the extra quotes after the 0

Should have been
if e.data.Lfb1_mindkc =.T. .and. len(alltrim(e.data.Lfb1_pri_naics))=0 then
validate_Lfb1_pri_naics.hasError = .t.
validate_Lfb1_pri_naics.errorText = "NAICS cannot be blank."
end if

[chadbrown]

Re: Grid Component Logic Check (validation)

is it sql or should I say null field?
also maybe the .T. needs to be true or .t. or 1
I cant remember the example on that.

Yes Pat I saw that but I thought it was something else you are probably right.

[Dan Blank]

Re: Grid Component Logic Check (validation)

Hi Pat,

After I got the extra characters at end of exprssion Error, I removed the quotes.

Still no go.

If anyone wants to try, I uploaded the table and component. The idea is if the user checks the Cert SDB and/or the SDB box then the NAICS field cannot be blank. Other wise the user can enter the NAICS field if they want to but it is not required.

Thanks,

Dan

[chadbrown]

Re: Grid Component Logic Check (validation)

Sorry Dan I tried to use the component but it seems to be missing a variable which i cant find out where it is specified.

[Dan Blank]

Re: Grid Component Logic Check (validation)

Well Let's try this again.

This version should work because I unzipped it and then played with it afterwords.

Thanks,

[Dan Blank]

Re: Grid Component Logic Check (validation)

Well, I haven't found a solution..... so I am just using the onFocus Javascript to pop up a box and let the user know the field is required if the made a prior selection.

Seems to me that logic checking of field entries will be the next big thing! I think Alpha needs to get more involved with this!

[frankbicknell]

Re: Grid Component Logic Check (validation)

I think I would use the OnBlur event to accomplish what you want. That way the user has made their selection and you can base your logic code on that selection.