I have a SQL query that updates the calc field in a table.
The query is this and it works.
update tm_allenamenti SET gg_scad=gg_scad +1 ,stato_allenamento = if(gg_scad<-7,'Attivo',if(gg_scad>0,'Scaduto','In scadenza'))
where gg_scad<100
Unfortunately MySql does not allow me to create the task.
I can use the task function fabrik?
how should I change the query
Thank
The query is this and it works.
update tm_allenamenti SET gg_scad=gg_scad +1 ,stato_allenamento = if(gg_scad<-7,'Attivo',if(gg_scad>0,'Scaduto','In scadenza'))
where gg_scad<100
Unfortunately MySql does not allow me to create the task.
I can use the task function fabrik?
how should I change the query
Thank