Notice: Undefined index: NoFacture in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 8

Notice: Undefined index: num_ope in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 9

Notice: Undefined index: saisie in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 17

Notice: Undefined index: num_ope_prepa in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 18

Notice: Undefined index: annule in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 19

Notice: Undefined index: supplot in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 25

Notice: Undefined index: addlot in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 29

Notice: Undefined index: valprep in C:\Pharmavitale\Fichiers\PHP\Prog\page\page_prepcom.php on line 33
Pharm@Vitale

Preparation de la Commande Erreur SQL !
SELECT cip_prod,prod_factures.nom_prod,prod_factures.code_uv,libelle_civilite,assure.nom,assure.prenom,nolot,dbo.formatdate(date_perim,'dd/mm/yyyy') as date_perim, assure.index_assure,dbo.formatdate(factures.DateFacture,'dd/mm/yyyy'),nolot_pdt.qte,prod_factures.quantite,prod_factures.ordre_prod, factures.noBL,factures.index_typefacture,nolot_pdt.colis,libelle_geo,nb_stock,factures.index_liv_veto FROM ((prod_factures left join ((produit left join stock on produit.code_uv=stock.code_uv) left join geo on produit.code_geo=geo.code_geo) on prod_factures.code_uv=produit.code_uv) left join nolot_pdt on prod_factures.Nofacture=nolot_pdt.nofacture and prod_factures.code_uv=nolot_pdt.code_uv) left join (factures left join (assure left join civilites on assure.id_civilite=civilites.id_civilite) on factures.index_assure=assure.index_assure) on prod_factures.NoFacture=factures.NoFacture where prod_factures.NoFacture= and cip_prod<>'*' and cip_prod<>'/' order by CASE WHEN colis is null or colis=0 THEN 9999 ELSE colis END,libelle_geo,prod_factures.ordre_prod,nolot