Information générale
Catégorie:
Codage, syntaxe et commandes
>>>Hello all,
>>>
>>>
>>>Error 11 (Function argument value, type, or count is invalid)
>>>
>>>SELECT DATE (Ann_Fisc, Periode, Jour) AS DtFisc, Mnt_PPA, Mnt_Depot;
>>> FROM PPA_Det;
>>> WHERE (No_Parten == PPA_Ent.No_Parten) AND (ALLTRIM (No_Facture) == ALLTRIM (PPA_Ent.No_Facture));
>>> AND (DATE (Ann_Fisc, Periode, Jour) => THISFORM.cntPPA.txtDtPrel.Value);
>>> AND (DATE (Ann_Fisc, Periode, Jour) > loParaPPA.dJour_Ferme);
>>> INTO CURSOR curAjoutPPA
>>>
>>>This gives me error 11 in my app.
>>>
>>>When I do this in a command box
>>>
>>>SELECT DATE (Ann_Fisc, Periode, Jour) AS DtFisc, Mnt_PPA, Mnt_Depot;
>>>FROM PPA_Det;
>>>WHERE (No_Parten == PPA_Ent.No_Parten) AND (ALLTRIM (No_Facture) == ALLTRIM (PPA_Ent.No_Facture));
>>> AND (DATE (Ann_Fisc, Periode, Jour) => {^2021.03.01});
>>> AND (DATE (Ann_Fisc, Periode, Jour) > {^2021.01.15})
>>>
>>>Everything is fine. Any idea why I would get an error 11 only in my app?
>>
>>Are you sure that THISFORM.cntPPA.txtDtPrel.Value is a date type value, and not a string that must be converted into a date?
>
>When I move my mouse cursor over it it displays
>{2021.03.01}
Do you have your SET DATE format set to ANSI?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement