TOTVS CRM | SFA - 12.1.2501
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
fncwschamadoatualizacaoordem()
Parameters
Name
Type
Mode
Definition
DECLARE ordem_nova integer default 1; BEGIN SELECT COALESCE(MAX(ordem) +1,1) INTO ordem_nova FROM chamadoatualizacao WHERE idchamado = NEW.idchamado; NEW.ordem = ordem_nova;RETURN NEW; END;