Is there a definitive list of the types that can be used as parameter values with SPT?
I used to try different types - object properties, table variables, etc. but finally gave up and converted everything to memvars, as you did here.



>It's the => THISFORM.cntPPA.txtDtPrel.Value that is the problem...
>
>
>Try this ...
>in your code put:
>
>lcVarName = THISFORM.cntPPA.txtDtPrel.Value
>
>...then change => THISFORM.cntPPA.txtDtPrel.Value to >= ?lcVarName
>
>and it should work.
>
>>= ( ?ldTimeDateMinusYear )
>
>>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) =) => THISFORM.cntPPA.txtDtPrel.Value= 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?