General information
Category:
Coding, syntax & commands
>>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only