Averiguamos los id´s de los usuarios

 

SELECT T0.U_NAME, USERID FROM OUSR T0 FOR BROWSE

 

Una vez tengamos el origen y el destino borramos de la tabla de parametrizaciones CPRF toda configuracion del usuario de destino.

 

delte from cprf where usersign = iddestino

 

insert into cprf (formid,itemid,colid,width, visinform, visualindx,editinform,visinexpnd,expandindx,editinexp, folded,extdisable, extinvsbl,usersign)
(select formid,itemid,colid,width, visinform, visualindx,editinform,visinexpnd,expandindx,editinexp, folded,extdisable, extinvsbl,’iddestino‘ from cprf where usersign = idorigen)

Por admin

Deja una respuesta

Ads Blocker Image Powered by Code Help Pro

Ads Blocker Detected!!!

We have detected that you are using extensions to block ads. Please support us by disabling these ads blocker.

Powered By
Best Wordpress Adblock Detecting Plugin | CHP Adblock