[6.1.6] UniScript doesn't find my parameter ?
Posted: Mon 07 Sep 2015 15:18
Hello,
Here is my UniScript.SQL script :
ParamCheck is set to true. I'm getting an exception (parambyname not found) when doing :
What am i doing wrong ?
Here is my UniScript.SQL script :
Code: Select all
DELETE FROM edi_livraisons_details_transferts
WHERE "Id_Type_EDI" = :Id_Type_EDI;
INSERT INTO edi_livraisons_details_transferts
SELECT
:Id_Type_EDI,
"Code_Barre",
"Id_Type_Produit",
"Id_Produit",
"Id_Taille_Produit",
"PCB",
"Id_Ordre_Fabrication",
"Compteur",
"Id_Emplacement_Colis",
"Date_Mouvement",
"Heure_Mouvement",
"Date_Transfert",
"Heure_Transfert",
"Utilisateur",
"Id_Commande",
"Id_Transporteur",
"Id_Entrepot"
FROM
colis_mouvements_details
WHERE
colis_mouvements_details."Id_Type_Mouvement_Colis" = 'XXX' AND
colis_mouvements_details."Date_Export" IS NULL AND
colis_mouvements_details."Id_Entrepot" = 'ZZZ';Code: Select all
UniScript.Params.ParamByName('Id_Type_EDI').AsInterger := 0 ;