Hi, I am almost giving up witht he On Update command. I am trying to update fields that I called out  and following the example and I can not make it work. I want to query using the serial number and puplate the rest of the fields (that pieces is working) but then I want to be able to modify such fields and update them back ino the DB,......... that piece is not working. here is my complete code in case soemone can guide me....

 

 

 

 

 

form  Actualizacion_De_Players
{
    displayname  =  "Actualizacion De Players"
    store data in zc = false
    field alignment = left
   
    Lookup_1
    (
        displayname  =  "Numero de Serie"
        type  =  picklist
        values  =  Alta.Serial_number
        width  =  206px
        on user input
        {
            r  =  Alta  [Serial_number == input.Lookup_1];
            input.Player_ID = r.Player_ID;
            input.Cliente_nombre = r.Cliente_nombre;
            input.Player_ubicacion = r.Player_ubicacion;
            input.Player_comments = r.Player_comments;
        }
    )

    Player_ID
    (
        type  =  text
        width  =  200px
    )

    Cliente_nombre
    (
        displayname  =  "Cliente"
        type  =  text
        width  =  200px
    )

    Player_ubicacion
    (
        displayname  =  "Ubicacion"
        type  =  text
        width  =  200px
    )

    Player_comments
    (
        displayname  =  "Comentarios"
        type  =  textarea
        height  =  100px
        width  =  200px
    )

        actions
        {      
            on update 
                {
            type  =  button
            displayname = "Update"
            on click
            {
                r  =  Alta  [Serial_number == input.Lookup_1];
                r.Player_ID = input.Player_ID;
                r.Cliente_nombre = input.Cliente_nombre;
                r.Player_ubicacion = input.Player_ubicacion;
                r.Player_comments = input.Player_comments;
            }
        }
        )
        Reset
        (
            type  =  reset
            displayname  =  "Reset"
        )
    }
}