I had that problem, note that removing onchange event in my case, and generating the code again without the event, plus we change the TYPE-FIELDS, generate the code, went back to create onChange events and there if I grabbed
My observation is that as if the code generator does not grind them well above and stay old code
I have a FORM.CLIENTES with a Select object on the table SUPERVISORS, selecting the SUPERVISOR to fill the field and CLIENTES.SUPERVISORES. also in the same process SUPERVISOR I have to get the hierarchy to which it belongs, and assign it to the customers tab CLIENTES.JERARQUIA_SUPERVISOR = SUPERVISOR.JERARQUIA.
My problem is you have to update Onchange RANK-SUPERVISOR field, but can not get on-screen tab CLINETES vueva I attempt to show the new value obtained for the field-SUPERVISOR RANK …
- How I can refresh the value of this field in the FORM?
I pass the code
/**
- CLIENTES.SUPERVISOR->ONCHANGE: Busco para el supervisor asignado la jerarquia que tiene y se lo asigno a campo clientes.jerarquia_supervisor = supervisores.jerarquia
*/
$ger_super=“1”;
$check_sql_supervisor = “SELECT idCodigo_supervisor, Jerarquia, "
. " FROM Jerarquia_supervisores”
. " WHERE IdCodigo_supervisor = ‘" .{supervisor}. "’";
sc_lookup(rs, $check_sql_supervisor);
if (isset({rs[0][0]})) // Row found
{
$ger_super={rs[0][1]};
{jerarquia_supervisor} = {rs[0][1]};
}
else // No row found
{
{jerarquia_supervisor} = ‘42’;
sc_field_display({jerarquia_supervisores}, off);
}
echo " Hemos buscado al {supervisor} \p
y hemos obtenido la siguiente jerarquia {jerarquia_supervisor} \p
El resultado de la tabla es $rs posicion 0,1 {rs[0][1]} \p
la sentencia fue $check_sql_supervisor \p
$ger_super" ;