Does UniQuery.ExecSQL execute a script or only the first statement of the script ?

[swierzbicki]

Hello,

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;

This SQL is calling from TUniQuery.ExecSQL (I'm using a Tuniquery component because of the parameters)

[AlexP]

Hello,

Currently, multiple SQL statements are supported either without parameters or each statement must have the same number of parameters and their names.
We will consider the possibility to support multiple parameters in the next versions.

[swierzbicki]

Thank you

[AlexP]

You are welcome. Feel free to contact us if you have any further questions.