SQL Command Update - Insert

Jeisson Rodriguez

• July 09, 2020 12:49
• Edited

Hello community

Currently I want to perform an insert in the intermediate schema, 
I am using the SQL function but it throws an error, 
they could tell me if this is possible or if I have a bad code.

@STORE1 = SQL('SELECT COUNT(*) FROM OHEM T0 WHERE T0."ExtEmpNo" = $[$BOYX_1.0.0] AND T0."ExtEmpNo" =$[$BOYX_4.0.0]' ); 
IF(@STORE1 = 1) 
BEGIN SQL('INSERT INTO "USUARIOS"."LOGIN" ("ID","CodigoUsuario","NombreUsuario","Fecha","Hora","Estado" ) SELECT '1' ,"USERID", (SELECT "firstName"||' ' ||"lastName" FROM "PRUEBAS_JSON"."OHEM" WHERE "ExtEmpNo" = '5822837' AND "ExtEmpNo" = '5822837'), CURRENT_DATE, CURRENT_TIME, 'INGRESO' FROM "PRUEBAS_JSON"."OUSR" WHERE "U_SEI_Farmacia" = 'Y' AND "USERID" = '1''); 
END 
ELSE 
BEGIN MessageBox(Usuario o Contraseña no validos); 
END



Thank you.

Vote

0

• 

  Jeisson Rodriguez

  • July 10, 2020 11:30

  Find the shape, I share it

  @STORE1 = SQL('SELECT COUNT(*) FROM OHEM T0 WHERE T0."ExtEmpNo" = $[$BOYX_1.0.0] AND T0."ExtEmpNo" =$[$BOYX_4.0.0]' ); IF(@STORE1 = 1)
  BEGIN ExecuteSQL(INSERT INTO "USUARIOS"."LOGIN" ("ID","CodigoUsuario","NombreUsuario","Fecha","Hora","Estado") SELECT '1',$[USER],(SELECT "firstName"||' ' ||"lastName" FROM "PRUEBAS_JSON"."OHEM" WHERE "ExtEmpNo" = $[$BOYX_1.0.0] AND "ExtEmpNo" = $[$BOYX_1.0.0]),CURRENT_DATE,CURRENT_TIME,'INGRESO' FROM DUMMY );
  MessageBox(Login Correcto); END ELSE BEGIN MessageBox(Usuario o Contraseña no validos); END

  :) 

   

Please sign in to leave a comment.