Server side code not firing on Change

[John Fligg]

When INSERTING a field on a form I have code to update another field which is working fine. However when I EDIT that record and change the fields the code does not fire.

Example: Enter First Name and Last Name and derive Full Name. On Insert FullName = First Name + Last Name but on Edit, even if First and/or Last Name is changed the FullName does not change.

John

[Bruce]

what is your code, (exactly) and where (exactly) did you put it?
tip: Name the routine where it ends up, not the embed point name - that's more useful to me.


cheers
Bruce

[John Fligg]

The code is Routine/General/Field/2 Validate/Add Server Side Code and is:

p_web.SSV('CON:FullName',Left(Clip(p_web.GSV('CON:FirstName'))) & ' ' & Left(Clip(p_web.GSV('Con:LastName'))))

I suspect I am using the wrong embed point although that is where it took me. I scoured the book and docs but could not find what the differences between Validate 1,2,3 are.

Thanks

John

[Bruce]

Don't look at the embed tree. Look at the generated source. ie Right-Click on a procedure in the app tree and choose source.
the embed tree is sorted alphabetically, so 1,2 and 3 are just use for order. However to understand why there are 3 of them you should look at the source.

One should always look at the embedded code in context - reading the code around your embed code to see if what you're doing is in the right place, and in harmony with the code around it.

Incidentally, answer the question again, what is the location, by referring to the routine name in which it has been embedded.

Cheers
Bruce

[John Fligg]

Validate::Con:LastName Routine

Thanks

John

[Bruce]

Right, so you've added it to the LastName, field but not FirstName field.
If you want it to happen on either field, then you need to add it to both fields.

cheers
Bruce