Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public function insertCondicional($suma,$prima,$fetra,$ustra,$actra,$mqtra){
- global $libl;
- $sql=$this->connect->prepare("MERGE INTO ".$libl.".CTRALTAB A
- USING ".$libl.".CTRALTEMP B
- ON ( A.ACTIAR=B.ACTIAR and A.ACARGU = B.ACARGU AND A.ACFUNC<>B.ACFUNC )
- WHEN MATCHED THEN UPDATE SET A.ACFUNC=B.ACFUNC
- WHEN NOT MATCHED THEN INSERT
- VALUES( 1242, RIGHT ('000000000' || DIGITS($suma), 15),
- RIGHT ('0000000000000000000000000000000000'||000000000000000||DIGITS($prima) , 50)
- , :fetra
- , :ustra
- , :actra
- , :mqtra )");
- $sql->bindparam(":fetra", $fetra);
- $sql->bindparam(":ustra", $ustra);
- $sql->bindparam(":actra", $actra);
- $sql->bindparam(":mqtra", $mqtra);
- $sql->execute();
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement