BeforeValidateNewRecords

[Ren� Stout]

Hi,

I used the BeforeValidateNewRecords function in the Event sewction of a grid to give a field a value (see below).
This works fine, but I get it working only for a field that is visible and not a label. I would like to do this for a hidden field, or at least a label.

Is this possible?

GReetings, Ren�

function BeforeValidateNewRecords as v (DataSubmitted as P, Args as p, PageVariables as p)
with PageVariables
DataSubmitted.User_Id = session.__protected__PraktijkUserID
end with


end function

[Lenny Forziati]

RE: BeforeValidateNewRecords

Notice that session is not passed directly into the function, so you cannot use session."whatever" directly. Instead use PageVariables.session."whatever"

[Ren� Stout]

RE: BeforeValidateNewRecords

Lenny,

the variabel was passed to the field, but only when the field was not a label and was visible.

I changed the function according to your instructions, but the behaviour stays the same.

What I encounter is this:
a - when I insert a record, I can only change the value of a visible field that is not a label. (I do this in the BeforeValidatNewRecord event).
b - when I only edit records (without inserting one) the system inserts a record because it changed the field of the insert-row.

So, here's two questions:

1- What should I do if I want to add a value to a hidden field when I insert a record?

2- How do I prevent that, if I edit a record, the system inserts a record because it fills a field in the blank row?

Greetings, Ren�

[Selwyn Rabins]

RE: BeforeValidateNewRecords

alpha five adds a new row if the new row is 'dirty'

by 'dirty' we mean that one or more controls in the new row have a different value than their original value (when the page was displayed).

if you set the value of the hidden control in the new row, (when all of the other controls on the row have not been edited by the user before he hit 'submit' -- then a5 will see this as a 'dirty' row and will add a new record to the database).

so, in your 'beforevalidateNEWrecord()' event, you have to do more work. you have to check all of the submitted values and only if you detect that the user has actually entered a value into one of the visible fields should you set the value of the hidden field.


on the issue of 'labels'. i am not sure if i understand your question, but it seems like you are trying to manipulate the value that is shown in a label control in the event. you can't do this. the event only deals with data that is submitted to the server when the user clicks the 'submit' button. 'label' controls don't submit data to the server.

[Selwyn Rabins]

RE: BeforeValidateNewRecords

alpha five adds a new row if the new row is 'dirty'

by 'dirty' we mean that one or more controls in the new row have a different value than their original value (when the page was displayed).

if you set the value of the hidden control in the new row, (when all of the other controls on the row have not been edited by the user before he hit 'submit' -- then a5 will see this as a 'dirty' row and will add a new record to the database).

so, in your 'beforevalidateNEWrecord()' event, you have to do more work. you have to check all of the submitted values and only if you detect that the user has actually entered a value into one of the visible fields should you set the value of the hidden field.


on the issue of 'labels'. i am not sure if i understand your question, but it seems like you are trying to manipulate the value that is shown in a label control in the event. you can't do this. the event only deals with data that is submitted to the server when the user clicks the 'submit' button. 'label' controls don't submit data to the server.

[Ren� Stout]

RE: BeforeValidateNewRecords

ok, thanks.

So my logic was out of line.
What I want to accomplish is this:

When a users inserts a record, I want to be fill a field with a session value. That field should not be visible to the user.

I understand from you that I should make something like this:

if
fieldOne=""
fieldTwo=""
fieldThree= ctod("")
etc.
then
hiddenField=sessionvar
end if

Right?

Ren�

[Ren� Stout]

RE: BeforeValidateNewRecords

ok, disregard this. I found the right way to do it in the help files.