Problem where condition as Parameter in MySQL Stored Procedure
I am passing all where condition as parameter to stored procedure but stored procedure throws error.
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| BEGIN
SET @t1 =('SELECT
documents_articles.id_document,
documents_articles.id_article,
date_document,
code_article,
libelle_article,
num_document,
module_document,
qte_article,
pu_ht,
mouvement_stock_reel,
mouvement_stock_virtuel,
qte_article*pu_ht as valeur_unitaire,
mouvement_stock_reel*pu_ht as valeur_stock
FROM
documents,article,documents_articles
where ');
SET @queryt =CONCAT(@t1,ConditionReq);
PREPARE stmt FROM @queryt;
Set @ConditionReq=ConditionReq;
EXECUTE stmt using @ConditionReq;
DEALLOCATE PREPARE stmt;
END
Parameter ConditionReq=(documents.id_document = documents_articles.id_document) And (article.id_article = documents_articles.id_article) and affecte_stock='Oui' And documents.id_ste = '1' and (str_to_date(date_document,'%d/%m/%Y') between str_to_date('01/11/2017','%d/%m/%Y') and str_to_date('30/11/2017','%d/%m/%Y')) |
Citation:
Error : Procedure execution failed
1109 - Unknown table 'documents' in field list
Thanks for help