par
Ish » 16 nov. 2006, 12:25
je me suis rendu compte que je ne vous avez pas assez mis de code pour comprendre le truc alors voici
Code : Tout sélectionner
function generer()
{
wEcwUI.clearMessage();
var req;
req = "false";
// SI UN SITE ET UNE USINE sont sélectionnés
if ((Trim(window.frames['Menu'].FMenu2.saisieSite.value)!="")&&(Trim(window.frames['Menu'].FMenu2.saisieUsine.value)!=""))
{
req="select * from(";
// SI UN PI - S/P est renseigné
if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)!="")||(Trim(window.frames['Menu'].FMenu2.saisieSP.value)!=""))
{
if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)!="")&&(Trim(window.frames['Menu'].FMenu2.saisieSP.value)!=""))
req += "Select A.PINCOD as PINCOD,A.PINPI1 as PINPI1,A.INSCOD as INSCOD, A.PINPI2 as PINPI2, A.PINNOM as PINNOM, A.PINDSL as PINDSL, A.FPICOD as FPICOD, A.PINNGE as PINNGE, A.PINDMJ as PINDMJ, A.LGECOD as LGECOD , A.HGECOD as HGECOD , C.CGECOD as CGECOD froM SDWI.SDNQTOPI A, SDWI.SDNQTOHC C where A.PINDFV is null and C.HCEDTF is null and C.PINCOD=A.PINCOD and C.INSCOD=A.INSCOD and A.INSCOD='"+window.frames['Menu'].frm.elements['SiteHI2'].value+"' and A.PINPI1='"+Trim(window.frames['Menu'].FMenu2.saisiePI.value.toUpperCase())+"' and A.PINPI2='"+window.frames['Menu'].FMenu2.saisieSP.value.toUpperCase()+"' ";
else if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)=="") && (Trim(window.frames['Menu'].FMenu2.saisieSP.value)!=""))
req += "Select A.PINCOD as PINCOD,A.PINPI1 as PINPI1,A.INSCOD as INSCOD, A.PINPI2 as PINPI2, A.PINNOM as PINNOM, A.PINDSL as PINDSL, A.FPICOD as FPICOD, A.PINNGE as PINNGE, A.PINDMJ as PINDMJ, A.LGECOD as LGECOD , A.HGECOD as HGECOD , C.CGECOD as CGECOD froM SDWI.SDNQTOPI A, SDWI.SDNQTOHC C where A.PINDFV is null and C.HCEDTF is null and C.PINCOD=A.PINCOD and C.INSCOD=A.INSCOD and A.INSCOD='"+window.frames['Menu'].frm.elements['SiteHI2'].value+"' and A.PINPI2='"+window.frames['Menu'].FMenu2.saisieSP.value.toUpperCase()+"'";
else if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)!="") && (Trim(window.frames['Menu'].FMenu2.saisieSP.value)==""))
req += "Select A.PINCOD as PINCOD,A.PINPI1 as PINPI1,A.INSCOD as INSCOD, A.PINPI2 as PINPI2, A.PINNOM as PINNOM, A.PINDSL as PINDSL, A.FPICOD as FPICOD, A.PINNGE as PINNGE, A.PINDMJ as PINDMJ , A.LGECOD as LGECOD , A.HGECOD as HGECOD , C.CGECOD as CGECOD froM SDWI.SDNQTOPI A, SDWI.SDNQTOHC C where A.PINDFV is null and C.HCEDTF is null and C.PINCOD=A.PINCOD and C.INSCOD=A.INSCOD and A.INSCOD='"+window.frames['Menu'].frm.elements['SiteHI2'].value+"' and A.PINPI1='"+Trim(window.frames['Menu'].FMenu2.saisiePI.value.toUpperCase())+"'";
window.frames['Menu'].FMenu2.saisieNom.value="";
}
....
voila ... donc cela vient surement
window.frames['Menu'].FMenu2 mais je ne vois pas bien en quoi il y a une probleme vu que cela fonctionne sous Internet Explorer !!
je me suis rendu compte que je ne vous avez pas assez mis de code pour comprendre le truc alors voici
[code]
function generer()
{
wEcwUI.clearMessage();
var req;
req = "false";
// SI UN SITE ET UNE USINE sont sélectionnés
if ((Trim(window.frames['Menu'].FMenu2.saisieSite.value)!="")&&(Trim(window.frames['Menu'].FMenu2.saisieUsine.value)!=""))
{
req="select * from(";
// SI UN PI - S/P est renseigné
if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)!="")||(Trim(window.frames['Menu'].FMenu2.saisieSP.value)!=""))
{
if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)!="")&&(Trim(window.frames['Menu'].FMenu2.saisieSP.value)!=""))
req += "Select A.PINCOD as PINCOD,A.PINPI1 as PINPI1,A.INSCOD as INSCOD, A.PINPI2 as PINPI2, A.PINNOM as PINNOM, A.PINDSL as PINDSL, A.FPICOD as FPICOD, A.PINNGE as PINNGE, A.PINDMJ as PINDMJ, A.LGECOD as LGECOD , A.HGECOD as HGECOD , C.CGECOD as CGECOD froM SDWI.SDNQTOPI A, SDWI.SDNQTOHC C where A.PINDFV is null and C.HCEDTF is null and C.PINCOD=A.PINCOD and C.INSCOD=A.INSCOD and A.INSCOD='"+window.frames['Menu'].frm.elements['SiteHI2'].value+"' and A.PINPI1='"+Trim(window.frames['Menu'].FMenu2.saisiePI.value.toUpperCase())+"' and A.PINPI2='"+window.frames['Menu'].FMenu2.saisieSP.value.toUpperCase()+"' ";
else if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)=="") && (Trim(window.frames['Menu'].FMenu2.saisieSP.value)!=""))
req += "Select A.PINCOD as PINCOD,A.PINPI1 as PINPI1,A.INSCOD as INSCOD, A.PINPI2 as PINPI2, A.PINNOM as PINNOM, A.PINDSL as PINDSL, A.FPICOD as FPICOD, A.PINNGE as PINNGE, A.PINDMJ as PINDMJ, A.LGECOD as LGECOD , A.HGECOD as HGECOD , C.CGECOD as CGECOD froM SDWI.SDNQTOPI A, SDWI.SDNQTOHC C where A.PINDFV is null and C.HCEDTF is null and C.PINCOD=A.PINCOD and C.INSCOD=A.INSCOD and A.INSCOD='"+window.frames['Menu'].frm.elements['SiteHI2'].value+"' and A.PINPI2='"+window.frames['Menu'].FMenu2.saisieSP.value.toUpperCase()+"'";
else if ((Trim(window.frames['Menu'].FMenu2.saisiePI.value)!="") && (Trim(window.frames['Menu'].FMenu2.saisieSP.value)==""))
req += "Select A.PINCOD as PINCOD,A.PINPI1 as PINPI1,A.INSCOD as INSCOD, A.PINPI2 as PINPI2, A.PINNOM as PINNOM, A.PINDSL as PINDSL, A.FPICOD as FPICOD, A.PINNGE as PINNGE, A.PINDMJ as PINDMJ , A.LGECOD as LGECOD , A.HGECOD as HGECOD , C.CGECOD as CGECOD froM SDWI.SDNQTOPI A, SDWI.SDNQTOHC C where A.PINDFV is null and C.HCEDTF is null and C.PINCOD=A.PINCOD and C.INSCOD=A.INSCOD and A.INSCOD='"+window.frames['Menu'].frm.elements['SiteHI2'].value+"' and A.PINPI1='"+Trim(window.frames['Menu'].FMenu2.saisiePI.value.toUpperCase())+"'";
window.frames['Menu'].FMenu2.saisieNom.value="";
}
.... [/code]
voila ... donc cela vient surement [b]window.frames['Menu'].FMenu2[/b] mais je ne vois pas bien en quoi il y a une probleme vu que cela fonctionne sous Internet Explorer !!