[6.1.6] UniScript doesn't find my parameter ?

[swierzbicki]

Hello,

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';

ParamCheck is set to true. I'm getting an exception (parambyname not found) when doing :

Code: Select all

UniScript.Params.ParamByName('Id_Type_EDI').AsInterger := 0 ;

What am i doing wrong ?

[AlexP]

Hello,

UniScript doesn't support parameters. The script is executed "as is". If you want to use parametrized scripts, you should use UniSQL.