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 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46
| Le champ 'TABLE_Lancements' n'a pas pu s'initialiser, car il a rencontré l'erreur HyperFileSQL suivante :
=============================
Erreur de l'accès OLE DB.
Numéro d'erreur = 170129
Echec de l'ouverture du fichier.
=============================
Détail de l'erreur système :
Description = L'identificateur en plusieurs parties "art.art_reference" ne peut pas être lié.
Source = Microsoft OLE DB Provider for SQL Server
SQL State = 42000
Error Number = -2147217900 (0x80040e14)
Native Error Number = 4104 (0x1008)
Erreur de l'accès OLE DB.
Numéro d'erreur = 170129
Texte de la requête : SELECT "nof"."nof_of_id"
AS "nof_of_id" , "nof"."nof_op" AS "nof_op" , "nof"."nof_fourniture"
AS "nof_fourniture" , "nof"."nof_qte_lien"
AS "nof_qte_lien" , "nof"."nof_qte_necessaire"
AS "nof_qte_necessaire" , "nof"."nof_qte_lancee"
AS "nof_qte_lancee" , "nof"."nof_prix_revient"
AS "nof_prix_revient" , "ofs"."of_id" AS "of_id" , "ofs"."of_num"
AS "of_num" , "ofs"."of_article_id" AS "of_article_id" , "ofs"."of_delai"
AS "of_delai" , "ofs"."of_commande"
AS "of_commande" , "ofs"."of_qte_lancee"
AS "of_qte_lancee" , "ofs"."of_lance_le"
AS "of_lance_le" , "ofs"."of_lance_par" AS "of_lance_par" , "ofs"."of_termine"
AS "of_termine" , "ofs"."of_index" AS "of_index" , "stck"."stck_article"
AS "stck_article" , "stck"."stck_qte" AS "stck_qte" , "stck"."stck_attendu"
AS "stck_attendu" , "stck"."stck_besoin" AS "stck_besoin" , "t1"."art_id"
AS "art_id" , "t1"."art_reference" AS "art_reference" , "t1"."art_designation"
AS "art_designation" , "t1"."art_um" AS "art_um" , "t1"."art_empl"
AS "art_empl" , "t1"."art_casier" AS "art_casier" , "t1"."art_appro"
AS "art_appro" , "t1"."art_stock_secu" AS "art_stock_secu" , "t1"."art_prix_vente" AS "art_prix_vente" , "t1"."art_prix_achat" AS "art_prix_achat" , "t1"."art_prix_revient" AS "art_prix_revient" , "t2"."art_id" AS "art_id1" , "t2"."art_reference" AS "art_reference1" , "t2"."art_designation" AS "art_designation1" , "t2"."art_um" AS "art_um1" , "t2"."art_empl" AS "art_empl1" , "t2"."art_casier" AS "art_casier1" , "t2"."art_appro" AS "art_appro1" , "t2"."art_stock_secu" AS "art_stock_secu1" , "t2"."art_prix_vente" AS "art_prix_vente1" , "t2"."art_prix_achat" AS "art_prix_achat1" , "t2"."art_prix_revient" AS "art_prix_revient1" , "t1"."art_reference" AS "produit" , "t2"."art_reference" AS fourniture , ( "nof"."nof_qte_necessaire" - "nof"."nof_qte_lancee" ) AS "reste"
FROM "nof" , "ofs" , "stck" , "art" "t1" , "art" "t2"
WHERE ( ( ( ( ( "ofs"."of_article_id" = "t1"."art_id" ) AND ( "nof"."nof_fourniture" = "t2"."art_id" ) ) AND ( "nof"."nof_fourniture" = "stck"."stck_article" ) ) AND ( "nof"."nof_of_id" = "ofs"."of_id" ) ))
AND ( ( "art"."art_reference" LIKE '%%' AND "art"."art_reference" LIKE '%%' ))
ORDER BY "ofs"."of_id" DESC,"nof"."nof_op","stck"."stck_article","t1"."art_id","nof"."nof_of_id","nof"."nof_fourniture","nof"."nof_qte_lien","nof"."nof_qte_necessaire","nof"."nof_qte_lancee","nof"."nof_prix_revient","ofs"."of_num","ofs"."of_article_id","ofs"."of_delai","ofs"."of_commande","ofs"."of_qte_lancee","ofs"."of_lance_le","ofs"."of_lance_par","ofs"."of_termine","ofs"."of_index","stck"."stck_qte","stck"."stck_attendu","stck"."stck_besoin","t1"."art_reference","t1"."art_um","t1"."art_empl","t1"."art_casier","t1"."art_appro","t1"."art_stock_secu","t1"."art_prix_vente","t1"."art_prix_achat","t1"."art_prix_revient",46
Nombre de paramètres : 0
IEWDOLDB=111.6
Module=<WDOLDB>
Version=<17.0.21.0> |
Partager