Does UniQuery.ExecSQL execute a script or only the first statement of the script ?
Posted: Mon 06 Jul 2015 16:20
Hello,
I'm executing this script but it looks like only the first statement is used :
This SQL is calling from TUniQuery.ExecSQL (I'm using a Tuniquery component because of the parameters)
I'm executing this script but it looks like only the first statement is used :
Code: Select all
INSERT INTO colis_inventaires_details
(Id_Inventaire, Gencod_Article, Code_Article, Utilisateur, Date_Inventaire, Code_Barre)
VALUES
(:Id_Inventaire, :Gencod_Article, :Code_Article, :Utilisateur, :Date_Inventaire, :Code_Barre);
INSERT INTO colis_inventaires_details_quantites
(Id_Inventaire, Gencod_Article, Code_Article, Gencod_Piece, Quantite_Pieces)
SELECT :Id_Inventaire, Gencod_Article, Code_Article, Gencod_Piece, Nombre_Pieces
FROM articles_details where Gencod_Article = :Gencod_Article and Code_Article = :Code_Article;