maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
ot_rw_setctrlcode(integer)
Parameters
Name
Type
Mode
idmayauser
integer
IN
Definition
update mayauser u set ctrlcode = (select u.idmayauser::text || clientcode FROM client WHERE idclient = u.idclient) where idmayauser = $1;