I need to store a value in a grid.
this is my problem
sc_lookup (dataset, "SELECT SUM (planifica_pme4.monto_pme4) FROM planifica_pme4
INNER JOIN ON planifica_pme3 planifica_pme3.id_pme3 = planifica_pme4.id_pme3
WHERE planifica_pme4.id_pme3 = “{id_pme3}” ");
$ master_valor = {dataset [0] [0]};
{monto_pme3} = $ master_valor monto_pme3;
I need to save the result of the sum of the grid in the field planifica_pme4: monto_pme3 corresponding to the grid planifica_pme3.
what happens is that I put this code in the event of the grid onrecord planifica_pme3 and hands me the correct result in the field but do not save monto_pme3 need to do an update or something and how.
Please is of great importance